hamiltonn Posted May 1, 2008 Share Posted May 1, 2008 Hey guys - First I would like to mention that I am a newbie to this whole OS Commerce thing. This site was up before I came to the company and recently went down. I had to rebuild a majority of it and have it pretty much back to normal except for one thing. Whenever I try and create a new account I get the following error. 1054 - Unknown column 'customers_id_num' in 'field list' insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_id_num, customers_newsletter, customers_password, customers_gender, customers_dob) values ('Nate', 'Hamilton', '******@hotmail.com', '888 2401915', '888 2401915', '', '', 'b45dc2f62157480aeafde1f25a5c8152:fe', 'm', '19840806') [TEP STOP] I am at the end of my rope, please help. I appreciate it, thanks! Link to comment Share on other sites More sharing options...
burt Posted May 1, 2008 Share Posted May 1, 2008 Someone has added a contribution that asks for extra info from the customer. The database doesn't have a column for that extra info. A quick fix, but maybe not the right one, would be to simply add the column to the DB. Link to comment Share on other sites More sharing options...
hamiltonn Posted May 1, 2008 Author Share Posted May 1, 2008 Someone has added a contribution that asks for extra info from the customer. The database doesn't have a column for that extra info. A quick fix, but maybe not the right one, would be to simply add the column to the DB. How do I know which table that column needs to go in? Link to comment Share on other sites More sharing options...
ricksteruk2005 Posted May 1, 2008 Share Posted May 1, 2008 1054 - Unknown column 'customers_id_num' in 'field list' Tells you the column missing is customers_id_num I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word Link to comment Share on other sites More sharing options...
hamiltonn Posted May 1, 2008 Author Share Posted May 1, 2008 1054 - Unknown column 'customers_id_num' in 'field list' Tells you the column missing is customers_id_num Ahhh success never tasted so sweet. That worked, thanks! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.