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

EE4: "SQLSTATE[42000]: Syntax error or access violation" on install

Developer Preview

Bjørn Børresen's avatar
Bjørn Børresen
629 posts
7 years ago
Bjørn Børresen's avatar Bjørn Børresen

When installing EE4 I get this error after hitting submit on the installer form:

Exception Caught

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes:
CREATE TABLE exp_channels ( channel_id int(6) unsigned NOT NULL auto_increment, site_id INT(4) UNSIGNED NOT NULL DEFAULT 1, channel_name varchar(40) NOT NULL, channel_title varchar(100) NOT NULL, channel_url varchar(100) NOT NULL, channel_description varchar(255) NULL DEFAULT NULL, channel_lang varchar(12) NOT NULL, total_entries mediumint(8) default '0' NOT NULL, total_records mediumint(8) unsigned NOT NULL DEFAULT '0', total_comments mediumint(8) default '0' NOT NULL, last_entry_date int(10) unsigned default '0' NOT NULL, last_comment_date int(10) unsigned default '0' NOT NULL, cat_group varchar(255) NULL DEFAULT NULL, deft_status varchar(50) NOT NULL default 'open', search_excerpt int(4) unsigned NULL DEFAULT NULL, deft_category varchar(60) NULL DEFAULT NULL, deft_comments char(1) NOT NULL default 'y', channel_require_membership char(1) NOT NULL default 'y', channel_max_chars int(5) unsigned NULL DEFAULT NULL, channel_html_formatting char(4) NOT NULL default 'all', extra_publish_controls char(1) NOT NULL default 'n', channel_allow_img_urls char(1) NOT NULL default 'y', channel_auto_link_urls char(1) NOT NULL default 'n', channel_notify char(1) NOT NULL default 'n', channel_notify_emails varchar(255) NULL DEFAULT NULL, comment_url varchar(80) NULL DEFAULT NULL, comment_system_enabled char(1) NOT NULL default 'y', comment_require_membership char(1) NOT NULL default 'n', comment_moderate char(1) NOT NULL default 'n', comment_max_chars int(5) unsigned NULL DEFAULT '5000', comment_timelock int(5) unsigned NOT NULL default '0', comment_require_email char(1) NOT NULL default 'y', comment_text_formatting char(40) NOT NULL default 'xhtml', comment_html_formatting char(4) NOT NULL default 'safe', comment_allow_img_urls char(1) NOT NULL default 'n', comment_auto_link_urls char(1) NOT NULL default 'y', comment_notify char(1) NOT NULL default 'n', comment_notify_authors char(1) NOT NULL default 'n', comment_notify_emails varchar(255) NULL DEFAULT NULL, comment_expiration int(4) unsigned NOT NULL default '0', search_results_url varchar(80) NULL DEFAULT NULL, rss_url varchar(80) NULL DEFAULT NULL, enable_versioning char(1) NOT NULL default 'n', max_revisions smallint(4) unsigned NOT NULL default 10, default_entry_title varchar(100) NULL DEFAULT NULL, title_field_label varchar(100) NOT NULL DEFAULT 'Title', url_title_prefix varchar(80) NULL DEFAULT NULL, live_look_template int(10) UNSIGNED NOT NULL default 0, max_entries int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY `channel_id` (`channel_id`), KEY `cat_group` (`cat_group`), KEY `channel_name` (`channel_name`), KEY `site_id` (`site_id`) )ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

mysqli_connection.php:116

The current url at that point is /admin.php?C=wizard&M=do_install&language=english

       
Seth Barber's avatar
Seth Barber
172 posts
7 years ago
Seth Barber's avatar Seth Barber

Thanks for catching this. We have a fix in for the next developer preview release.

       

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.