Error - Magento 1: Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list'' Print

  • 4

If you get the following error reported in your exception.log during the checkout process, you may need to find the eav_attribute value in the database and update accordingly.

Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list''

The brief instructions may be useful:

1. Find the attribute_id for the gender column:

SELECT attribute_id FROM `eav_attribute` WHERE `attribute_code` = "gender"

2. Update the eav_attribute table with the correct values for gender. Substitute x for the actual attribute_id obtained above

update `eav_attribute` set `default_value`='', `frontend_class`='', 
`source_model`='eav/entity_attribute_source_table',
`frontend_label`='Gender', `backend_model`='',
`backend_table`='', `frontend_model`='', `backend_type`='int',
`frontend_input`='select' where `attribute_id`='x'

If you are a Create Hosting customer on the Magento Hosting Plan, feel free to submit a support ticket and we can take care of this issue for you. 

 

 


Was this answer helpful?

« Back