Hi,

Suddenly my Zen-Cart is giving this error when a new customer tries creating an account:

1364 Field 'customers_gender' doesn't have a default value
in:
[INSERT INTO zencustomers (customers_firstname, customers_lastname, customers_email_address, customers_nick, customers_telephone, customers_fax, customers_newsletter, customers_email_format, customers_default_address_id, customers_password, customers_authorization) VALUES ('XXXx', 'XXXXx', '[email protected]', '', '9999999999', '', '0', 'TEXT', '0', '7176b007a59e92c2b749d218243fd238:87', '0')]

My web host recently moved the site to a new server, but they tell me this is a code issue. Nothing else has changed recently.

When I change the table default value for customers_gender to null, it works, but I then get the same error for customers_referral. Change that default to null, and I get the same error for customers_paypal_payerid.

Any help is greatly appreciated!