Hi,
I've installed this version, my database was not created.
2016-10-21 10:26:53.658 ** ERROR ** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
2016-10-21 10:26:53.658 ** ERROR ** For query : CREATE INDEX planningelementWbsSortable ON `planningelement` (`wbsSortable`);
2016-10-21 10:26:53.658 ** ERROR ** Strack trace :
2016-10-21 10:26:53.658 ** ERROR ** #0 Sql->query called at [C:ProjeqtorAppTestsdbmaintenanceFunctions.php:71]
2016-10-21 10:26:53.658 ** ERROR ** #1 runScript called at [C:ProjeqtorAppTestsdbmaintenance.php:100]
2016-10-21 10:26:53.658 ** ERROR ** #2 include called at [C:ProjeqtorAppTeststoolloginCheck.php:52]
2016-10-21 10:26:53.658 ===== TRACE =====
2016-10-21 10:26:53.658 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V0.6.0 (see above message)
Is there a patch for this update to include or a parameter on MySQL to change ?
Thxs.
Your database should be configured in UTF-8 General CI.
Maybe you try and use another multibyte format.
Ok, but it's projeqtor wich creates database... How can I proceed ? Must I réinstall completly ?
After check, tables are in collation utf8_general_ci. Another idea ?
Maybe your server is not in UTF-8.
Check my.ini or my.cnf
Hi,
Variables collation_connection, collation_database and collation_server are both in utf8_general_ci.
Thx
Either migrate to MySql >= 5.7.7 or add in your my.cnf (or my.ini) :
innodb_large_prefix=on
I migrate to MySQL 5.7.16, now it's OK.
Thx