Post by derwydd » Tue Sep 25, 2007 3:37 am

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?

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am

Post by derwydd » Tue Sep 25, 2007 3:43 am

I set cart to NULL Instead of Not Null

This kind of seemed to fix the problem.

Is there a way to turn off error messages?

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am

Post by Daniel » Tue Sep 25, 2007 4:46 am

I have fixed this bug and it will be in the next release.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by derwydd » Tue Sep 25, 2007 5:30 am

Thank you,

With new releases can I just copy files over each other to update or would I have to start from scratch...

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am

Post by Daniel » Thu Sep 27, 2007 5:50 am

I wil work on an update script this time.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by derwydd » Thu Sep 27, 2007 6:01 am

Well I can't really update now. I had to do nasty hacks to make it do some stuff. Can you tell me what is changed, maybe in a change log, and I can do it manually.

Thanks

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am

Post by d77 » Thu Sep 27, 2007 10:10 am

i can't say i've done any "nasty hacks" ;D, 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.

User avatar
d77
Active Member

Posts

Joined
Sat Apr 14, 2007 8:04 am

Post by derwydd » Thu Sep 27, 2007 9:29 pm

OK I guess I will have to do a test server then transfer when successful. OHH, When I do new upgrades, can I keep the old DB inpace with all the data? Or do I have to start from scratch?

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am

Post by d77 » Fri Sep 28, 2007 12:23 am

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.

User avatar
d77
Active Member

Posts

Joined
Sat Apr 14, 2007 8:04 am

Post by brucehu » Thu Mar 13, 2008 12:09 pm

Yes,I also have a same problem,how solve? thanks

New member

Posts

Joined
Wed Mar 12, 2008 11:58 pm

Post by derwydd » Thu Mar 13, 2008 9:38 pm

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

Active Member

Posts

Joined
Wed Aug 29, 2007 12:13 am
Who is online

Users browsing this forum: No registered users and 2 guests