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

Upgrade with errors

More
15 Nov 2022 11:53 - 15 Nov 2022 19:40 #1 by fathibn
Upgrade with errors was created by fathibn
Hi,
I have just upgraded my ProjeQtor instance and due to a file permission issue, it threw some errors. How can i correct this please ?
2022-11-15 11:41:49.891 ===== TRACE =====
2022-11-15 11:41:49.891 ===== TRACE ===== =====================================
2022-11-15 11:41:49.891 ===== TRACE =====
2022-11-15 11:41:49.891 ===== TRACE ===== DataBase actual Version = V10.1.0
2022-11-15 11:41:49.891 ===== TRACE ===== ProjeQtOr actual Version = V10.1.2
2022-11-15 11:41:49.891 ===== TRACE =====
2022-11-15 11:41:49.891 ===== TRACE ===== =====================================
2022-11-15 11:41:49.891 ===== TRACE =====
2022-11-15 11:41:49.891 ===== TRACE ===== VERSION V10.1.1
2022-11-15 11:41:49.891 ===== TRACE =====
2022-11-15 11:41:50.121 ===== TRACE =====  Table "criticalresources" dropped.
2022-11-15 11:41:50.127 ===== TRACE =====  Table "criticalresourcesprojects" dropped.
2022-11-15 11:41:50.128 ===== TRACE =====
2022-11-15 11:41:50.128 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:41:50.128 ===== TRACE =====  WITH NO ERROR
2022-11-15 11:41:50.128 ===== TRACE =====
2022-11-15 11:41:50.128 ===== TRACE ===== =====================================
2022-11-15 11:41:50.128 ===== TRACE =====
2022-11-15 11:41:50.128 ===== TRACE ===== VERSION V10.1.2
2022-11-15 11:41:50.128 ===== TRACE =====
2022-11-15 11:41:50.169 ===== TRACE =====  Table "project" altered.
2022-11-15 11:41:50.170 ===== TRACE =====
2022-11-15 11:41:50.170 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:41:50.170 ===== TRACE =====  WITH NO ERROR
2022-11-15 11:41:50.170 ===== TRACE =====
2022-11-15 11:41:50.174 ***** ERROR ***** [V10.1.0] ERROR *****
2022-11-15 11:41:50.174 ***** ERROR ***** [V10.1.0] on file '/opt/projeqtor/htdocs/tool/file.php' at line (51)
2022-11-15 11:41:50.174 ***** ERROR ***** [V10.1.0] cause = unlink(../model/CriticalResources.php): Permission denied
2022-11-15 11:42:51.837 ===== TRACE =====
2022-11-15 11:42:51.837 ===== TRACE ===== =====================================
2022-11-15 11:42:51.837 ===== TRACE =====
2022-11-15 11:42:51.837 ===== TRACE ===== DataBase actual Version = V10.1.0
2022-11-15 11:42:51.837 ===== TRACE ===== ProjeQtOr actual Version = V10.1.2
2022-11-15 11:42:51.837 ===== TRACE =====
2022-11-15 11:42:51.837 ===== TRACE ===== =====================================
2022-11-15 11:42:51.837 ===== TRACE =====
2022-11-15 11:42:51.837 ===== TRACE ===== VERSION V10.1.1
2022-11-15 11:42:51.837 ===== TRACE =====
2022-11-15 11:42:51.838 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresources" does not exist
2022-11-15 11:42:51.838 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresources;
2022-11-15 11:42:51.838 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:42:51.839 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:42:51.839 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:42:51.839 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:42:51.839 ===== TRACE =====
2022-11-15 11:42:51.839 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:42:51.839 ===== TRACE =====
2022-11-15 11:42:51.839 ===== TRACE ===== *************************************************
2022-11-15 11:42:51.839 ===== TRACE =====
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresourcesprojects" does not exist
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresourcesprojects;
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:42:51.840 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:42:51.840 ===== TRACE =====
2022-11-15 11:42:51.840 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:42:51.840 ===== TRACE =====
2022-11-15 11:42:51.840 ===== TRACE ===== *************************************************
2022-11-15 11:42:51.840 ===== TRACE =====
2022-11-15 11:42:51.841 ===== TRACE =====
2022-11-15 11:42:51.841 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:42:51.841 ===== TRACE =====  WITH 2 ERRORS
2022-11-15 11:42:51.841 ===== TRACE =====
2022-11-15 11:42:51.841 ===== TRACE ===== =====================================
2022-11-15 11:42:51.841 ===== TRACE =====
2022-11-15 11:42:51.841 ===== TRACE ===== VERSION V10.1.2
2022-11-15 11:42:51.841 ===== TRACE =====
2022-11-15 11:42:51.851 ===== TRACE =====  Table "project" altered.
2022-11-15 11:42:51.851 ===== TRACE =====
2022-11-15 11:42:51.851 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:42:51.851 ===== TRACE =====  WITH NO ERROR
2022-11-15 11:42:51.851 ===== TRACE =====
2022-11-15 11:42:51.853 ***** ERROR ***** [V10.1.0] ERROR *****
2022-11-15 11:42:51.853 ***** ERROR ***** [V10.1.0] on file '/opt/projeqtor/htdocs/tool/file.php' at line (51)
2022-11-15 11:42:51.853 ***** ERROR ***** [V10.1.0] cause = unlink(../model/CriticalResources.php): Permission denied
2022-11-15 11:42:58.625 ===== TRACE =====
2022-11-15 11:42:58.625 ===== TRACE ===== =====================================
2022-11-15 11:42:58.625 ===== TRACE =====
2022-11-15 11:42:58.625 ===== TRACE ===== DataBase actual Version = V10.1.0
2022-11-15 11:42:58.625 ===== TRACE ===== ProjeQtOr actual Version = V10.1.2
2022-11-15 11:42:58.625 ===== TRACE =====
2022-11-15 11:42:58.625 ===== TRACE ===== =====================================
2022-11-15 11:42:58.625 ===== TRACE =====
2022-11-15 11:42:58.625 ===== TRACE ===== VERSION V10.1.1
2022-11-15 11:42:58.625 ===== TRACE =====
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresources" does not exist
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresources;
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:42:58.627 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:42:58.627 ===== TRACE =====
2022-11-15 11:42:58.627 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:42:58.627 ===== TRACE =====
2022-11-15 11:42:58.627 ===== TRACE ===== *************************************************
2022-11-15 11:42:58.627 ===== TRACE =====
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresourcesprojects" does not exist
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresourcesprojects;
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:42:58.628 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:42:58.628 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE ===== *************************************************
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:42:58.629 ===== TRACE =====  WITH 2 ERRORS
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE ===== =====================================
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.629 ===== TRACE ===== VERSION V10.1.2
2022-11-15 11:42:58.629 ===== TRACE =====
2022-11-15 11:42:58.637 ===== TRACE =====  Table "project" altered.
2022-11-15 11:42:58.637 ===== TRACE =====
2022-11-15 11:42:58.637 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:42:58.637 ===== TRACE =====  WITH NO ERROR
2022-11-15 11:42:58.637 ===== TRACE =====
2022-11-15 11:42:58.639 ***** ERROR ***** [V10.1.0] ERROR *****
2022-11-15 11:42:58.639 ***** ERROR ***** [V10.1.0] on file '/opt/projeqtor/htdocs/tool/file.php' at line (51)
2022-11-15 11:42:58.639 ***** ERROR ***** [V10.1.0] cause = unlink(../model/CriticalResources.php): Permission denied
2022-11-15 11:44:50.368 ===== TRACE =====
2022-11-15 11:44:50.368 ===== TRACE ===== =====================================
2022-11-15 11:44:50.369 ===== TRACE =====
2022-11-15 11:44:50.369 ===== TRACE ===== DataBase actual Version = V10.1.0
2022-11-15 11:44:50.369 ===== TRACE ===== ProjeQtOr actual Version = V10.1.2
2022-11-15 11:44:50.369 ===== TRACE =====
2022-11-15 11:44:50.369 ===== TRACE ===== =====================================
2022-11-15 11:44:50.369 ===== TRACE =====
2022-11-15 11:44:50.369 ===== TRACE ===== VERSION V10.1.1
2022-11-15 11:44:50.369 ===== TRACE =====
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresources" does not exist
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresources;
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:44:50.371 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:44:50.372 ===== TRACE =====
2022-11-15 11:44:50.372 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:44:50.372 ===== TRACE =====
2022-11-15 11:44:50.372 ===== TRACE ===== *************************************************
2022-11-15 11:44:50.372 ===== TRACE =====
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  table "criticalresourcesprojects" does not exist
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0]    For query : DROP TABLE criticalresourcesprojects;
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0]    Strack trace :
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0]    #0 Sql->query called at [/opt/projeqtor/htdocs/db/maintenanceFunctions.php:72]
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0]    #1 runScript called at [/opt/projeqtor/htdocs/db/maintenance.php:140]
2022-11-15 11:44:50.373 ***** ERROR ***** [V10.1.0]    #2 include called at [/opt/projeqtor/htdocs/tool/loginCheck.php:144]
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.374 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V10.1.1 (see above message)
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.374 ===== TRACE ===== *************************************************
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.374 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:44:50.374 ===== TRACE =====  WITH 2 ERRORS
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.374 ===== TRACE ===== =====================================
2022-11-15 11:44:50.374 ===== TRACE =====
2022-11-15 11:44:50.375 ===== TRACE ===== VERSION V10.1.2
2022-11-15 11:44:50.375 ===== TRACE =====
2022-11-15 11:44:50.381 ===== TRACE =====  Table "project" altered.
2022-11-15 11:44:50.382 ===== TRACE =====
2022-11-15 11:44:50.382 ===== TRACE ===== DATABASE UPDATED
2022-11-15 11:44:50.382 ===== TRACE =====  WITH NO ERROR
2022-11-15 11:44:50.382 ===== TRACE =====
2022-11-15 11:44:57.298 ===== TRACE ===== Cron normally stopped at 15/11/2022 11:44:57
2022-11-15 11:45:00.844 ===== TRACE ===== =====================================
2022-11-15 11:45:00.844 ===== TRACE =====
2022-11-15 11:45:00.844 ===== TRACE ===== 2 ERRORS DURING UPGRADE TO VERSION V10.1.2
2022-11-15 11:45:00.844 ===== TRACE =====
2022-11-15 11:45:00.844 ===== TRACE ===== =====================================
2022-11-15 11:45:00.844 ===== TRACE =====
2022-11-15 11:47:01.018 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-11-15 11:47:06.287 ===== TRACE ===== Cron started at 15/11/2022 11:47:06
2022-11-15 11:47:08.848 ***** ERROR ***** [V10.1.2] Try to run cron already running - Exit
2022-11-15 11:48:01.911 ===== TRACE ===== DISCONNECTED USER 'admin'
2022-11-15 11:48:33.466 ===== TRACE ===== NEW CONNECTED USER 'admin'
Last edit: 15 Nov 2022 19:40 by fathibn.

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

More
15 Nov 2022 19:15 #2 by babynus
Replied by babynus on topic Upgrade with errors
PHP user should have write access to most projector files.
Process tries to remove non used files, but it was rejected.
Deletion of tables that fail is not major : you just don't have the table we try to remove.
 

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: fathibn

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

More
15 Nov 2022 19:48 #3 by fathibn
Replied by fathibn on topic Upgrade with errors
I usually give php user write access to a subset of the projeqtor directories, mainly files/ including the directories beneath it and it worked finely till now. Maybe I should give it write access to all web directories on update/upgrade and then revert back to my previous config, as it seems not needing write access to other directories than the ones beneath files/ for normal operations.

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

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