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.

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.

Nicolas,

Hope the attached DOC gives a clue

Regards, Jeff.

You can either do that: www.hikashop.com/en/support/forum/3-bug-...or-saving.html#15303
or that: www.hikashop.com/support/forum/3-bug-rep...t.html?lang=en#12117

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.

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.

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)

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.