Hi cc peeps,

I have followed the upgrade process from a 3.0.10 - 3.0.14 store very carefully. Now when I reach the submit choice of payment gateway ('Continue' button) at www.mystore/cart.php?act=step5
I get the following MySQL Error:

MySQL Error Occured
1062: Duplicate entry '0' for key 1

QUERY = INSERT INTO CubeCart_order_inv (`cart_order_id`, `productId`, `name`, `price`, `quantity`, `product_options`, `productCode`, `digital`) VALUES ('061122-091103-5120', '1969', 'G4193 Size 20 Col 11 Lilac', '3.15', '1', '', 'G-419320-11', '0')

I tried official support and they blamed mods.

Could anyone possibly help me ?

Thanks all,

hotbox

use phpmyadmin to check your MySql table "CubeCart_order_inv" and se if you have a duplicat entry in there.

Check the "product_options"

And regarding your answer from support.

Do you have any mods installed.

If yes why dont say so here, it may help people to answer.
If yes, have thees mods been updated as well, or is it 3.0.10 mods you are using.

Arild,

Thanks very much for your answer:

I have looked in CubeCart_order_inv and can find no duplicate entries. Is it safe if I empty this table to make sure or can I repair it somehow ?

Installed Mods are: (all working on 3.0.10 previously)

Jbdancer's 'Add Customer'
Estelle's 'Contact Form' and 'Category Descriptions'
Goober's 'Price Manager'
Sir Williams 'CSV import'

Any other tips ?

Cheers,

hotbox

just noticed this warning in phpmyadmin in CubeCart_order_inv

PRIMARY and INDEX keys should not both be set for column `id`

Could this be the problem and how might I fix it please?

Thanks

hotbox

If you have mods from 3.0.10 i would check if they all work with 3.0.14. A mod normaly also change the CC code and should be up to date.

You may not find duplicates as you are not allowed to insert the data into mysql.

But did you check the "product_options" and see if there is a post with value 0

thanks,

will check with the mod creators.

"But did you check the "product_options" and see if there is a post with value 0"

Yes, that colum appeared to be empty.

Did you see my post above - maybe the problem lies there, but I don't feel confident enough to know how to fix it!

Any ideas please?

Thanks,

hotbox

I fixed it! Not quite sure WHY though...

I noticed that the 'id' field in the CubeCart_order_inv table was not set to auto_increment under 'Extra' and under 'Default' it had a 0

I changed it to auto_increment and removed the 0 and now all is well!

but why ?

Thanks for the help

hotbox