View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Migration from old server/version to new - Page 2 - ProjeQtOr
 
 

Migration from old server/version to new

More
15 Apr 2024 09:36 #7 by Cpt_Jabberwock
Hello, It worked .... mostly
I thought of something to update the 9.5.5 on the new Debian 12 Test server
Following what you said, we made a dump without the Historyarchive table
we then tried to migrate the projeqtor onto the new Debian 12/Php 8.2 directly like we did with the other instance
However, 9.5.5 had too many PHP calls using the old commands and it made too much problems

So, I decided to try something else
We removed HistoryArchive from the mysql and then I tried to update projeqtor from 9.5.5 to 11.1.5 on a copy of the server in Debian 9
Doing 9.5.5 to 11.1.5 in one go borked it
Doing 9.5.5 to 11.1.5 by doing each individual update possible (the bold ones in the Autoinstall plugin) worked
This means I could then Migrate the newly updated Projeqtorcab to a debian 12 like I did the other ?

However, I encountered several problems after checking the Main Projeqtor and working a little on the Projeqtorcab test right here

First, on the Projeqtorcab I got this error message at some point in the log
Is it asking me to recreate historyarchive and each column in the table ?
 

Second, I got this error, and I don't know at all what it means
 
 

Third, I had this problem on some pages on the Cabinet test
First Image is the Main Projeqtor (the already updated one)
 

The second one is the Newly updated Cabinet test (still on Debian 9)
 


Finally, we didn't touch the updates on the Main Projeqtor after the Migration (and its test instance Formation which is a copy) until after our tests with Cabinet
When we click on the new updates in the plugin AutoInstall, it doesn't do anything and we get this error
 
 
 
I checked the same php files on the debian 9 Cabinet and didn't find anything different but maybe I missed something (we don't touch the php files in Projeqtor unless its something you told us to change)

Do you have solutions for one of those 4 problems ?
Ask me if you need more information/log/config file

Thank you
 
Attachments:

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

More
19 Apr 2024 15:17 #8 by babynus
historyarchive must exist.
So you have to create it (even if empty)

Babynus
Administrator of ProjeQtOr web site

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

More
25 Apr 2024 14:17 - 25 Apr 2024 14:56 #9 by Cpt_Jabberwock
Thank you,
From my last post, the 4 problems

1 & 3 were linked, for some reasons
I haven't had this error log since recreating the Historyarchive table
and the screen got its background and the options got their proper name header after the table got added back to mysql

2: No Idea what that thing is still

4: Problem on updates on the Debian 12
it was the Curl extention of PHP that isn't installed by default on new server
thus making Autoinstall work again on the new Debian 12 (since we copied only Projeqtor, we had forgotten that Curl was an addon not installed by default)
Last edit: 25 Apr 2024 14:56 by Cpt_Jabberwock.

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

More
28 Apr 2024 19:33 #10 by babynus
2: No Idea what that thing is still
it is due to missing comma before "startDate"
The source is use of an old version of Screen Customisation plugin. Be sure to migrate to latest one.

Babynus
Administrator of ProjeQtOr web site

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

More
29 Apr 2024 09:07 #11 by Cpt_Jabberwock
Now that you say it and I look at the line proper, it seems so evident

"thingy" "stardate" missing the comma in between the 2

Thank you, now that everything is back to normal, we just need to purge the historyarchive from projeqtorcab, then I'll be able to upgrade it as much as possible on the old debian 9 before migrating to debian 12

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

Moderators: babynusprotion
Time to create page: 0.129 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.