Customer Register Error

I have installed version 1.3 freshly and it seems everything is fine
but when I start to try to register a customer, got some error message.

after filled the form of customer with email, password, and submit the form, it return a error message said
that fields of IP and cart have no default value.

it is easy to update the SQL to add the IP, but not sure what cart means here.

Hi,

I've had a similar problem. The exact error message is:

Error: Field 'cart' doesn't have a default value
Error No: 1364
INSERT INTO oc_customer SET firstname = 'fred', lastname = 'horse', email = 'fred.hoss@abc.com', telephone = '01273896321', fax = '', password = '9443b0fceb8c03b6a514a706ea69df0b', newsletter = '0', status = '1', date_added = NOW()

This happens whether the cart is full or empty. Checking with DBManager it appears that the column definition is set to text, null. Could this be part of the problem?

rmac

which vesion of mysql are you using?

on my sql it says cart is not null and same for ip.

can you pm me a link to your site and possbily phpmytadmin details?

Daniel wrote:which vesion of mysql are you using?

on my sql it says cart is not null and same for ip.

Hi Daniel,

Sorry. It's v1.3.0 and you're right both IP and cart are 'not null' a typo on my part.

Unfortunately there is no web access to my site; it's on an isolated development network at the moment until I get the hang of it.

By the way it looks like a really nice piece of work! Thanks.

rmac