Forum

Bug update
 
Notifications
Retirer tout

Bug update

9 Posts
3 Utilisateurs
0 Reactions
9,131 Vu
VAUCHEY
(@protion)
Posts: 138
Active Member
Début du sujet
 
[#7182]

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/

 
Posté : 11 Jan PM 18:011
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

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


 
Posté : 11 Jan PM 19:011
VAUCHEY
(@protion)
Posts: 138
Active Member
Début du sujet
 

 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/

 
Posté : 12 Jan AM 11:011
 DiRi
(@diri)
Posts: 43
Active Member
 

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


 
Posté : 12 Jan PM 13:011
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 12 Jan PM 16:011
(@babynus)
Posts: 14952
Membre Admin
 

Same issue, same fix : remove file projeqtor/file/cron/MIGRATION


 
Posté : 12 Jan PM 16:011
VAUCHEY
(@protion)
Posts: 138
Active Member
Début du sujet
 

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/

 
Posté : 13 Jan PM 19:011
 DiRi
(@diri)
Posts: 43
Active Member
 

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


 
Posté : 22 Jan PM 12:011
(@babynus)
Posts: 14952
Membre Admin
 

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

 
Posté : 23 Jan PM 14:011
Share:
Retour en haut