Upgrade form V7.0.8 to V.7.4.0

service.automation
Topic Author
Offline
Junior Member

12 Fév 2019 10:51 #7 by service.automation

Replied by service.automation on topic Upgrade form V7.0.8 to V.7.4.0

I have upgraded my version of projeqtor from V7.0.8 to V7.4.0.

In order to upgrade, I have stopped the cron task and close the application in the Administration tool.

I have replaced in the dedicated folder, the old version to new version.
But after folder replacement, during first connection, I never seen the Message (Upgrade database in progress to V7.4.0). The connexion was accepted and I have seen white page in Projeqtor.

I have only seen the message for Upgrade Database When I have upgraded to version V7.4.1.

Thank you in advance,

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

12 Fév 2019 11:16 #8 by babynus

Replied by babynus on topic Upgrade form V7.0.8 to V.7.4.0

I don't know how it is possible, but it seems you missed migration from 7.0.8 to 7.4.1.

My advise :
1) backup you DB (in case of major issue, to be able to restore data)
2) on table parameter, change parameterValue to 'V7.0.8' for line with parameterCode='dbVersion' (it should be first line with current value 'V7.4.1')
3) disconnect from application and reconnect as admin : you should see on top right, migration from V7.0.8 to V7.4.1
4) check log file that migration was correctly executed.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

service.automation
Topic Author
Offline
Junior Member

12 Fév 2019 13:43 #9 by service.automation

Replied by service.automation on topic Upgrade form V7.0.8 to V.7.4.0

THe database is already in version V7.4.1.

Have you seen the last log files ? I have posted two files.

The first was wrong, because the cron task was not started.

Any other idea ?

Regards,

Fred

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

12 Fév 2019 14:05 #10 by babynus

Replied by babynus on topic Upgrade form V7.0.8 to V.7.4.0

THe database is already in version V7.4.1.

That is the issue : db is considered as V7.4.1, but structure of tables does not fit V7.4.1

Have you seen the last log files ? I have posted two files.

Yes, and this is what telles me that db structure is not correct.

The first was wrong, because the cron task was not started.

Migration process has nothing to deal with Cron processus

Any other idea ?

No other.
Just apply what I propoosed

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

service.automation
Topic Author
Offline
Junior Member

12 Fév 2019 14:55 #11 by service.automation

Replied by service.automation on topic Upgrade form V7.0.8 to V.7.4.0

It's Strange.. I have received an error message, but every thinks seems corrrect.

I can open session with user, and we are in version V7.4.1.

Please find attached log file and print screen.

Regards,

Fred

File Attachment:

File Name: projeqtor_...12-2.log
File Size:920 KB

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

12 Fév 2019 15:17 #12 by babynus

Replied by babynus on topic Upgrade form V7.0.8 to V.7.4.0

The log confirms that your DB was still in V7.0.8 format :

