buydemon Posted August 10, 2006 Share Posted August 10, 2006 hey, i have the follwing problem. Ive kinda got an idea how to sort it but im not very sure.... or good at this lol. Any help appreciated. When a customer tries to login they get the following error: 1054 - Unknown column 'member_level' in 'field list' select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, member_level from customers where customers_email_address = '[email protected]' [TEP STOP] i then read up on another post and ran an sql query: ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL; The following php code was created from this: $sql = 'ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT \'0\' NOT NULL;'; im not sure where to go next or even if im on the right track. Thanks for any help, Carl Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.