(SOLVED) 2 sql Errors...after upgrade??

[thehandlestudio]

I have tried to upgrade my test site from 1.1.0.5 to 1.2.5.0 and everything seems fine except when I was upgrading the translations and img files was still red and not changed to green although the permissions are set correct, so I continued and I had 2 sql errors as below

SET NAMES ‘utf8’

/* ##################################### / / STRUCTURE / / ##################################### */ DROP TABLE IF EXISTS ps_order_customization_return

ALTER TABLE ps_cart ADD id_guest INT UNSIGNED NULL AFTER id_customer

Is this serious for the running of the shop and what could I do to fix this please.

Regards,

Mark

[rocky]

From the error message, it looks like Prestashop tried to remove a table and add a new column to another table. I can't see how failed to remove a table would cause a problem, but a missing column in a table will cause problems. You should use phpMyAdmin to check whether the column id_guest exists in ps_cart. If it doesn't, add a new column after id_customer called id_guest of type INT(10), attributes UNSIGNED and null "not null".

[thehandlestudio]

Thank you for your reply, The column id_guest is there so does this mean that everything is ok with the upgrade and there should be no further problems?

Regards,

Mark.

[rocky]

If the column has the same properties as mentioned above, then it should be OK.

[thehandlestudio]

Thanks...lets hope ...