View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Bug update - ProjeQtOr
 
 

Bug update

More
11 Jan 2021 16:39 - 13 Jan 2021 17:27 #1 by protion
[SOLVED] Bug update was created by protion
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
Last edit: 13 Jan 2021 17:27 by protion.

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

More
11 Jan 2021 17:14 #2 by babynus
Replied by babynus on topic Bug update
Hi,

It is because previous upgrade failed.
Delete file projeqtor/files/cron/MIGRATION

Babynus
Administrator of ProjeQtOr web site

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

More
12 Jan 2021 09:34 #3 by protion
Replied by protion on topic Bug update
 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

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

More
12 Jan 2021 11:07 #4 by diri
Replied by diri on topic Bug update
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

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

More
12 Jan 2021 14:19 #5 by babynus
Replied by babynus on topic Bug update
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

Babynus
Administrator of ProjeQtOr web site

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

More
12 Jan 2021 14:19 #6 by babynus
Replied by babynus on topic Bug update
Same issue, same fix : remove file projeqtor/file/cron/MIGRATION

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.048 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.