hello, I am trying to install version 10.1.3 using php 7.4.26 and mysql 5.7.36 but I got these error messages:
2022-11-23 10:35:09.756 ** ERROR ** Exception-[HY000] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.
2022-11-23 10:35:09.757 ** ERROR ** For query : CREATE INDEX planningelementWbsSortable ON `planningelement` (`wbsSortable`(255));
2022-11-23 10:35:09.757 ** ERROR ** Strack trace :2022-11-23 10:35:09.757 ** ERROR ** #0 Sql->query called at [C:wamp64wwwprojeqtordbmaintenanceFunctions.php:72]
2022-11-23 10:35:09.757 ** ERROR ** #1 runScript called at [C:wamp64wwwprojeqtordbmaintenance.php:140]2022-11-23 10:35:09.758 ** ERROR ** #2 include called at [C:wamp64wwwprojeqtortoolloginCheck.php:58]
2022-11-23 10:35:09.758 ===== TRACE =====
2022-11-23 10:35:09.758 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V0.6.0 (see above message)
2022-11-23 10:35:09.759 ===== TRACE =====2022-11-23 10:35:09.759 ===== TRACE ===== **********************************************
2022-11-23 10:35:35.150 ** ERROR ** Exception-[HY000] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.
2022-11-23 10:35:35.150 ** ERROR ** For query : CREATE INDEX planningelementbaselineWbsSortable ON `planningelementbaseline` (`wbsSortable`(255));2022-11-23 10:35:35.151 ** ERROR ** Strack trace :
2022-11-23 10:35:35.151 ** ERROR ** #0 Sql->query called at [C:wamp64wwwprojeqtordbmaintenanceFunctions.php:72]
2022-11-23 10:35:35.151 ** ERROR ** #1 runScript called at [C:wamp64wwwprojeqtordbmaintenance.php:140]
2022-11-23 10:35:35.151 ** ERROR ** #2 include called at [C:wamp64wwwprojeqtortoolloginCheck.php:58]
2022-11-23 10:35:35.152 ===== TRACE =====2022-11-23 10:35:35.152 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2022-11-23 10:35:45.906 ** ERROR ** Exception-[HY000] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.
2022-11-23 10:35:45.907 ** ERROR ** For query : CREATE INDEX planningelementextensionWbsSortable ON `planningelementextension` (wbsSortable(255));
2022-11-23 10:35:45.907 ** ERROR ** Strack trace :
2022-11-23 10:35:45.907 ** ERROR ** #0 Sql->query called at [C:wamp64wwwprojeqtordbmaintenanceFunctions.php:72]2022-11-23 10:35:45.908 ** ERROR ** #1 runScript called at [C:wamp64wwwprojeqtordbmaintenance.php:140]
2022-11-23 10:35:45.908 ** ERROR ** #2 include called at [C:wamp64wwwprojeqtortoolloginCheck.php:58]
2022-11-23 10:35:45.908 ===== TRACE =====2022-11-23 10:35:45.908 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V7.2.0 (see above message)2022-11-23 10:35:45.909 ===== TRACE =====2022-11-23 10:35:45.909 ===== TRACE ===== **********************************************
thank you in advance for your help.
Just change mysql parameter in mysql.ini
innodb-default-row-format=dynamic