Editor12 Posted February 19, 2007 Share Posted February 19, 2007 In general, I have nothing but good to say about OSC but these errors are now coming every 30 minutes. Any of you guys recognise this one or got a solution. I am utterly at my wits end and really would appreciate your help? >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.. 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 = '' [TEP STOP] >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.. Link to comment Share on other sites More sharing options...
Velveeta Posted February 19, 2007 Share Posted February 19, 2007 In general, I have nothing but good to say about OSC but these errors are now coming every 30 minutes.Any of you guys recognise this one or got a solution. I am utterly at my wits end and really would appreciate your help? >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.. 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 = '' [TEP STOP] >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.. That means that whatever contribution was installed to add member levels to your store didn't have the sql run that actually added the field into the database... Go back through the contribution instructions and see if you missed that step... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
Editor12 Posted February 19, 2007 Author Share Posted February 19, 2007 That means that whatever contribution was installed to add member levels to your store didn't have the sql run that actually added the field into the database... Go back through the contribution instructions and see if you missed that step... Richard. Many thanks Richard, I've decided to do a re-install from an earlier backup. For what it's worth, a template monster has been biting me on the ass all day long. Link to comment Share on other sites More sharing options...
m1gu3 Posted December 22, 2008 Share Posted December 22, 2008 That means that whatever contribution was installed to add member levels to your store didn't have the sql run that actually added the field into the database... Go back through the contribution instructions and see if you missed that step... Richard. How can I do that??? apreciate your help, thank you.. Link to comment Share on other sites More sharing options...
markg-uk Posted December 23, 2008 Share Posted December 23, 2008 As said above, member_level is not in the stock oscommerce code and therefore will be added via a contribution. A quick google search implies it is probably this contribution The readme file for that contrib says to run this sql: ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL; Link to comment Share on other sites More sharing options...
TheApprentice Posted May 8, 2009 Share Posted May 8, 2009 After making this ALTER TABLE, i get rid of the error but this happen the user will not be logged on till i come manually into the database, table customer, field member_level and set it to 1. Gotta look in the logic where this can be automatically be done. As said above, member_level is not in the stock oscommerce code and therefore will be added via a contribution. A quick google search implies it is probably this contribution The readme file for that contrib says to run this sql: ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL; Apprentice from all apss, expert in almost nothing. bloggin at freedomipmoney.blogspot.com 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.