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.
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)
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 **
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)
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 {