Thread

This question may be related to a resolved thread.

After updating to ExpressionEngine 2.2 I am receiving the same database error when trying to create an upload directory:

A Database Error Occurred
Error Number: 1054

Unknown column ‘exclude_group’ in ‘where clause’

SELECT `group_id`, `group_name`, `sort_order` FROM (`exp_category_groups`) WHERE `site_id` = ‘1’ AND `exclude_group` = 0 OR `exclude_group` = 1 ORDER BY `group_name`

Filename: models/category_model.php

Line Number: 95

Hello jh40952,

I’m sorry you are experiencing this, it would seem some parts of the update didn’t quite happen. Can you tell us what version of ExpressionEngine you upgraded from? Did you upgrade to 2.2.0 or 2.2.2? Can you navigate to Tools-> Data-> SQL Manager and click Database Query Form. In the form type

DESCRIBE exp_category_groups

and click Submit

If you don’t mind pasting the output here for us to see, so we can compare your table to a known good.

Cheers,

DESCRIBE exp_category_groups
Total Results: 7
Field Type Null Key Default Extra
group_id int(6) unsigned NO PRI auto_increment
site_id int(4) unsigned NO MUL 1
group_name varchar(50) NO  
sort_order char(1) NO a
field_html_formatting char(4) NO all
can_edit_categories text YES  
can_delete_categories text YES

Sorry - I didn’t answer all your questions. Yes, I updated from EE 2.1.1 to EE 2.2.

Hi jh40952,

Yes it looks like you are missing a table field here, notably the exclude_group field.

Could you let us know, when you performed the upgrade did you come across any other errors at all? If you did could you post those here too please.

Thanks,

Mark

No other errors in the upgrade except with File Manager. I got some notice errors when accessing File Manager:

A PHP Error was encountered
Severity: Notice
Message: Undefined index: cat_group
Filename: cp/content_files.php
Line Number: 661

A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /public_html/system/codeigniter/system/core/Exceptions.php:170)
Filename: core/Common.php
Line Number: 405

Hi jh40952,

It looks like your system didn’t complete the upgrade, so your database doesn’t have the correct structure to operate. Could you please drop all the tables in your database and restore your site to the point it was at before the upgrade using the backup you captured before performing the upgrade? (Dropping all the tables is very important.) Once you’ve restored your site to its pre-upgrade state, please ensure everything is working as expected. Now go through the upgrade process again, this time being careful to note any errors that appear. If anything happens other than a successful upgrade, post back here with detailed notes on what happened along with the text of the errors you get and we’ll do our best to help you on to a successful upgrade.