We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

[EE3.4.0] - Column not found: 1054 Unknown column 'Channel_channels.max_entries' in 'field list'

Developer Preview

John Henry Donovan's avatar
John Henry Donovan
12,339 posts
8 years ago
John Henry Donovan's avatar John Henry Donovan

I tried 2 installs. First one I choose to have default site installed and I came across this error during install wizard.

Second time I didn’t install templates but the error appears when I visit CP Settings or Channels.

http://ee34.local/admin.php?/cp/members/profile/settings&id=1 http://ee34.local/admin.php?/cp/channels

MAMP & php7

Exception Caught SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘Channel_channels.max_entries’ in ‘field list’: SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.status_group as Channel__status_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.field_group as Channel__field_group, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.extra_publish_controls as Channel__extra_publish_controls, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.live_look_template as Channel__live_look_template, Channel_channels.max_entries as Channel__max_entries FROM (`exp_channels` as Channel_channels) WHERE ( `Channel_channels`.`site_id` = ‘1’ ) LIMIT 18446744073709551615 mysqli_connection.php:119
       
Derek Jones's avatar
Derek Jones
7,561 posts
8 years ago
Derek Jones's avatar Derek Jones

Aw, this was going to be a secret feature for people who upgraded only apparently, and not available for new installations. Add this to the table definition of system/ee/installer/schema/mysql_schema.php after line 613:

max_entries int(10) unsigned NOT NULL DEFAULT '0',

Or you can upgrade an earlier v3 developer preview database.

       
John Henry Donovan's avatar
John Henry Donovan
12,339 posts
8 years ago
John Henry Donovan's avatar John Henry Donovan

Thanks. All good now.

       
Kevin Cupp's avatar
Kevin Cupp
791 posts
8 years ago
Kevin Cupp's avatar Kevin Cupp

FYI to others, just pushed up another build with this fix in place!

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.