Hello I just updated from 9.0.1 to 9.0.2 and it still gets stuck on update
"Upgrade in progress.
Wait for the end "
and it's been going through a good 2 hours.
Any ideas.
Thank you bonjour
Je viens de faire la mise à jour de la 9.0.1 vers la 9.0.2 et cela reste bloquer sur mise à jour
"Mise à niveau en cours d'exécution.
Attendez la fin"
et cela troune depuis 2 bonne heures.
Quelqu'un a une idée.
Merci
http://www.vkv.iea45.fr/
Hi,
It is because previous upgrade failed.
Delete file projeqtor/files/cron/MIGRATION
Hello
I made the change, and I made the update.
on the other hand I had errors (see log)
Thank you in advance
LOG
2021-01-12 09:09:16.674 ===== TRACE ===== =====================================
2021-01-12 09:09:16.674 ===== TRACE =====
2021-01-12 09:09:16.674 ===== TRACE ===== DataBase actual Version = V9.0.1
2021-01-12 09:09:16.674 ===== TRACE ===== ProjeQtOr actual Version = V9.0.2
2021-01-12 09:09:16.674 ===== TRACE =====
2021-01-12 09:09:16.674 ===== TRACE ===== =====================================
2021-01-12 09:09:16.674 ===== TRACE =====
2021-01-12 09:09:16.674 ===== TRACE ===== VERSION V9.0.2
2021-01-12 09:09:16.674 ===== TRACE =====
2021-01-12 09:09:16.688 ===== TRACE ===== 0 lines updated into table "navigation".
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `parameterProject`; check that it exists
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] For query : ALTER TABLE `parameter` DROP INDEX parameterProject;
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] Strack trace :
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] #0 Sql->query called at [/home/iea45800/public_html/intranet/planning/db/maintenanceFunctions.php:71]
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] #1 runScript called at [/home/iea45800/public_html/intranet/planning/db/maintenance.php:112]
2021-01-12 09:09:16.689 ** ERROR ** [V9.0.1] #2 include called at [/home/iea45800/public_html/intranet/planning/tool/loginCheck.php:143]
2021-01-12 09:09:16.690 ===== TRACE =====
2021-01-12 09:09:16.690 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V9.0.2 (see above message)
2021-01-12 09:09:16.690 ===== TRACE =====
2021-01-12 09:09:16.690 ===== TRACE ===== **********************************************
2021-01-12 09:09:16.690 ===== TRACE =====
2021-01-12 09:09:16.690 ** ERROR ** [V9.0.1] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `parameterUser`; check that it exists
2021-01-12 09:09:16.690 ** ERROR ** [V9.0.1] For query : ALTER TABLE `parameter` DROP INDEX parameterUser;
2021-01-12 09:09:16.691 ** ERROR ** [V9.0.1] Strack trace :
2021-01-12 09:09:16.691 ** ERROR ** [V9.0.1] #0 Sql->query called at [/home/iea45800/public_html/intranet/planning/db/maintenanceFunctions.php:71]
2021-01-12 09:09:16.691 ** ERROR ** [V9.0.1] #1 runScript called at [/home/iea45800/public_html/intranet/planning/db/maintenance.php:112]
2021-01-12 09:09:16.691 ** ERROR ** [V9.0.1] #2 include called at [/home/iea45800/public_html/intranet/planning/tool/loginCheck.php:143]
2021-01-12 09:09:16.691 ===== TRACE =====
2021-01-12 09:09:16.691 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V9.0.2 (see above message)
2021-01-12 09:09:16.691 ===== TRACE =====
2021-01-12 09:09:16.691 ===== TRACE ===== *******************************************
2021-01-12 09:09:16.691 ===== TRACE =====
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'parameterUserProject'
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] For query : CREATE UNIQUE INDEX parameterUserProject ON `parameter` (idUser, idProject);
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] Strack trace :
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] #0 Sql->query called at [/home/iea45800/public_html/intranet/planning/db/maintenanceFunctions.php:71]
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] #1 runScript called at [/home/iea45800/public_html/intranet/planning/db/maintenance.php:112]
2021-01-12 09:09:16.692 ** ERROR ** [V9.0.1] #2 include called at [/home/iea45800/public_html/intranet/planning/tool/loginCheck.php:143]
2021-01-12 09:09:16.692 ===== TRACE =====
2021-01-12 09:09:16.692 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V9.0.2 (see above message)
2021-01-12 09:09:16.692 ===== TRACE =====
2021-01-12 09:09:16.692 ===== TRACE ===== **********************************************
2021-01-12 09:09:16.692 ===== TRACE =====
2021-01-12 09:09:16.692 ===== TRACE =====
2021-01-12 09:09:16.692 ===== TRACE ===== DATABASE UPDATED
2021-01-12 09:09:16.692 ===== TRACE ===== WITH 3 ERRORS
2021-01-12 09:09:16.692 ===== TRACE =====
2021-01-12 09:09:17.608 ===== TRACE ===== =====================================
2021-01-12 09:09:17.608 ===== TRACE =====
2021-01-12 09:09:17.608 ===== TRACE ===== 3 ERRORS DURING UPGRADE TO VERSION V9.0.2
http://www.vkv.iea45.fr/
Can confirm issue with upgrade taking forever:
Installed working version: 9.0
Upgrade wanted: 9.0.2
No login possible, no error log, nothing happens.
PHP 7.4
These errors are normal : the previous migration was done, only final step (updating current version name in parameters) failed.
So dropping already dropped index failed, creating already created index failed.
You instance is OK
Same issue, same fix : remove file projeqtor/file/cron/MIGRATION
Hello
I ended up doing a backup of the database, uploading the files to the server, and updating.
Everything and ok, well almost.
http://www.vkv.iea45.fr/
File MIGRATION is not created, in this directory there's only index.php.
There's no log as well. Looks like nothing is written.
Tried multiple downloaded files, new direcotory, ....
Give up for this (rm -rf *).
diri
You must have errors.
Either in projeqtor error log or in apache error log or in php error log.
Please post any error logged.
NB : the more likely is incorrect access right to files : check that ph user have write acces to the whole projeqtor directory (recursively)
for instance on debian like distro :
sodu chown -R www-data: /var/www/html/projeqtor sodu chmod -R 755 /var/www/html/projeqtor