Cannot add product

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

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

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.

nicolas wrote: Here is the documentation relative to that:
www.hikashop.com/en/support/documentatio...lity-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.