Hi,
During upgrade process from 7.3.3 to 8.6.3, I have this issue :
2020-11-04 17:21:15.877 ===== TRACE ===== 0 lines updated into table "employmentcontract".
2020-11-04 17:21:15.877 ** ERROR ** [V7.3.3] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
2020-11-04 17:21:15.877 ** ERROR ** [V7.3.3] For query : CREATE INDEX projectSortOrder ON `project` (sortOrder);
2020-11-04 17:21:15.877 ** ERROR ** [V7.3.3] Strack trace :
2020-11-04 17:21:15.877 ** ERROR ** [V7.3.3] #0 Sql->query called at [/usr/local/apache/apache-2.4.33-divers/htdocs/projeqtor/db/maintenanceFunctions.php:71]
2020-11-04 17:21:15.878 ** ERROR ** [V7.3.3] #1 runScript called at [/usr/local/apache/apache-2.4.33-divers/htdocs/projeqtor/db/maintenance.php:111]
2020-11-04 17:21:15.878 ** ERROR ** [V7.3.3] #2 include called at [/usr/local/apache/apache-2.4.33-divers/htdocs/projeqtor/tool/loginCheck.php:143]
2020-11-04 17:21:15.878 ===== TRACE =====
2020-11-04 17:21:15.878 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V8.4.0 (see above message)
It appears during update to 8.4.0 in logfile.
Process ends, and I can access to Projeqtor, but enable to see detail on project or create a new project (see attach)
Thanks 🙂
I think i've got something for sql error.
In Projeqtor, sortorder is defined as 600 car long. Depending on encoding of databse, 1 car may need several bytes, and then coloum lenth is >1000 and create index doesn't work.
I checked the max lenth used for this field, and modified length to 300 car.
After this "create index" succedded
But I still have same pb as explained when trying to see projects details.
I'll give a look at log file soon
Pb solved, it was just classic pb "set zlib.output_compression = Off in your php.ini"