Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Fault 1054


Mette

Recommended Posts

Posted

Hey :)

 

I really hope someone can help me... my shop has had this message all day and I've only just noticed it:

 

1054 - Unknown column 'banners_id' in 'field list'

 

select banners_id, date_scheduled from banners where date_scheduled != ''

 

[TEP STOP]

 

What can I do ??

Posted
Mette,

Means banners_id not defined in the table banners...

I hope this helps,

Roman

How can I fix that to get my shop working ?

Posted

Mette,

Bring up the table banners and see if the table element is defined in the table banners...Use a mysql database access utility like phpmyadmin which sould be setup and available on your site...This utility will allow you to view, create and delete tables and elements...But what I am questioning is banners is a standard with oscommerce install...The element should be banners_id int(11) not null.

I hope this helps,

Roman

Archived

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

×
×
  • Create New...