[Skip to main content](#vessel-content) # Error after update with product page ## - **[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")** - [![ssnobben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10468-ssnobben "View ssnobben's Profile") Topic Author - [ Offline](/forum/user/10468-ssnobben) Less More - Posts: 69 - Thank you received: 4 - - - 14 years 1 hour ago - 14 years 23 minutes ago [\#76337](#76337) by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#76337 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* was created by *[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")* Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) **Error SQL=SELECT category\_id FROM jos\_hikashop\_product\_category WHERE product\_id=1 OR product\_parent\_id=1 ORDER BY ordering ASC** I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0 Last edit: 14 years 23 minutes ago by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 11 months ago [\#76451](#76451) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#76451 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Hi, Sorry we have forgot a line in the install.hikashop.php file. A column is missing in your database, thanks to go in your phpMyAdmin, and execute the following request: Code: ALTER TABLE `#__hikashop_product_category` ADD `product_parent_id` INT NOT NULL DEFAULT '0'; Replace "#_" by your database prefix. The following user(s) said Thank You: [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")** - [![ssnobben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10468-ssnobben "View ssnobben's Profile") Topic Author - [ Offline](/forum/user/10468-ssnobben) Less More - Posts: 69 - Thank you received: 4 - - - 13 years 11 months ago - 13 years 11 months ago [\#77311](#77311) by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") Replied by *[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#77311 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Hi dont forget see above.. (the difference between "__"(double underline) and "_"(single underline))in the explanation above..ALTER TABLE `#__hikashop_product_category` ADD `product_parent_id` INT NOT NULL DEFAULT '0'; should be > ALTER TABLE `#\_hikashop\_product\_category` ADD `product\_parent\_id` INT NOT NULL DEFAULT '0'; Last edit: 13 years 11 months ago by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 13 years 11 months ago [\#77314](#77314) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#77314 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Hi, No. We said you should replace "#_" by your database prefix. So, if your database prefix is "jos", the table name would be "jos_hikashop_product_category". As Nicolas said. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")** - [![ssnobben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10468-ssnobben "View ssnobben's Profile") Topic Author - [ Offline](/forum/user/10468-ssnobben) Less More - Posts: 69 - Thank you received: 4 - - - 13 years 11 months ago [\#77324](#77324) by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") Replied by *[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#77324 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Hi I got this error too when trying to add menu to "Listing categories" after adding this.. Error SQL=SELECT count(a.product_id) AS number_of_products,a.category_id FROM jos_hikashop_product_category AS a INNER JOIN jos_hikashop_product AS b ON a.product_id=b.product_id AND b.product_published>0 AND product_parent_id=0 WHERE a.category_id IN (17,18) GROUP BY a.category_id ps Jerome I did understand to change the # by my database prefix b u t this was not correct `#__hikashop ---> should be `#_hikashop rgds Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 11 months ago - 13 years 11 months ago [\#77397](#77397) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#77397 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Hi, In the file: "components/com_hikashop/views/cateogry/view.html.php" in the function "listing()" replace the code: Code: $database->setQuery('SELECT count(a.product_id) AS number_of_products,a.category_id FROM '.hikashop_table('product_category').' AS a INNER JOIN '.hikashop_table('product').' AS b ON a.product_id=b.product_id AND b.product_published>0 AND product_parent_id=0 WHERE a.category_id IN ('.implode(',',$ids).') GROUP BY a.category_id'); By: Code: $database->setQuery('SELECT count(a.product_id) AS number_of_products,a.category_id FROM '.hikashop_table('product_category').' AS a INNER JOIN '.hikashop_table('product').' AS b ON a.product_id=b.product_id AND b.product_published>0 AND b.product_parent_id=0 WHERE a.category_id IN ('.implode(',',$ids).') GROUP BY a.category_id'); It had been already corrected on our end. Last edit: 13 years 11 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile"). The following user(s) said Thank You: [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")** - [![ssnobben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10468-ssnobben "View ssnobben's Profile") Topic Author - [ Offline](/forum/user/10468-ssnobben) Less More - Posts: 69 - Thank you received: 4 - - - 13 years 11 months ago [\#77449](#77449) by [ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile") Replied by *[ssnobben](/forum/user/10468-ssnobben "View ssnobben's Profile")* on topic *[Error after update with product page](/forum/3-bug-report/75773-error-after-update-with-product-page#77449 "Hi after doing a new update today for a HikaShop 2.0 in back end I got this error for changing things for the product and also on front end.(disable all the cache and no SEFs) Error SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 OR product_parent_id=1 ORDER BY ordering ASC I also tried to add a new product to a category and got this error when clicking on the category that worked but error when clicking on the product 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=2 OR product_parent_id=2 ORDER BY ordering ASC Any tips to fix this or is this a bug? I tried to remove alla categories and products but the error appear anyhow when new set up with categories and products. The error appear when clicking on the product. 0 SQL=SELECT category_id FROM jos_hikashop_product_category WHERE product_id=3 OR product_parent_id=3 ORDER BY ordering ASC rgds Joomla 3.0.2 and HikaShop 2.0")* Thanks that did it! Now everything works.. ![:P](/media/kunena/emoticons/14.png ":P") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NTc3My1lcnJvci1hZnRlci11cGRhdGUtd2l0aC1wcm9kdWN0LXBhZ2U/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.064 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)