Skip to content
This repository has been archived by the owner on Nov 3, 2023. It is now read-only.

SQL error on create - Contao Install 3.5.18 #8540

Closed
Olli opened this issue Oct 26, 2016 · 1 comment
Closed

SQL error on create - Contao Install 3.5.18 #8540

Olli opened this issue Oct 26, 2016 · 1 comment

Comments

@Olli
Copy link

Olli commented Oct 26, 2016

This statement
CREATE TABLEtl_files( idint(10) unsigned NOT NULL auto_increment, pidbinary(16) NULL, tstampint(10) unsigned NOT NULL default '0', uuidbinary(16) NULL, typevarchar(16) NOT NULL default '', pathvarchar(1022) NOT NULL default '', extensionvarchar(16) NOT NULL default '', hashvarchar(32) NOT NULL default '', foundchar(1) NOT NULL default '1', namevarchar(255) NOT NULL default '', importantPartXint(10) NOT NULL default '0', importantPartYint(10) NOT NULL default '0', importantPartWidthint(10) NOT NULL default '0', importantPartHeightint(10) NOT NULL default '0', metablob NULL, PRIMARY KEY (id), KEYpid(pid), UNIQUE KEYuuid(uuid), KEYpath(path(333)), KEYextension(extension) ) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
leads to this error
Fatal error: Uncaught exception Exception with message Query error: Index column size too large. The maximum column size is 767 bytes. (CREATE TABLEtl_files(idint(10) unsigned NOT NULL auto_increment,pidbinary(16) NULL,tstampint(10) unsigned NOT NULL default '0',uuidbinary(16) NULL,typevarchar(16) NOT NULL default '',pathvarchar(1022) NOT NULL default '',extensionvarchar(16) NOT NULL default '',hashvarchar(32) NOT NULL default '',foundchar(1) NOT NULL default '1',namevarchar(255) NOT NULL default '',importantPartXint(10) NOT NULL default '0',importantPartYint(10) NOT NULL default '0',importantPartWidthint(10) NOT NULL default '0',importantPartHeightint(10) NOT NULL default '0',metablob NULL, PRIMARY KEY (id), KEYpid(pid), UNIQUE KEYuuid(uuid), KEYpath(path(333)), KEYextension(extension) ) ENGINE=MyISAM DEFAULT CHARSET=UTF8;) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295 #0 system/modules/core/library/Contao/Database.php(207): Contao\Database\Statement->query('CREATE TABLE t...')
#1 system/modules/core/controllers/BackendInstall.php(616): Contao\Database->query('CREATE TABLE `t...')
#2 system/modules/core/controllers/BackendInstall.php(177): Contao\BackendInstall->adjustDatabaseTables()
#3 contao/install.php(24): Contao\BackendInstall->run()
#4 {main}

`

I'm working on a Strato hosting with mysql 5.6

@leofeyer
Copy link
Member

See #8484.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants