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

error log file on update 8.6.0

More
22 Sep 2020 15:14 #1 by Durou C
error log file on update 8.6.0 was created by Durou C
I just do the upgrade on V8.6.0. I have two errors:

2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'surbooked' in 'plannedworkbaseline'
2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] For query : ALTER TABLE plannedworkbaseline MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] Strack trace :
2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:963]
2020-09-22 10:50:40.628 ***** ERROR ***** [V8.5.5] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:143]
2020-09-22 10:50:40.628 ===== TRACE =====
2020-09-22 10:50:40.628 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V8.6.0.mysql (see above message)


2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'surbooked' in 'planningelementbaseline'
2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] For query : ALTER TABLE planningelementbaseline MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] Strack trace :
2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:963]
2020-09-22 10:50:45.515 ***** ERROR ***** [V8.5.5] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:143]
2020-09-22 10:50:45.516 ===== TRACE =====
2020-09-22 10:50:45.516 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V8.6.0.mysql (see above message)
The topic has been locked.
More
22 Sep 2020 15:15 #2 by Durou C
Replied by Durou C on topic error log file on update 8.6.0
and also error (I'm not sur that is linked to V8.6.0)

2020-09-22 11:15:32.074 ***** ERROR ***** [V8.6.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor_test.opportunitymain' doesn't exist
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] For query : select * from opportunitymain where id=113
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] Strack trace :
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3089]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #1 SqlElement->getSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:726]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #2 SqlElement->__construct called at [/var/www/projeqtor/model/OpportunityMain.php:125]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #3 OpportunityMAin->__construct called at [/var/www/projeqtor/model/custom/Opportunity.php:169]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #4 Opportunity->setAttributes called at [/var/www/projeqtor/view/objectDetail.php:627]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #5 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:352]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor_test.opportunitymain' doesn't exist
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] For query : desc opportunitymain
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] Strack trace :
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3750]
2020-09-22 11:15:32.075 ***** ERROR ***** [V8.6.0] #1 SqlElement->getFormatList called at [/var/www/projeqtor/model/persistence/SqlElement.php:3294]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #2 SqlElement->getDataType called at [/var/www/projeqtor/model/persistence/SqlElement.php:3145]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #3 SqlElement->getSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:726]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #4 SqlElement->__construct called at [/var/www/projeqtor/model/OpportunityMain.php:125]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #5 OpportunityMAin->__construct called at [/var/www/projeqtor/model/custom/Opportunity.php:169]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #6 Opportunity->setAttributes called at [/var/www/projeqtor/view/objectDetail.php:627]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] #7 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:352]
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] ERROR *****
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] on file '/var/www/projeqtor/model/persistence/SqlElement.php' at line (3147)
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] cause = array_key_exists() expects parameter 2 to be array, boolean given
2020-09-22 11:15:32.076 ***** ERROR ***** [V8.6.0] ERROR *****
The topic has been locked.
More
24 Sep 2020 15:11 #3 by babynus
Replied by babynus on topic error log file on update 8.6.0
Error on your first post points out that migration to V8.1.0 had errors.
The script to migrate to V8.1.0 contains
ALTER TABLE `${prefix}plannedworkbaseline` ADD surbooked int(1) DEFAULT 0;
ALTER TABLE `${prefix}planningelementbaseline` ADD surbooked int(1) DEFAULT 0;
So not finding these fields point out a previous error.
By the way, these are not major as long as you don't use baselines.
But you should try and manually fix these issues (replay above statements, and then pay again those which failed on your current migration)
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Durou C
The topic has been locked.
More
24 Sep 2020 15:15 #4 by babynus
Replied by babynus on topic error log file on update 8.6.0
Your second post issue is a case issue.
In model/OpportunityMain.php, replace line 31 from
class OpportunityMAin extends SqlElement {
to
class OpportunityMain extends SqlElement {
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Durou C
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.035 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.

Login Form