error in account creation with gender

[iggi]

Setting OS up on my test box and have a problem with gender. (no, not that kind of problem)

 

 

I set Gender to 'false' in admin.

The radio buttons for gender do not display.

However, when I try to create an account I receive the following error:

 

1364 - Field 'customers_gender' doesn't have a default value

 

insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password) values ('test', 'test', 'test@test.ca', '345-234-2345', '', '', 'b1cc2e95e66648dd566f9cf7e842fe2f:c8')

[TEP STOP]

 

 

Is this a known problem with a standard solution? Or is it likely to be specific to my installation?

I looked at create_account.php but manually removing gender is above my skills. :'(

At least without some guidance.

 

Thanks in advance for any help.

[♥Vger]

It sounds as if you are trying to run an older version of osCommerce with MySQL 5 in use.

 

Vger

[iggi]

It sounds as if you are trying to run an older version of osCommerce with MySQL 5 in use.

 

Vger

 

Thanks for the reply.

It's the most recent version of oscommmerce but switching to PHP4 did the trick.