Help - Categories / Products Search: Go To: 1054 - Unknown column 'cd.categories_banner' in 'field list'

[kjmcgilvray]

Hello,

 

I left my store alone for a few days and I came back to this!

I've done a restore on my database already and still am getting this error. I can't add any new products to my store.

 

Full code:

Categories / Products Search: Go To: TopApparelBranded MerchandiseMisc.PrintsPromo Products 1054 - Unknown column 'cd.categories_banner' in 'field list'

 

select c.categories_id, cd.categories_name, cd.categories_banner, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

[TEP STOP]

 

Running osCommerence 2.3

 

Any help would be appreciated.

[Jan Zonjee]

Looks like you added an add-on because categories_banner is not a field in standard osC 2.3. From 2.3.1:

 

categories_description (
  categories_id int DEFAULT '0' NOT NULL,
  language_id int DEFAULT '1' NOT NULL,
  categories_name varchar(32) NOT NULL,
  PRIMARY KEY (categories_id, language_id),

 

Could be that you added the code for the add-on but didn't change the database accordingly?

[kjmcgilvray]

I was adding a few things, but nothing to do with a Banner.

[MrPhil]

Well, you had to have installed an add-on at some point, that calls for a database field categories_banner. If it wasn't recently, can we assume your site was working well for some time? The only thing that would be left would be that somehow your database got fully or partially rolled back to an earlier version (missing the categories_banner). Did you or someone in your shop do a database restore? Did your host? If they did, their backup shouldn't be more than a few days old. You might ask anyway if they did any restores, and if so, did they have to use an older backup.

 

When you were "adding a few things", did any of it involve updates to the database? Might you have accidentally (partially) installed some sort of banner add-on without running its database update (to add the field)?

[kjmcgilvray]

I added the following to my site:

Canada Post Shipping (database update required)

Agreement to Terms (straight PHP)

Themeroller theme

theme switcher (for themeroller)

 

I'm going to go on a whim and assume it was the Canada post?

 

I did a back up but even going to my first one doesn't correct the problem.

 

Which is what makes this more frustrating.

[MrPhil]

I did a back up...

Files (code) or database or both? The error says that your code is calling for a database field "categories_banner", but there is no such field in the database. Either you managed to install code that calls for this field, without updating the database structure, or you had everything properly installed and somehow rolled back the database so now it's missing this field. It's got to be one or the other.

 

I can't imagine Canada Post having anything to do with it, nor Agreement to Terms. Possibly the theme you're using has a category banner built in? Is that list all your add-ons, or just the ones you just installed?

[taleb]

Hi,

I just ran into this exact problem after installing Canada Post modules. I uninstalled them but I still get this error. Did you manage to solve this problem?

[♥joli1811]

I added the following to my site:

Canada Post Shipping (database update required)

Agreement to Terms (straight PHP)

Themeroller theme

theme switcher (for themeroller)

 

I'm going to go on a whim and assume it was the Canada post?

 

I did a back up but even going to my first one doesn't correct the problem.

 

Which is what makes this more frustrating.

 

Check your theme switcher settings had a similar error on a theme switcher shop while upgrading not sure if just a coincidence but there was an extra field added in the database

 

never honestly understood what that had to do with theme switcher probably just a coincidence as he has nothing to do with category descriptions

 

The extra filed was in the categories table

 

Regards

Joli