Hi Babynus,
I encounter an issue when I try to update my V7.2.5 Projeqtor to V7.3.2.
Here are the steps I followed on my CentOs 7.6 x64 server :
wget https://netcologne.dl.sourceforge.net/project/projectorria/projeqtorV7.3.2.zip unzip projeqtorV7.3.2.zip chown -R apache projeqtor
When I go on my Projeqtor login page, I first logged successfully.
Then the migration also proceeded successfully.
Then again, I logged successfully, but I landed on a blank page.
I find nothing conclusive in my apache or php logs.
Here is my Projeqtor log :
2019-01-03 09:47:12.973 ===== TRACE ===== NEW CONNECTED USER 'mygreatprojeqtoruser'
2019-01-03 11:31:10.815 ===== TRACE ===== DISCONNECTED USER 'mygreatprojeqtoruser'
2019-01-03 11:31:19.368 ===== TRACE ===== Login error for user 'mygreatprojeqtoruser'
2019-01-03 11:31:24.331 ===== TRACE =====
2019-01-03 11:31:24.331 ===== TRACE ===== =====================================
2019-01-03 11:31:24.331 ===== TRACE =====
2019-01-03 11:31:24.331 ===== TRACE ===== DataBase actual Version = V7.2.5
2019-01-03 11:31:24.331 ===== TRACE ===== ProjeQtOr actual Version = V7.3.2
2019-01-03 11:31:24.331 ===== TRACE =====
2019-01-03 11:31:24.332 ===== TRACE ===== =====================================
2019-01-03 11:31:24.332 ===== TRACE =====
2019-01-03 11:31:24.332 ===== TRACE ===== VERSION V7.2.6
2019-01-03 11:31:24.332 ===== TRACE =====
2019-01-03 11:31:24.374 ===== TRACE ===== 0 lines deleted from table "columnselector".
2019-01-03 11:31:24.725 ===== TRACE ===== Table "budget" altered.
2019-01-03 11:31:24.725 ===== TRACE =====
2019-01-03 11:31:24.725 ===== TRACE ===== DATABASE UPDATED
2019-01-03 11:31:24.725 ===== TRACE ===== WITH NO ERROR
2019-01-03 11:31:24.725 ===== TRACE =====
2019-01-03 11:31:24.726 ===== TRACE ===== =====================================
2019-01-03 11:31:24.726 ===== TRACE =====
2019-01-03 11:31:24.726 ===== TRACE ===== VERSION V7.3.0
2019-01-03 11:31:24.726 ===== TRACE =====
2019-01-03 11:31:24.729 ===== TRACE ===== 1 lines updated into table "menu".
2019-01-03 11:31:24.905 ===== TRACE ===== Table "report" altered.
2019-01-03 11:31:24.907 ===== TRACE ===== 14 lines updated into table "report".
2019-01-03 11:31:25.233 ===== TRACE ===== Table "attachment" altered.
2019-01-03 11:31:25.448 ===== TRACE ===== Table "documentversion" altered.
2019-01-03 11:31:25.642 ===== TRACE ===== Table "tender" altered.
2019-01-03 11:31:25.743 ===== TRACE ===== Table "providerbill" altered.
2019-01-03 11:31:25.797 ===== TRACE ===== Table "providerorder" altered.
2019-01-03 11:31:25.806 ===== TRACE ===== 4 lines inserted into table "parameter".
2019-01-03 11:31:25.806 ===== TRACE =====
2019-01-03 11:31:25.806 ===== TRACE ===== DATABASE UPDATED
2019-01-03 11:31:25.806 ===== TRACE ===== WITH NO ERROR
2019-01-03 11:31:25.806 ===== TRACE =====
2019-01-03 11:31:25.807 ===== TRACE ===== =====================================
2019-01-03 11:31:25.807 ===== TRACE =====
2019-01-03 11:31:25.807 ===== TRACE ===== VERSION V7.3.2
2019-01-03 11:31:25.807 ===== TRACE =====
2019-01-03 11:31:25.810 ===== TRACE ===== 0 lines deleted from table "columnselector".
2019-01-03 11:31:25.811 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2019-01-03 11:31:25.815 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2019-01-03 11:31:25.906 ===== TRACE ===== 0 lines updated into table "work".
2019-01-03 11:31:25.907 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2019-01-03 11:31:25.925 ===== TRACE ===== 0 lines deleted from table "planningelement".
2019-01-03 11:31:25.925 ===== TRACE =====
2019-01-03 11:31:25.925 ===== TRACE ===== DATABASE UPDATED
2019-01-03 11:31:25.925 ===== TRACE ===== WITH NO ERROR
2019-01-03 11:31:25.925 ===== TRACE =====
2019-01-03 11:31:26.667 ===== TRACE ===== =====================================
2019-01-03 11:31:26.668 ===== TRACE =====
2019-01-03 11:31:26.668 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V7.3.2
2019-01-03 11:31:26.668 ===== TRACE =====
2019-01-03 11:31:26.668 ===== TRACE ===== =====================================
2019-01-03 11:31:26.668 ===== TRACE =====
2019-01-03 11:31:34.675 ===== TRACE ===== NEW CONNECTED USER 'mygreatprojeqtoruser'
2019-01-03 12:09:33.973 ..... SCRIPT .... 80.78.5.112 =====/pqt/view/main.php
2019-01-03 12:09:33.995 ..... SCRIPT .... 80.78.5.112 Page=main.php
2019-01-03 12:09:34.046 ..... SCRIPT .... 80.78.5.112 getProfile(objectOrIdProject=Audit #103)
2019-01-03 12:09:34.046 ..... SCRIPT .... 80.78.5.112 getProfile(objectOrIdProject=Audit #103)
2019-01-03 12:09:34.054 ..... SCRIPT .... 80.78.5.112 ->/view/main.php
Can you help me please ?
What do you need more I provide to you ?
I provided to you a login page screenshot after update and a file with the source code page from my browser.
Jordan LE NUFF
IT Project Manager
Clear browser cache and try again 😉
Unfortunately, it's already done 🙁
Any idea ?
Jordan LE NUFF
IT Project Manager
Babynus,
Do you need more information ?
What can I provide to you ?
Jordan LE NUFF
IT Project Manager
Check for errors in browser console and report any error here.
Here some traces from chrome developper console
There is no error.
However, what I found abnormal is that the source code from the main page seems to not fully served by the server. There is no html closing tag :
Do you need more information ?
Jordan LE NUFF
IT Project Manager
On dev tool, you showed network tab.
We need content of log console.
Here is the log console :
Jordan LE NUFF
IT Project Manager
No error.
Difficult to find source without a hint.
Could you try and migrate step by step, installing each patch to find which leads to issue ?
Hi Babynus,
Sorry for the time response.
Here are the results of the step-by-step upgrade :
V7.2.5 ==> V7.2.6 Ok
V7.2.6 ==> V7.2.7 Ok
V7.2.7 ==> V7.3.0 KO, empty page
I have uploaded the log file, but there is no error...
As my screenshots showed, the main.php loading is breaking at line 301. It seems there is an issue in retrieving the Html2Pdf version.
Here is the source code from the main.php file :
aboutMessage+=' . Dojo : '+dojo.version+'
';
aboutMessage+=' . html2pdf : getVersion();?>'+'
';
aboutMessage+=' . CK Editor : '+CKEDITOR.version+'
';
And here is the source code issued from the web server :
aboutMessage+=' . Dojo : '+dojo.version+'
';
aboutMessage+=' . html2pdf :
Does this give you some leads?
Jordan LE NUFF
IT Project Manager
Also, when I compare the V7.3.0 main.php file with the V7.2.7 main.php file, that's exactly here where there was a modification by the update.
Jordan LE NUFF
IT Project Manager
After a few tests, the error seems to be in the "$html2pdf = new Html2Pdf();"
I'm still investigating.
Jordan LE NUFF
IT Project Manager
Hi Babynus,
I ended up finding my problem.
Thanks to the loading problem of PHP class html2pdf, I realized that my instance of PHP was corrupted (or unstable, understand it as you like).
So I updated my PHP from 7.0 to 7.3.
But then, I encountered other issues.
Indeed, I could not connect anymore. I encountered these error messages :
1 2019-01-15 12: 23: 54.170 ===== TRACE ===== Login error for user '% xêiæ] 3'
2 2019-01-15 12: 37: 08.879 ===== TRACE ===== Login error for user '# Ó ù|) '
3 2019-01-15 13: 10: 31.708 ===== TRACE ===== Login error for user ' 9xçk ^? Ö'
4 2019-01-15 13: 16: 02.992 ===== TRACE ===== Login error for user '^ E4C3y ³'
5 2019-01-15 13: 27: 55.943 ===== TRACE ===== Login error for user 'ÅG © Ã ©')
6 2019-01-15 13: 32: 47.295 ===== TRACE ===== Login error for user '38BÎ ^ W = '
This was similar to the error messages found on the thread https://www.projeqtor.org/en/forum/5-ask-questions/9418-login-error-for-user
Looking at the php logs, I had the following error messages :
[15-Jan-2019 15:04:33 Europe / Paris] PHP Warning: session_start (): The session id is too long or contains illegal characters, valid characters az, AZ, 0-9 and '-,' in /usr/share/projeqtor/tool/projeqtor.php on line 39
[15-Jan-2019 15:04:33 Europe / Paris] PHP Warning: session_start (): Failed to read session data: files (/var/lib/php/session) in /usr/share/projeqtor/tool/projeqtor.php on line 39
In fact, I simply had to erase from my browser the cookies of my projeqtor.
In fine, I successfully upgraded to v7.3.3.
Thank you Babynus.
Jordan LE NUFF
IT Project Manager
Great you found the solution.
Have a nice play with projeqtor !!