Thread

I receive the following error when trying to Edit Group Assignments on Channels (both new and pre-existing) after installing EE 2.5.1 with the html5BoilerPlatEE theme (http://www.kc-webdesign.co.uk/html5boilerplatEE.html).  This is a fresh install and I’ve tried it on both MAMP on a Mac and on IIS on a W2K3 server.

Any ideas?

Thanks,
Ryan

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` = 2 ORDER BY `group_name`

Filename: C:\inetpub\wwwroot\rusticpathways.com\_sites\ee\system\codeigniter\system\database\DB_driver.php

Line Number: 330

I’m getting exactly the same problem, having also loaded up the html5BoilerPlatEE theme -  although my error message is slightly different:

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` = 2 ORDER BY `group_name`

Filename: models/category_model.php

Line Number: 95

Is there a bug in 2.5.1? It seemed to work fine when I was on the previous version (2.5.0)

I am getting the a similar error when trying to create a new Category as well.  Any ideas?

Thanks,
Ryan

A Database Error Occurred
Error Number: 1054

Unknown column 'exclude_group' in 'field list'

INSERT INTO `exp_category_groups` (`group_name`, `field_html_formatting`, `exclude_group`, `can_edit_categories`, `can_delete_categories`, `site_id`) VALUES ('Countries', 'all', '0', '', '', '1')

Filename: C:\inetpub\wwwroot\rusticpathways.com\_sites\ee\system\codeigniter\system\database\DB_driver.php

Line Number: 330

Hi Ryan,

Welcome to ExpressionEngine and the Forums!

I am sorry for the trouble you are having! Looking at the Boilerplate, that appears to be a template pack for front end design, correct? It *should* have no impact on the Control Panel, but thanks for letting us know!

Did you experience the errors before using the template pack? What all is installed as part of the template?

Are you using any third-party add-on fieldtypes?

Are these installations an update or fresh install of 2.5.1?

Cheers,

Hi Dan
For me it was a fresh install, third party add-ons include trunchtml, tagstripper, and freeform; There was no problem before using the template pack; various channels and templates are installed as part of the template pack, as well as some snippets, some default content, and theme preferences. There is also a Javascript file that sits in the root directory containing various scripts.

I am also getting another error message when trying to create a new category group:

A Database Error Occurred
Error Number: 1054

Unknown column 'exclude_group' in 'field list'

INSERT INTO `exp_category_groups` (`group_name`, `field_html_formatting`, `exclude_group`, `can_edit_categories`, `can_delete_categories`, `site_id`) VALUES ('about', 'all', '0', '', '', '1')

Filename: models/category_model.php

Line Number: 286

cheers
Max

Thanks Dan.

The theme installs the following add-ons:
- freeform
- tagstripper
- trunchtml

Into the system/expressionengine/third_party directory.

I just tried a fresh install of 2.5.1 alone and did not receive the errors.  I then updated all the add-ons and tried a fresh installation using the boilerplate and I receive these errors.  I’ll reach out to them and see if I can work this out.  Not sure if you have any other suggestions.

Thanks,
Ryan

Whoops you beat me Max.  Sorry for the double up on info…

Hey Ryan,

I just tried a fresh install of 2.5.1 alone and did not receive the errors.  I then updated all the add-ons and tried a fresh installation using the boilerplate and I receive these errors.

What happens if you install Boilerplate, then update the add-ons?

It’s would seem that boilerplate would overwrite your add-on updates in the the order you describe.

Thoughts?

Cheers,

No dice trying it that way either.  Boilerplate bundles the three add-ons, so I also attempted to update them with the latest versions prior to the fresh install of EE.

Thanks,
Ryan

I just ditched 2.5.1 and installed 2.5.0 with the boilerplate, and still the same problems persist, so its not to do with the upgrade.

Hi Max,

I tried contacting the developer.  Bounce back on a direct email so I sent through his contact form.  I’ll let you know if I hear anything.  Right now I am proceeding with a clean install of EE without boilerplate.  I guess I’ll work in the boilerplate functionality into new templates.

Cheers,
Ryan

Hi Ryan and company,

The reason you guys are having this issue is not because of any bug in EE 2.x or any bug in the add-ons required by the html5BoilerPlatEE template. Unfortunately, the html5BoilerPlatEE theme itself has a bug, specifically in how it is implemented. To put it simply, the theme contains a file called template.sql, located at ‘/html5boilerplatEE/template.sql’, which it uses to re-define the structure of the EE 2.x tables that it accesses during its installation (EE’s core install creates all the DB tables with corret table schema/structure/fields but this theme has a file called default_content.php in the same folder as template.sql that actually drops these tables and re-creates the exp_category_groups table with incorrect schema).

Without going into the intricate details of EE 2.x theme development (unless you guys want me to 😊), here’s the fix so that you can actually get a working html5BoilerPlatEE theme:

Open up html5boilerplatEE/template.sql and find this SQL statement:

--
-- Table structure for table `exp_category_groups`
--

CREATE TABLE IF NOT EXISTS `exp_category_groups` (
  `group_id` int(6) unsigned NOT NULL auto_increment,
  `site_id` int(4) unsigned NOT NULL default '1',
  `group_name` varchar(50) NOT NULL,
  `sort_order` char(1) NOT NULL default 'a',
  `field_html_formatting` char(4) NOT NULL default 'all',
  `can_edit_categories` text,
  `can_delete_categories` text,
  PRIMARY KEY  (`group_id`),
  KEY `site_id` (`site_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Replace them with the following:

--
-- Table structure for table `exp_category_groups`
--

CREATE TABLE IF NOT EXISTS `exp_category_groups` (
  `group_id` int(6) unsigned NOT NULL auto_increment,
  `site_id` int(4) unsigned NOT NULL default '1',
  `group_name` varchar(50) NOT NULL,
  `sort_order` char(1) NOT NULL default 'a',
  `exclude_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `field_html_formatting` char(4) NOT NULL default 'all',
  `can_edit_categories` text,
  `can_delete_categories` text,
  PRIMARY KEY  (`group_id`),
  KEY `site_id` (`site_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

Simply put, the theme forgets to create the exp_category_groups table with the exclude_group field included. EE’s core models attempt to access this field and because it doesn’t exist you will get a MySQL error being generated.

Hope this clears things up and that you can get the theme working. Also might be a good idea to let the html5BoilerPlatEE theme developer(s) know about this bug.

All the best guys! 😊

Excellent fix.  Thank you Owan!

Ryan

No problemo Ryan! Glad you got it sorted. Max, can you try the fix as well and let me know if it works for you too? Just make the change to the template.sql file as I suggested, try a fresh install of EE with the html5BoilerPlatEE theme selected (do not install Freeform during the EE installation), and after EE is installed then go and install Freeform module and you should be free to use and build upon the html5BoilerPlatEE theme’s templates.

Hey, just ran into another error while creating an upload folder.  Owan, have you used the HTML5 BP with EE?  Or are you just kind enough to troubleshoot on the fly for us?

I imagine I can figure out the SQL fix for this.  Does anyone know if I can apply this patch after the fact by simply modifying the DB structure in MySQL rather than doing a fresh install with patches .sql files?

Any idea if these are going to continue to pop up?

Thanks!
Ryan

A Database Error Occurred
Error Number: 1054

Unknown column ‘cat_group’ in ‘field list’

INSERT INTO `exp_upload_prefs` (`name`, `server_path`, `url`, `allowed_types`, `max_size`, `max_width`, `max_height`, `properties`, `pre_format`, `post_format`, `file_properties`, `file_pre_format`, `file_post_format`, `cat_group`, `site_id`) VALUES (‘Staff’, ‘C:\\inetpub\\wwwroot\\rusticpathways.com\\_sites\\ee\\assets\\images\\staff/’, ‘http://ee.rusticpathways.com/assets/images/staff/’, ‘img’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘1’)

Filename: C:\inetpub\wwwroot\rusticpathways.com\_sites\ee\system\codeigniter\system\database\DB_driver.php

Line Number: 330