Guest Posted February 8, 2004 Share Posted February 8, 2004 1054 - Unknown column 'customers_selected_template' in 'field list' select customers_selected_template as template_selected from customers where customers_id = '' [TEP STOP] www.soapandsoap.com Link to comment Share on other sites More sharing options...
♥yesudo Posted February 8, 2004 Share Posted February 8, 2004 is this correct? customers_selected_template Your online success is Paramount. Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 8, 2004 Share Posted February 8, 2004 it means that somehow, you've added code to your store that is looking for that column name is a store, but you have not added that column to the database table. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
♥yesudo Posted February 8, 2004 Share Posted February 8, 2004 select customers_selected_template as template_selected from customers where customers_id = '' i do not understand the bolded bit - is that an array or a new table? Your online success is Paramount. Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 8, 2004 Share Posted February 8, 2004 Well, it could just be a table coorelation, although usually everyone jsut uses the first letter for a coorelation. In other words, the syntax is ok there. The problem is that the column 'customers_selected_template' doesn't exist in the table customers. This probalby menas that someone didn't install a contribution correctly. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2004 Share Posted February 8, 2004 any ideas how to fix it? Link to comment Share on other sites More sharing options...
♥yesudo Posted February 8, 2004 Share Posted February 8, 2004 what files did you edit last prior to getting the error message? Your online success is Paramount. Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2004 Share Posted February 8, 2004 Didn't touch it... I just went to the website and all of a sudden it was giving me the error message. I tried restoring the database but no luck... I even uploaded an old working script and same error. I'm guessing it must be a problem with the sql info ?? Could that be the problem, maybe corrupted ? Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 8, 2004 Share Posted February 8, 2004 customers_selected_template is not a column that comes with OSCommerce in the customers table by default. So something was added by someone in order to be referencing it. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2004 Share Posted February 8, 2004 what version of osCommerce are you running? did you download it from this site? what contributions have you installed? Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2004 Share Posted February 8, 2004 what version of osCommerce are you running? did you download it from this site? what contributions have you installed? 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.