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,
Bump
Keep getting this error after update to new version.
Manually had to transfer to new install but still get this error
Keep getting this error after update to new version.
Manually had to transfer to new install but still get this error
Live long my friends
visit our website now at http://www.less2websites.com
In your PHPMyAdmin console, launch the following query in your SQL tab under your Opencart database:
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.
Code: Select all
ALTER TABLE `oc_customer` MODIFY `cart` BLOB
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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:
Are any of these tables the table you are referring to?
Many thanks for your help
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_transactionMany thanks for your help
OC 2.0.1.1
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.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:
Are any of these tables the table you are referring to?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
Many thanks for your help
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 6 guests
