Page 1 of 1

customer login error unserialize(): Error at offset

Posted: Wed Feb 18, 2015 10:21 pm
by kryllem
Hey,

I have recently upgraded from 1.5.6.4 to 2.0.1.1 and after solving a lot of another errors I have still one more that I can not find any solution for.

After my customers login to web shop the receive an error:
2015-02-18 14:45:23 - PHP Notice: unserialize(): Error at offset 0 of 3 bytes in public_html/system/library/cart.php on line 23

This error is coming up only once and it's coming up only for customers registered in 1.5.6.4
This may also cause a problem with forgotten password for those customer that are getting this error.

I guess it's an error due to what customers had in the cart.

Need assistance,

Re: customer login error unserialize(): Error at offset

Posted: Sat Sep 05, 2015 2:36 am
by aide2001
Bump
Keep getting this error after update to new version.
Manually had to transfer to new install but still get this error

Re: customer login error unserialize(): Error at offset

Posted: Sun Sep 06, 2015 1:08 am
by straightlight
In your PHPMyAdmin console, launch the following query in your SQL tab under your Opencart database:

Code: Select all

ALTER TABLE `oc_customer` MODIFY `cart` BLOB
Note: replace oc_ with your actual table prefix name, if different. Then, try again on your store to see if the error persists afterwards. Although, I would suggest clearing your cart, browser cache, FTP cache from system/cache folder. Then, to try again.

Re: customer login error unserialize(): Error at offset

Posted: Wed Sep 09, 2015 5:59 pm
by Khal
Hi Straightlight

I am also getting this error and want to try your fix. But on my new OC2 store there is no table called oc_customer, or any other table with a prefix followed by 'customer'. The only tables with 'customer' in them are:

Code: Select all

customer
customer_activity	
customer_ban_ip
customer_group	
customer_group_description	
customer_history	
customer_ip	
customer_login	
customer_online	
customer_reward	-
customer_transaction
Are any of these tables the table you are referring to?

Many thanks for your help

Re: customer login error unserialize(): Error at offset

Posted: Wed Sep 09, 2015 8:58 pm
by straightlight
Khal wrote:Hi Straightlight

I am also getting this error and want to try your fix. But on my new OC2 store there is no table called oc_customer, or any other table with a prefix followed by 'customer'. The only tables with 'customer' in them are:

Code: Select all

customer
customer_activity	
customer_ban_ip
customer_group	
customer_group_description	
customer_history	
customer_ip	
customer_login	
customer_online	
customer_reward	-
customer_transaction
Are any of these tables the table you are referring to?

Many thanks for your help
Yes ... the first one on the list. If you have no table prefix, simply remove it from my string and apply the query as already indicated above.

Re: customer login error unserialize(): Error at offset

Posted: Wed Sep 09, 2015 9:09 pm
by Khal
Ok thank you for getting back to me.

I've applied the query as you described- I hope that gets rid of the error.

Many thanks for this fix.