This is what I get after I try to add a user.
eStore/index.php?controller=account_create
Error: Field 'cart' doesn't have a default value
Error No: 1364
insert into customer set firstname = 'dfff', lastname = 'dfff', email = 'ecomrms@rms-electric.com', telephone = '2222222222', fax = '', password = '0f8e77efbd7e1a4d4e3a069d84789fd2', newsletter = '0', status = '1', date_added = now()
What happened?
eStore/index.php?controller=account_create
Error: Field 'cart' doesn't have a default value
Error No: 1364
insert into customer set firstname = 'dfff', lastname = 'dfff', email = 'ecomrms@rms-electric.com', telephone = '2222222222', fax = '', password = '0f8e77efbd7e1a4d4e3a069d84789fd2', newsletter = '0', status = '1', date_added = now()
What happened?
i can't say i've done any "nasty hacks"
, but i have made a few minor changes to the core opencart code to fix small issues. the best advice i can give is to carefully keep track of what files you change. every change i've made, i have documented for myself as a mini "mod" so i can re-apply it to a new version. a database upgrade script is going to help loads as this is the most critical piece when we're talking about beginning to load live data into the shop.

the update script daniel is talking about will upgrade your database so you don't have to re-enter data.
if this is a live shop, i would recommend creating a copy of your entire site (both database and code), upgrading that, then move it in place of the old shop once everything is working. that way you will always have a fall-back copy of your data.
if this is a live shop, i would recommend creating a copy of your entire site (both database and code), upgrading that, then move it in place of the old shop once everything is working. that way you will always have a fall-back copy of your data.
See if this works:
Go to customers table, find cart field. Set "cart" field to NULL.
This field is originally set to not null. So if you are starting the cart from scratch and don't have the sample data anymore, you will then get this error.
Basically PHP Tells you want to do in the error messages.
Good Luck
Go to customers table, find cart field. Set "cart" field to NULL.
This field is originally set to not null. So if you are starting the cart from scratch and don't have the sample data anymore, you will then get this error.
Basically PHP Tells you want to do in the error messages.
Good Luck
Who is online
Users browsing this forum: No registered users and 5 guests