[Skip to main content](#vessel-content) # Cannot add product ## - **[Smiler](/forum/user/2107-smiler "View Smiler's Profile")** - [![Smiler's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2107.jpg)](/forum/user/2107-smiler "View Smiler's Profile") Topic Author - [ Offline](/forum/user/2107-smiler) Less More - Posts: 52 - Thank you received: 2 - - - - [](http://www.arran-cats.com) - 15 years 5 months ago - 15 years 5 months ago [\#17411](#17411) by [Smiler](/forum/user/2107-smiler "View Smiler's Profile") *[Cannot add product](/forum/3-bug-report/17411-cannot-add-product#17411 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* was created by *[Smiler](/forum/user/2107-smiler "View Smiler's Profile")* Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff. Last edit: 15 years 5 months ago by [Smiler](/forum/user/2107-smiler "View Smiler's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 5 months ago [\#17412](#17412) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#17412 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* Could you try to activate the joomla debug mode in the configuration of joomla and try again ? That should display another error message which should give more information about the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Smiler](/forum/user/2107-smiler "View Smiler's Profile")** - [![Smiler's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2107.jpg)](/forum/user/2107-smiler "View Smiler's Profile") Topic Author - [ Offline](/forum/user/2107-smiler) Less More - Posts: 52 - Thank you received: 2 - - - - [](http://www.arran-cats.com) - 15 years 5 months ago - 15 years 5 months ago [\#17415](#17415) by [Smiler](/forum/user/2107-smiler "View Smiler's Profile") Replied by *[Smiler](/forum/user/2107-smiler "View Smiler's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#17415 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* Nicolas, Hope the attached DOC gives a clue ![:)](/media/kunena/emoticons/3.png ":)") Regards, Jeff. #### *This attachment is hidden for guests. Please log in or register to see it.* Last edit: 15 years 5 months ago by [Smiler](/forum/user/2107-smiler "View Smiler's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 5 months ago [\#17416](#17416) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#17416 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* You can either do that: [ www.hikashop.com/en/support/forum/3-bug-...or-saving.html#15303](http://www.hikashop.com/en/support/forum/3-bug-report/15294-bug-with-149-version-error-saving.html#15303) or that: [ www.hikashop.com/support/forum/3-bug-rep...t.html?lang=en#12117](http://www.hikashop.com/support/forum/3-bug-report/12103-error-saving-product.html?lang=en#12117) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Smiler](/forum/user/2107-smiler "View Smiler's Profile")** - [![Smiler's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2107.jpg)](/forum/user/2107-smiler "View Smiler's Profile") Topic Author - [ Offline](/forum/user/2107-smiler) Less More - Posts: 52 - Thank you received: 2 - - - - [](http://www.arran-cats.com) - 15 years 5 months ago [\#17417](#17417) by [Smiler](/forum/user/2107-smiler "View Smiler's Profile") Replied by *[Smiler](/forum/user/2107-smiler "View Smiler's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#17417 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* Solved! I ran the SQL query and it's all working again. Incidentally, I first tried the "modify version number" trick but that didn't work. Many thanks Nocolas brilliant support as always, have a beer on me :woohoo: Regards, Jeff. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile")** - [![chrisdowns's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11098-chrisdowns "View chrisdowns's Profile") - [ Offline](/forum/user/11098-chrisdowns) Less More - Posts: 2 - Thank you received: 0 - - 13 years 3 months ago [\#115816](#115816) by [chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile") Replied by *[chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#115816 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* I'm now having this problem with hikashop. I have tried looking for the relevant line in the PHP file to copy the SQL query from, but it's not there. "product_canonical" (which is what the debug mode error output reveals) does not appear anywhere, so I have no SQL query to run. Hikashop failed to update with a 500 Internal Server Error before this, and now the webshop is useless. There really should be a clearer warning about the method that Hikashop uses to update - every other Joomla add-on manages it ok, and Joomla can update itself just fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 13 years 3 months ago [\#115888](#115888) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#115888 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* Here is the documentation relative to that: [ www.hikashop.com/en/support/documentatio...lity-issues.html#SQL](http://www.hikashop.com/en/support/documentation/61-hikashop-compatibility-issues.html#SQL) As explained, you will find the query that you need to run in the file administrator/components/com_hikashop/install.hikashop.php If you're missing the product_canonical field in the product table, it's that query that you need to run: ALTER TABLE `#__hikashop_product` ADD `product_canonical` VARCHAR( 255 ) NOT NULL DEFAULT ''; (make sure that you replace the table prefix, as explained in the documentation) The following user(s) said Thank You: [chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile")** - [![chrisdowns's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11098-chrisdowns "View chrisdowns's Profile") - [ Offline](/forum/user/11098-chrisdowns) Less More - Posts: 2 - Thank you received: 0 - - 13 years 3 months ago [\#115981](#115981) by [chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile") Replied by *[chrisdowns](/forum/user/11098-chrisdowns "View chrisdowns's Profile")* on topic *[Re: Cannot add product](/forum/3-bug-report/17411-cannot-add-product#115981 "Hikashop Essentials V1.50, Joomla 1.6 Up until today, we only had one product for sale but I just tried adding another product in a different category and it refused to save. The only error message is "Error Saving". If I try to do anything with the only product we do have the error message says " A product with the same code already exists. Error Saving" but this is our only product. Incidentally, the product I tried to add had a totally different code to the existing one. Any ideas what has happened? Regards, Jeff.")* > nicolas wrote: Here is the documentation relative to that: > [ www.hikashop.com/en/support/documentatio...lity-issues.html#SQL](http://www.hikashop.com/en/support/documentation/61-hikashop-compatibility-issues.html#SQL) > As explained, you will find the query that you need to run in the file administrator/components/com\_hikashop/install.hikashop.php > > If you're missing the product\_canonical field in the product table, it's that query that you need to run: > ALTER TABLE `#\_\_hikashop\_product` ADD `product\_canonical` VARCHAR( 255 ) NOT NULL DEFAULT ''; > > (make sure that you replace the table prefix, as explained in the documentation) Yes, install.hikashop.php was where I looked, but there is no occurence of the "product_canonical" field that is indicated in the 1054 error given by Joomla in debug mode, so I wasn't sure what SQL query to run, but you have now told me, so thank you. I ran the query and it worked, but it turned out that a second field was missing too (product_msrp). Ran the query on that and it's all fixed, thank you very much. The built-in updater now works too and I have the latest version of HikaShop once more. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNzQxMS1jYW5ub3QtYWRkLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.097 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)