Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Please...


Guest

Recommended Posts

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

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

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

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

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

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

Archived

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

×
×
  • Create New...