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.