View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - database error message trying to install ProjeQtor 10.1.3 - ProjeQtOr
 
 

database error message trying to install ProjeQtor 10.1.3

More
23 Nov 2022 11:32 - 23 Nov 2022 11:34 #1 by bassem
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:\wamp64\www\projeqtor\db\maintenanceFunctions.php:72]
2022-11-23 10:35:09.757 ***** ERROR *****     #1 runScript called at [C:\wamp64\www\projeqtor\db\maintenance.php:140]2022-11-23 10:35:09.758 ***** ERROR *****     #2 include called at [C:\wamp64\www\projeqtor\tool\loginCheck.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:\wamp64\www\projeqtor\db\maintenanceFunctions.php:72]
2022-11-23 10:35:35.151 ***** ERROR *****     #1 runScript called at [C:\wamp64\www\projeqtor\db\maintenance.php:140]
2022-11-23 10:35:35.151 ***** ERROR *****     #2 include called at [C:\wamp64\www\projeqtor\tool\loginCheck.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:\wamp64\www\projeqtor\db\maintenanceFunctions.php:72]2022-11-23 10:35:45.908 ***** ERROR *****     #1 runScript called at [C:\wamp64\www\projeqtor\db\maintenance.php:140]
2022-11-23 10:35:45.908 ***** ERROR *****     #2 include called at [C:\wamp64\www\projeqtor\tool\loginCheck.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.
Last edit: 23 Nov 2022 11:34 by bassem.

Please Log in or Create an account to join the conversation.

More
24 Nov 2022 08:14 #2 by babynus
Just change mysql parameter in mysql.ini
innodb-default-row-format=dynamic

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.025 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.