Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

error in account creation with gender


Recommended Posts

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')




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.

Link to comment
Share on other sites

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




Thanks for the reply.

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

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...