Unserialize(): Error At Offset

Hello,

I have a CS-CART V434.
I moved it from my SERVER to another SERVER (to backup it because we go on a newer version)

On new server I have this ERROR on ORDER DETAIL PAGE :

unserialize(): Error at offset 344 of 353 bytes in /home/xxxxxxxxxx/xxxxxxx/app/functions/fn.cart.php on line 1870

unserialize(): Error at offset 96 of 5288 bytes in /home/xxxxxxxxxxx/xxxxx/app/functions/fn.cart.php on line 1930

On those corresponding orders I HAVE NO VAT (and there is normally)

The other orders that DO NOT HAVE THIS ERROR MESSAGE DO HAVE VAT !!!!

If I go back to my old SERVER I do NOT have the ERROR and I get VAT (with same DATABASE)

So it is clear that NEW SERVER cannot UNSERIALIZE correctly SOMME ORDERS (BLOB FILE IN DATABASE) But why .....

Why is that PHP is 5.6 on both server (database is OK because one server can read it)

If you know the bug please help

Best regards

Aymeric JALABERT

Hello,

I have a CS-CART V434.
I moved it from my SERVER to another SERVER (to backup it because we go on a newer version)

On new server I have this ERROR on ORDER DETAIL PAGE :

unserialize(): Error at offset 344 of 353 bytes in /home/xxxxxxxxxx/xxxxxxx/app/functions/fn.cart.php on line 1870

unserialize(): Error at offset 96 of 5288 bytes in /home/xxxxxxxxxxx/xxxxx/app/functions/fn.cart.php on line 1930

On those corresponding orders I HAVE NO VAT (and there is normally)

The other orders that DO NOT HAVE THIS ERROR MESSAGE DO HAVE VAT !!!!

If I go back to my old SERVER I do NOT have the ERROR and I get VAT (with same DATABASE)

So it is clear that NEW SERVER cannot UNSERIALIZE correctly SOMME ORDERS (BLOB FILE IN DATABASE) But why .....

Why is that PHP is 5.6 on both server (database is OK because one server can read it)

If you know the bug please help

Best regards

Aymeric JALABERT

First of all, please dont write in caps. It disrespects those willing to help you at a sunday evening.

Anyhow, have you checked whether your encryption key is the same? And, have you checked whether you have used the correct encoding for the database?

Kind regards,

Hello,

Sorry for all caps.

Yes encyption key has not changed.

I have moved my website from a server to another.
Effectively database encryption is probably the problem, but I do not have old parameters of my server

So I do not know what to do to correct it

Encryption is not used for Taxes or order_data other than payment data.

Most likely you have a character set issue between the old and new database schemas.

I doubt the problem is with the data. My guess is that the collation of the database or the cscart_order_data table are differrent between the two.

How did you create you new database? Are both sites running on the same server?

Try to print out corresponding variables. Possibly they contain incorrect symbols which cause the issue