View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version - ProjeQtOr
 
 

Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version

More
10 Feb 2016 16:51 #1 by Lysakov
Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version was created by Lysakov
Hi, Babynus.

WE NEED HELP!

During upgrade from previous stable version 5.0.6 to last stable 5.1.0 or current 5.2.2 I have 26 errors!!!
(6 on migration 5.0.6 -> 5.1.0a
20 on migration 5.1.0a -> 5.1.0
next process is ok).
After upgrade program works incorrect.
So some works in diary duplicates, no resources (only ids), no data to montly reports.
Also users have proplems with saving data in real work allocation (some can, somebody couldn't).
So I couldn't switch from 5.0.6 version. I must state on 5.0.6. :(

As I see you give rolling upgrade from version to version (including minor updates) and increase number of tables in database.

See attachment of upgrade procedure.

database postgres 9.1 on debian 7 64bit
Attachments:

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

More
10 Feb 2016 16:57 #2 by babynus
Replied by babynus on topic Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version
Clearly the logs show you ran migration several times on same database.
So errors during migration are "normal" (you cannot create a table that already exists).
This can possibly explain dupplicate data.

If you can, revert to latest stable version of data and try clean install from scratch.
Babynus
Administrator of ProjeQtOr web site

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

More
10 Feb 2016 17:12 #3 by Lysakov
Replied by Lysakov on topic Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version
I already try clean install.
But in this case restore database backup to new clean table also incorrect (incorrect for application, see errors examples).

I try different scenarious but couldn't correctly (for application and users) swith 5.0.6 -> 5.1.0.

Also I haven't several migration. Simply deploy for example v 5.2.2 over 5.0.6.
But errors for step by step migration 5.0.6 -> 5.1.0 are the same.

Also errors in log file not only duplicate tables but also duplicate columns in tables.

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

More
10 Feb 2016 17:31 #4 by babynus
Replied by babynus on topic Problem with upgrade 5.0.6 to 5.1.x (5.2.x) version

Also errors in log file not only duplicate tables but also duplicate columns in tables.

Error do not duplicate, errors indicate tables and columns cannot be duplicated.

Sure if error indicate duplicate tables during script, it means that dbVersion in parameter table do not fit the real version of your database.
For instance, in V5.0.6, you should not have column 'comment' on table 'plugin'.
Table is created in V5.0.0 without this column which is added in V5.1.0.a.

Same for table projecthistory : it is created in V5.1.0a, and can not exist in V5.0.6.
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.028 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