[Skip to main content](#vessel-content) # Check Database Errors ## - **[herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile")** - [![herb200mph's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46118-herb200mph "View herb200mph's Profile") Topic Author - [ Offline](/forum/user/46118-herb200mph) Less More - Posts: 81 - Thank you received: 0 - - 8 years 3 months ago [\#295602](#295602) by [herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile") *[Check Database Errors](/forum/25-install-update/895312-check-database-errors#295602 "-- url of the page with the problem -- : shop.justducks.co.uk -- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8 10 -- PHP version -- : latest -- Browser(s) name and version -- : all Can anyone provide a solution to the database errors, the text of which is here: ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR product_category_id =' at line 1 ERROR Duplicate entry '' for key 'PRIMARY' ERROR Incorrect column specifier for column 'product_category_id' We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within. Any help or suggestions would be appreciated. P.S. Checking, repairing, etc. of the MySQL database to no avail.")* was created by *[herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile")* -- url of the page with the problem -- : [ shop.justducks.co.uk](https://shop.justducks.co.uk) -- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8 10 -- PHP version -- : latest -- Browser(s) name and version -- : all Can anyone provide a solution to the database errors, the text of which is here: ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR product_category_id =' at line 1 ERROR Duplicate entry '' for key 'PRIMARY' ERROR Incorrect column specifier for column 'product_category_id' We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within. Any help or suggestions would be appreciated. P.S. Checking, repairing, etc. of the MySQL database to no avail. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NTMxMi1jaGVjay1kYXRhYmFzZS1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 8 years 3 months ago [\#295612](#295612) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Check Database Errors](/forum/25-install-update/895312-check-database-errors#295612 "-- url of the page with the problem -- : shop.justducks.co.uk -- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8 10 -- PHP version -- : latest -- Browser(s) name and version -- : all Can anyone provide a solution to the database errors, the text of which is here: ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR product_category_id =' at line 1 ERROR Duplicate entry '' for key 'PRIMARY' ERROR Incorrect column specifier for column 'product_category_id' We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within. Any help or suggestions would be appreciated. P.S. Checking, repairing, etc. of the MySQL database to no avail.")* Hello, Can you use the "Check database" option through the page "Hikashop->System->Configuration" and test it again ? Thank you. Best regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NTMxMi1jaGVjay1kYXRhYmFzZS1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile")** - [![herb200mph's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46118-herb200mph "View herb200mph's Profile") Topic Author - [ Offline](/forum/user/46118-herb200mph) Less More - Posts: 81 - Thank you received: 0 - - 8 years 3 months ago [\#295635](#295635) by [herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile") Replied by *[herb200mph](/forum/user/46118-herb200mph "View herb200mph's Profile")* on topic *[Check Database Errors](/forum/25-install-update/895312-check-database-errors#295635 "-- url of the page with the problem -- : shop.justducks.co.uk -- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8 10 -- PHP version -- : latest -- Browser(s) name and version -- : all Can anyone provide a solution to the database errors, the text of which is here: ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR product_category_id =' at line 1 ERROR Duplicate entry '' for key 'PRIMARY' ERROR Incorrect column specifier for column 'product_category_id' We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within. Any help or suggestions would be appreciated. P.S. Checking, repairing, etc. of the MySQL database to no avail.")* Checked it at 7 a.m. U.S. Eastern Time and the same errors are given as per original issue report. Please advise. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NTMxMi1jaGVjay1kYXRhYmFzZS1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 8 years 3 months ago [\#295640](#295640) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Check Database Errors](/forum/25-install-update/895312-check-database-errors#295640 "-- url of the page with the problem -- : shop.justducks.co.uk -- HikaShop version -- : 3.5.0 -- Joomla version -- : 3.8 10 -- PHP version -- : latest -- Browser(s) name and version -- : all Can anyone provide a solution to the database errors, the text of which is here: ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR product_category_id =' at line 1 ERROR Duplicate entry '' for key 'PRIMARY' ERROR Incorrect column specifier for column 'product_category_id' We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within. Any help or suggestions would be appreciated. P.S. Checking, repairing, etc. of the MySQL database to no avail.")* Hi, We'll need more information about the error to be able to understand where the issue comes form. Please do that modification: [ www.hikashop.com/support/forum/2-general...ror-1054.html#287524](https://www.hikashop.com/support/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054.html#287524) And also activate the debug mode and error reporting settings of the Joomla configuration. Then, display the page with the issue again and provide all the details available about the error on that page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NTMxMi1jaGVjay1kYXRhYmFzZS1lcnJvcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.086 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)