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.
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
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.
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.
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.