[Skip to main content](#vessel-content) # SQL=SELECT category\_id FROM xxxx\_hikashop ## - **[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")** - [![hnelke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12240-hnelke "View hnelke's Profile") Topic Author - [ Offline](/forum/user/12240-hnelke) Less More - Posts: 24 - Thank you received: 0 - - - 13 years 11 months ago - 13 years 11 months ago [\#81300](#81300) by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile") *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81300 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* was created by *[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")* Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert Last edit: 13 years 11 months ago by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")** - [![hnelke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12240-hnelke "View hnelke's Profile") Topic Author - [ Offline](/forum/user/12240-hnelke) Less More - Posts: 24 - Thank you received: 0 - - - 13 years 11 months ago [\#81345](#81345) by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile") Replied by *[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81345 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* Hello I'm again. I test the sql query direct over PHPadmin and I got the following result!!! SQL-Befehl: SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id =4 OR product_parent_id =4 ORDER BY product_category_id ASC LIMIT 0 , 30 MySQL meldet: \#1054 - Unknown column 'product_parent_id' in 'where clause' I think there is something wrong in the Hikashop code! I touch no hika-file!! Hubert Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")** - [![hnelke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12240-hnelke "View hnelke's Profile") Topic Author - [ Offline](/forum/user/12240-hnelke) Less More - Posts: 24 - Thank you received: 0 - - - 13 years 11 months ago [\#81351](#81351) by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile") Replied by *[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81351 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* Hi, I'am again. I fixed it by alter the table (add field product_category_id / table xxx_product_category)! I hope there are no dependencies to other querys or code?? But I wonder, that this happens with a "commercial" software!! Regards Hubert Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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: 4080 - - [](http://obsi.dev) - 13 years 11 months ago [\#81382](#81382) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81382 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* Hi, The column "product_parent_id" is include in the "tables.sql" file which is used during the first installation. Otherwise, when you update HikaShop, some script and query are processed. You can see them into the file "install.hikashop.php". If your column "product_parent_id" is missing, it is highly possible that other new columns are missing too (like "order_invoice_id" and "order_invoice_number"). Did you have problems during the HikaShop update ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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: 4080 - - [](http://obsi.dev) - 13 years 11 months ago [\#81383](#81383) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81383 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* > hnelke wrote: I got error 0???? > SQL=SELECT category\_id FROM nelkies101212\_hikashop\_product\_category WHERE product\_id=4 OR product\_parent\_id=4 ORDER BY product\_category\_id ASC Joomla 3.0 have a bug which has been reported by the HikaShop team. Our patch should be include in the future release. You can use "hikamysqli" module if you want to have complete SQL error description in Joomla 3. [ www.hikashop.com/en/forum/2-general-talk...p-20-beta.html#72321](http://www.hikashop.com/en/forum/2-general-talk-about-hikashop/72191-hikashop-20-beta.html#72321) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")** - [![hnelke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12240-hnelke "View hnelke's Profile") Topic Author - [ Offline](/forum/user/12240-hnelke) Less More - Posts: 24 - Thank you received: 0 - - - 13 years 11 months ago - 13 years 11 months ago [\#81391](#81391) by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile") Replied by *[hnelke](/forum/user/12240-hnelke "View hnelke's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81391 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* Hello, thanks for the reply. I do not understand exactly, what I have to do But I think it is better to do not use hikashop 2.x with Joomla 3.x? Do you or Hika recommend hikashop 2.x with Joomla 3.x?? Hubert Last edit: 13 years 11 months ago by [hnelke](/forum/user/12240-hnelke "View hnelke's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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: 4080 - - [](http://obsi.dev) - 13 years 11 months ago [\#81406](#81406) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[SQL=SELECT category\_id FROM xxxx\_hikashop](/forum/3-bug-report/76620-sql-select-category-id-from-xxxx-hikashop#81406 "Hello, I got error 0???? SQL=SELECT category_id FROM nelkies101212_hikashop_product_category WHERE product_id=4 OR product_parent_id=4 ORDER BY product_category_id ASC by clicking/showing product details. I have only 1 category and 1 product. System: Joomla 3.02 Hikashop: Latest stable version : 2.0.0 Thanks Hubert")* Hi, Older versions of HikaShop (less than 2.0) are not compatible with Joomla 3.0 When installing HikaShop 2.0, the tables are created and the column "product_parent_id" is right present in the SQL script. So, I am wondering how HikaShop has been installed on your website. Is there a beta version before ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [hnelke](/forum/user/12240-hnelke "View hnelke's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjYyMC1zcWwtc2VsZWN0LWNhdGVnb3J5LWlkLWZyb20teHh4eC1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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.080 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)