Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Notifications

Clear all

Upgrade with errors

Submit issues

Last Post by Fathi Ben Nasr 4 years ago

3 Posts

2 Users

0 Reactions

1,781 Views

RSS

Fathi Ben Nasr

(@fathibn)

Posts: 59

Active Member

Topic starter

[#8606]

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'

Posted : 15 Nov 2022 13H53

babynus

(@babynus)

Posts: 14966

Main Contributor Admin

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.

Posted : 15 Nov 2022 21H15

Fathi Ben Nasr

(@fathibn)

Posts: 59

Active Member

Topic starter

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.

Posted : 15 Nov 2022 21H48

6 Forums
10.1 K Topics
39.8 K Posts
0 Online
16.6 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Discover the ProjeQtOr roadmap!

View the update history

Plan projects & manage work

Planning

Program

Ticketing

Work

Agile

Measure, adjust,and master.

Steering

Financial

Administration

Collaboration

Discover all the features

Even more from ProjeQtOr

Free demo

Training

Store

Resources

100% free? Where's the catch?

Learn all about our business model!

All plugins included and without limits?

Discover our hosting service which includes all plugins!

Subscription services

Hosting

Support

Subscription

Users Qlub

One-off services

Training

Assistance

On-demand evolution

Plugins

Discover all the services

Even more from ProjeQtOr

Free demo

Training

Store

Ressources

Visit our Forum

Testimonials

Stay informed

Our Community

Our articles and news

Project Management Blog

Join a thriving ecosystem

User Qlub

Roadmap ProjeQtOr

Suggestions

Discover our community

More of ProjeQtOr

Free demo

Training

Store

Resources

Latest version

Need an explanation?

Documentation & support

FAQ

Forum

Manual online

Installation & prerequisites

More of ProjeQtOr

Free demo

Training

Store

Resources

Upgrade with errors

Plan projects
& manage work

Measure, adjust,
and master.

Even more
from ProjeQtOr

100% free?
Where's the catch?