Forum

database error mess...
 
Notifications
Retirer tout

database error message trying to install ProjeQtor 10.1.3

2 Posts
2 Utilisateurs
0 Reactions
1,338 Vu
(@bassem)
Posts: 27
Eminent Member
Début du sujet
 
[#8625]

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.


 
Posté : 23/11/2022 1:32 pm
(@babynus)
Posts: 14952
Membre Admin
 

Just change mysql parameter in mysql.ini

innodb-default-row-format=dynamic

 
Posté : 24/11/2022 10:14 am
Share:
Retour en haut