Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Unserialize(): Error At Offset Rate Topic   - - - - -

 
  • mancup
  • Member
  • Members
  • Join Date: 27-Dec 12
  • 33 posts

Posted 25 November 2018 - 06:44 PM #1

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

 

 



 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 476 posts

Posted 25 November 2018 - 06:46 PM #2

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,


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • mancup
  • Member
  • Members
  • Join Date: 27-Dec 12
  • 33 posts

Posted 13 December 2018 - 08:44 PM #3

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



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11198 posts

Posted 13 December 2018 - 10:45 PM #4

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?


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18922 posts

Posted 14 December 2018 - 05:30 AM #5

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

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.