Can't add to cart

I have made an upgrade from joomla 1.5 to 2.5
And copy all the tables from hikashop from the old joomla.
Then, i upgrade hikashop to the lastest release 2.1.3
All seems to be working but when i click to add a product to cart, nothing happens.
The product doesn't add to cart

Hi,

Do you have a link to your store or more information ?
I think something has been forgotten during the upgrade, but it is quite difficult to say what like that.

Regards,

www.minhohosting.com/index.php/catalogo-de-produtos

My hikashop subscription is attached to geopt.org but this is a temporary site for testing before we upgrade the geopt.org

Hi,

Do you have the joomla cache activated ? Or the system cache plugin ?

Regards,

All disable.
Joomla cache plugin OFF.
Global configuration/System/Cache OFF
Global configuration/System/Session Handler None

Please turn on the debug mode and the error reporting options of the joomla configuration and try again.

Do you get some errors now ?

nicolas wrote: Please turn on the debug mode and the error reporting options of the joomla configuration and try again.

Do you get some errors now ?

Debug ON and Error Reporting to Developer

No errors, same problem

Hi,

Thanks to give us a backend access and a ftp one too in order to debug your problem.
You can send it via pm.

Xavier wrote: Hi,

Thanks to give us a backend access and a ftp one too in order to debug your problem.
You can send it via pm.

Message Sent

Hi,

You configuration seems to be ok, I need the ftp access too.

Thanks to give us a backend access and a ftp one too in order to debug your problem.

Xavier wrote: Hi,

You configuration seems to be ok, I need the ftp access too.

Thanks to give us a backend access and a ftp one too in order to debug your problem.

PM sent.
Thank you for your help

Sorry but I have a 530 error login failed with the given ftp access.

Xavier wrote: Sorry but I have a 530 error login failed with the given ftp access.

I'm sorry.
The username is hikashop@minhohosting.com

Any news?

Hi,

I check your files and your store. I see some strange things in the backend.
When I save a product, his prices are duplicated.
If I remove all prices for a product (which contains only duplicated prices) and after that, resave the product with the correct price. I got a database error.

When HikaShop try to create the cart in the database and insert the product in the cart, it results an error, the insertion failed.
That's why it is not possible for HikaShop to add a product to the cart.

I don't know how you made your migration, but I think some database tables are not up-to-date or have been corrupted with some incorrect data.
What have you done for your migration ?

Regards,

Copy Old tables To the new database and run upgrade of hikashop.
Do you think i should try To do it again?

Even if i create a new article the sql insert is not complete :S
INSERT IGNORE INTO `furk8_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_description`,`product_modified`,`product_created` )
VALUES ( 'xxx','','','','','','','xxx','11','0','','-1','0','0','','','','','kg','','','m','','1','main','<p>xxx</p>','1368961781','1368961781'

it saves in the database but the product id=0

Hi,

The product_id can't be 0 by definition of the database.
Your database schema are broken. The product_id is a unique identifier with "auto increment", so the id will grow up and it is not possible, by definition to have "0".
Are you sure you have right copy or rename your tables ?

Best is having same HikaShop version installed in both sites and copy the data from the first one to the second.
SQL structure has to be preserved (and the database can change between HikaShop version, so the same version has to be installed in both sites).

Regards,