Cart Problem

[divaboutiques]

I'm getting this error when i try to access my store catalog page:
1146 Table 'divabou_zc1.zen_banners' doesn't exist
in:
[select banners_id, date_scheduled from zen_banners where date_scheduled != NULL]
And I am getting this error when I try to access my zencart admin area.
1146 Table 'divabou_zc1.zen_banners' doesn't exist
in:
[select banners_id, date_scheduled from zen_banners where date_scheduled != NULL]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
How can I correct this problem so that I don't have to uninstall my shop and reinstall my shop. I start having this problem when I had my hosting company restore my backup.

[divaboutiques]

This is the error now that i am getting!

1054 Unknown column 'b.expires_date' in 'field list'
in:
[select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from zen_banners b, zen_banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions]

[divaboutiques]

How can I clear this error to get in my admin & see my catalog

1054 Unknown column 'b.expires_date' in 'field list'
in:
[select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from zen_banners b, zen_banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions]

[DrByte]

Sounds like they've restored from an out-of-date backup.

Your "banners" table structure presently in your database apparently doesn't match what's expected by your Zen Cart code.

Do you use banners on your site?

I recommend that you do a database backup (see this FAQ: https://www.zen-cart.com/tutorials/i...hp?article=103 )
and then run the following SQL commands via phpMyAdmin:

DROP TABLE IF EXISTS zen_banners;
CREATE TABLE zen_banners (
  banners_id int(11) NOT NULL auto_increment,
  banners_title varchar(64) NOT NULL default '',
  banners_url varchar(255) NOT NULL default '',
  banners_image varchar(64) NOT NULL default '',
  banners_group varchar(15) NOT NULL default '',
  banners_html_text text,
  expires_impressions int(7) default '0',
  expires_date datetime default NULL,
  date_scheduled datetime default NULL,
  date_added datetime NOT NULL default '0001-01-01 00:00:00',
  date_status_change datetime default NULL,
  status int(1) NOT NULL default '1',
  banners_open_new_windows int(1) NOT NULL default '1',
  banners_on_ssl int(1) NOT NULL default '1',
  banners_sort_order int(11) NOT NULL default '0',
  PRIMARY KEY  (banners_id),
  KEY idx_status_group_zen (status,banners_group),
  KEY idx_expires_date_zen (expires_date),
  KEY idx_date_scheduled_zen (date_scheduled)
) TYPE=MyISAM;

[divaboutiques]

Thank you for the reply is there a way I can just go in and find all my products in my shop, I just want to uninstall and reinstall, I tried the information you gave me but I just got another error message.