2019-02-12 14:44:50.156 ===== TRACE ===== =====================================
2019-02-12 14:44:50.160 ===== TRACE ===== 
2019-02-12 14:44:50.168 ===== TRACE ===== DataBase actual Version = V7.0.8
2019-02-12 14:44:50.173 ===== TRACE ===== ProjeQtOr actual Version = V7.4.1
2019-02-12 14:44:50.178 ===== TRACE ===== 
2019-02-12 14:44:50.184 ===== TRACE ===== =====================================
2019-02-12 14:44:50.188 ===== TRACE ===== 
2019-02-12 14:44:50.192 ===== TRACE ===== VERSION V7.1.0
2019-02-12 14:44:50.198 ===== TRACE ===== 
2019-02-12 14:44:50.356 ===== TRACE =====  Table "otherclient" created.
2019-02-12 14:44:50.388 ===== TRACE =====  Index "otherclientRef" created.
2019-02-12 14:44:50.408 ===== TRACE =====  Index "otherclientVersion" created.
2019-02-12 14:44:50.435 ===== TRACE =====  Index "otherclientUser" created.
2019-02-12 14:44:50.440 ===== TRACE =====  1 lines inserted into table "report".
2019-02-12 14:44:50.446 ===== TRACE =====  4 lines inserted into table "reportparameter".
2019-02-12 14:44:50.452 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2019-02-12 14:44:50.458 ===== TRACE =====  1 lines inserted into table "menu".
2019-02-12 14:44:50.464 ===== TRACE =====  1 lines inserted into table "habilitation".
2019-02-12 14:44:50.475 ===== TRACE =====  1 lines inserted into table "accessright".
2019-02-12 14:44:50.694 ===== TRACE =====  Table "resource" altered.
2019-02-12 14:44:50.835 ===== TRACE =====  Table "assignment" altered.
2019-02-12 14:44:50.974 ===== TRACE =====  Table "assignment" altered.
2019-02-12 14:44:51.016 ===== TRACE =====  Table "resourceteamaffectation" created.
2019-02-12 14:44:51.097 ===== TRACE =====  Table "copyable" altered.
2019-02-12 14:44:51.104 ===== TRACE =====  1 lines updated into table "copyable".
2019-02-12 14:44:51.110 ===== TRACE =====  1 lines updated into table "copyable".
2019-02-12 14:44:51.115 ===== TRACE =====  1 lines updated into table "copyable".
2019-02-12 14:44:51.121 ===== TRACE =====  1 lines updated into table "copyable".
2019-02-12 14:44:51.125 ===== TRACE =====  0 lines updated into table "productlanguage".
2019-02-12 14:44:51.130 ===== TRACE =====  0 lines updated into table "productlanguage".
2019-02-12 14:44:51.211 ===== TRACE =====  Table "deliverable" altered.
2019-02-12 14:44:51.345 ===== TRACE =====  Table "delivery" altered.
2019-02-12 14:44:51.352 ===== TRACE =====  0 lines updated into table "dependency".
2019-02-12 14:44:51.357 ===== TRACE =====  0 lines updated into table "dependency".
2019-02-12 14:44:51.366 ===== TRACE =====  1 lines inserted into table "menu".
2019-02-12 14:44:51.371 ===== TRACE =====  1 lines inserted into table "habilitation".
2019-02-12 14:44:51.377 ===== TRACE =====  1 lines inserted into table "report".
2019-02-12 14:44:51.382 ===== TRACE =====  3 lines inserted into table "reportparameter".
2019-02-12 14:44:51.390 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2019-02-12 14:44:51.532 ===== TRACE =====  Table "type" altered.

The error you got is for migration from V7.4.0 to V7.4.1, that was already played

2019-02-12 14:44:56.391 ===== TRACE ===== =====================================
2019-02-12 14:44:56.396 ===== TRACE ===== 
2019-02-12 14:44:56.400 ===== TRACE ===== VERSION V7.4.1
2019-02-12 14:44:56.405 ===== TRACE ===== 
2019-02-12 14:44:56.414 ***** ERROR ***** [V7.0.8] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'isManualProgress' dÃ©jÃ  utilisÃ©
2019-02-12 14:44:56.419 ***** ERROR ***** [V7.0.8]    For query : ALTER TABLE `planningelementbaseline`
ADD `isManualProgress` int(1) unsigned DEFAULT '0';
2019-02-12 14:44:56.423 ***** ERROR ***** [V7.0.8]    Strack trace :
2019-02-12 14:44:56.427 ***** ERROR ***** [V7.0.8]    #0 Sql->query called at [C:\wamp\www\projeqtor\db\maintenanceFunctions.php:71]
2019-02-12 14:44:56.432 ***** ERROR ***** [V7.0.8]    #1 runScript called at [C:\wamp\www\projeqtor\db\maintenance.php:110]
2019-02-12 14:44:56.436 ***** ERROR ***** [V7.0.8]    #2 include called at [C:\wamp\www\projeqtor\tool\loginCheck.php:143]
2019-02-12 14:44:56.441 ===== TRACE ===== 
2019-02-12 14:44:56.446 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V7.4.1 (see above message)
2019-02-12 14:44:56.450 ===== TRACE ===== 
2019-02-12 14:44:56.455 ===== TRACE ===== *************************************************

So all is fine now !

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion

Time to create page: 0.057 seconds

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Upgrade form V7.0.8 to V.7.4.0

Attachments:

File Attachment:

Attachments:

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Upgrade form V7.0.8 to V.7.4.0

Attachments:

File Attachment:

Attachments:

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form