[Skip to main content](#vessel-content)

#   Error: 1054 Unknown column 'product\_parent\_id'

##

- **[Hossain](/forum/user/15876-hossain "View Hossain's Profile")**
- [![Hossain's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15876-hossain "View Hossain's Profile") Topic Author
- [ Offline](/forum/user/15876-hossain)

Less More

- Posts: 5
- Thank you received: 0
-
-

13 years 7 months ago [\#97025](#97025) by [Hossain](/forum/user/15876-hossain "View Hossain's Profile")  *[Error: 1054 Unknown column 'product\_parent\_id'](/forum/4-how-to/79862-error-1054-unknown-column-product-parent-id#97025 "Hi, Now I'm getting error when click on a product image/link. I have freshly filled all necessary details of a product. It shows in home page under categories/latest item perfectly (with image). But when click on the image/link, it show the following error:  1054 Unknown column 'product&#95;parent&#95;id' in 'where clause' SQL=SELECT category&#95;id FROM rfrl2&#95;hikashop&#95;product&#95;category WHERE product&#95;id=89 OR product&#95;parent&#95;id=89  I have attached here the screen shot of the page as well as phpMyadmin page.  Is there any simple solution rather than fixing every line in the db? Pleaseeeee. Thanks Hossain")* was created by *[Hossain](/forum/user/15876-hossain "View Hossain's Profile")*

Hi, Now I'm getting error when click on a product image/link.
I have freshly filled all necessary details of a product. It shows in home page under categories/latest item perfectly (with image). But when click on the image/link, it show the following error:

1054 Unknown column 'product_parent_id' in 'where clause' SQL=SELECT category_id FROM rfrl2_hikashop_product_category WHERE product_id=89 OR product_parent_id=89

[ ![Error&#95;1054.jpg](/forum/attachment/9413) ](/forum/attachment/9413 "Error&#95;1054.jpg")

I have attached here the screen shot of the page as well as phpMyadmin page.

Is there any simple solution rather than fixing every line in the db? Pleaseeeee.
Thanks
Hossain

- [ ![Error&#95;1054.jpg](/forum/attachment/9413) ](/forum/attachment/9413 "Error&#95;1054.jpg") [ ](/forum/attachment/9413?download=1 "Error&#95;1054.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc5ODYyLWVycm9yLTEwNTQtdW5rbm93bi1jb2x1bW4tcHJvZHVjdC1wYXJlbnQtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14279
-
-

13 years 7 months ago [\#97049](#97049) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1054 Unknown column 'product\_parent\_id'](/forum/4-how-to/79862-error-1054-unknown-column-product-parent-id#97049 "Hi, Now I'm getting error when click on a product image/link. I have freshly filled all necessary details of a product. It shows in home page under categories/latest item perfectly (with image). But when click on the image/link, it show the following error:  1054 Unknown column 'product&#95;parent&#95;id' in 'where clause' SQL=SELECT category&#95;id FROM rfrl2&#95;hikashop&#95;product&#95;category WHERE product&#95;id=89 OR product&#95;parent&#95;id=89  I have attached here the screen shot of the page as well as phpMyadmin page.  Is there any simple solution rather than fixing every line in the db? Pleaseeeee. Thanks Hossain")*

Hi,

That error was present in a previous version of HikaShop.
Make sure you're using the latest version and you should not have the problem.

The following user(s) said Thank You: [Hossain](/forum/user/15876-hossain "View Hossain's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc5ODYyLWVycm9yLTEwNTQtdW5rbm93bi1jb2x1bW4tcHJvZHVjdC1wYXJlbnQtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation.

- **[Hossain](/forum/user/15876-hossain "View Hossain's Profile")**
- [![Hossain's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15876-hossain "View Hossain's Profile") Topic Author
- [ Offline](/forum/user/15876-hossain)

Less More

- Posts: 5
- Thank you received: 0
-
-

13 years 7 months ago [\#97149](#97149) by [Hossain](/forum/user/15876-hossain "View Hossain's Profile")  Replied by *[Hossain](/forum/user/15876-hossain "View Hossain's Profile")* on topic *[Error: 1054 Unknown column 'product\_parent\_id'](/forum/4-how-to/79862-error-1054-unknown-column-product-parent-id#97149 "Hi, Now I'm getting error when click on a product image/link. I have freshly filled all necessary details of a product. It shows in home page under categories/latest item perfectly (with image). But when click on the image/link, it show the following error:  1054 Unknown column 'product&#95;parent&#95;id' in 'where clause' SQL=SELECT category&#95;id FROM rfrl2&#95;hikashop&#95;product&#95;category WHERE product&#95;id=89 OR product&#95;parent&#95;id=89  I have attached here the screen shot of the page as well as phpMyadmin page.  Is there any simple solution rather than fixing every line in the db? Pleaseeeee. Thanks Hossain")*

Thanks Nichole. Yes I have reinstalled HikaShop (downloaded freshly) and now the problem has gone.

Many Thanks
Hossain

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc5ODYyLWVycm9yLTEwNTQtdW5rbm93bi1jb2x1bW4tcHJvZHVjdC1wYXJlbnQtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.063 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
