Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

customers not allowed to login??


buydemon

Recommended Posts

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

Archived

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

×
×
  • Create New...