Since we have update our server with PHP7.4 we have an problem with imputation save.
In my php.ini file, I have allow max_input_vars = 4000.
When I type some imputation data, I save it but when I refresh my imputation screen, I can't find all my data.
To save it, I need to save twice my form.
My version of projeqtor is 9.1.5
In my log file, I have no more information or error message.
I have check again my php.ini file and all recommandation of installation are done.
In the PDF file you can find my test of this functionnality :
Hi,
First try and execute consistency check (in admin screen)
If issue persists check projector log file and browser console for errors.
Hi,
I have launch the check countrol in admin panel. And I launch the correct action.
I have no message of in development consol when I submit my form.
And my log file has no message of ERROR.
Thinks
Please check for errors in projeqtor log file.
(apache access log file is no use)
Hi,
The Log file comes from Projeqtor and not apache.
Yes, you're right.
Script log level is no use in that case.
But there is no error in projeqtor log file
In fact, as it is an error 500 retrined by the http request, error could be in apache error log file or in php error log file
Hi,
Apache log rec just this message when I try to save my imputation :
[Wed Jun 16 16:53:52.408083 2021] [php7:notice] [pid 3894] [client 172.21.2.22:55908] PHP Fatal error: Uncaught Error: Class 'Mail' not found in /var/www/gestion-projet-it/projeqtor/tool/projeqtor.php:2241nStack trace:n#0 /var/www/gestion-projet-it/projeqtor/tool/projeqtor.php(2200): sendMail_phpmailer()n#1 /var/www/gestion-projet-it/projeqtor/model/Cron.php(311): sendMail()n#2 /var/www/gestion-projet-it/projeqtor/tool/cronRelaunch.php(28): Cron::abort()n#3 [internal function]: cronAbort()n#4 {main}n thrown in /var/www/gestion-projet-it/projeqtor/tool/projeqtor.php on line 2241, referer: https://preprod-gestion-projet-it.cb.canon.fr/view/main.php
I have no more information
When I submit again my imputation, I no more message. So I think this error is not about my problem,
Hi,
We brought some changes on saveImputation.php on V9.2.0.
These changes were made for performance improvement, but it may also solve your issue.
Could you please try this version (at least for tests)
Hi,
I have try to update my version and now I can't connect to it.
This is my log file :
2021-06-20 21:30:48.458 ..... SCRIPT .... 172.21.2.33 =====/view/main.php
2021-06-20 21:30:48.542 ..... SCRIPT .... 172.21.2.33 Page=main.php
2021-06-20 21:30:48.543 ..... SCRIPT .... 172.21.2.33 refreshParameters()
2021-06-20 21:30:48.590 ..... SCRIPT .... 172.21.2.33 ->/view/login.php
2021-06-20 21:30:52.220 ..... SCRIPT .... 172.21.2.33 =====/tool/saveDataToSession.php
2021-06-20 21:30:52.264 ..... SCRIPT .... 172.21.2.33 Page=saveDataToSession.php
2021-06-20 21:30:52.265 ..... SCRIPT .... 172.21.2.33 refreshParameters()
2021-06-20 21:30:52.315 ..... SCRIPT .... 172.21.2.33 =====/tool/saveDataToSession.php
2021-06-20 21:30:52.360 ..... SCRIPT .... 172.21.2.33 Page=saveDataToSession.php
2021-06-20 21:30:52.361 ..... SCRIPT .... 172.21.2.33 refreshParameters()
2021-06-20 21:30:58.349 ..... SCRIPT .... 172.21.2.33 =====/tool/getHash.php
2021-06-20 21:30:58.391 ..... SCRIPT .... 172.21.2.33 Page=getHash.php
2021-06-20 21:30:58.393 ..... SCRIPT .... 172.21.2.33 refreshParameters()
2021-06-20 21:30:58.572 ..... SCRIPT .... 172.21.2.33 =====/tool/loginCheck.php
2021-06-20 21:30:58.616 ..... SCRIPT .... 172.21.2.33 Page=loginCheck.php
2021-06-20 21:30:58.617 ..... SCRIPT .... 172.21.2.33 refreshParameters()
2021-06-20 21:30:58.659 ..... SCRIPT .... 172.21.2.33 ->/tool/loginCheck.php
2021-06-20 21:30:58.662 ----- DEBUG ----- loginCheck : current db version = 'V9.1.5'
2021-06-20 21:30:58.667 ----- DEBUG ----- User->authenticate('ABARBIER', '6gG3m3KXz2DhE1GUglAu9+oeAQ==')
2021-06-20 21:30:58.669 ----- DEBUG ----- User->authenticate : LDAP authenticate
2021-06-20 21:30:58.676 ** ERROR ** [V9.1.5] ERROR **
2021-06-20 21:30:58.677 ** ERROR ** [V9.1.5] on file '/var/www/gestion-projet-it/projeqtor/model/UserMain.php' at line (1404)
2021-06-20 21:30:58.678 ** ERROR ***** [V9.1.5] cause = ldap_search(): Search: Operations error
Hi,
Please review the LDAP parameters in Global Parameter screen
Hi,
I have not the possibility to connect it.
How can I do that ?
If you did not keep an admin user account that can connect without ldap, you're strucked.
only solution is to update db, in table resource change isLdap to 0 for the admin.
Hi,
I have update my projeqtor application with the last version and I have ever the same problem about my imputation time.
I submit some hour on the same activity on each day. When I saved it I don't have my input. But I can see my plan time decrese with my input.
Do you have any solution to me ?
We do not reproduce issues on Timesheet.
Do you have any error in projeqtor log file ?
Do you have any error in apache error log file ?
Do you have any error in borwser console ?
Hi,
I have installed the last version of projeqtor (v9.2.2) and I have always the same problem.
So, I have check all my log file :
- Projeqtor log file : I have only this line :
2021-08-16 11:39:47.568 ** ERROR ** [V9.2.0] CRON abnormally stopped
- Apache error :
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/customIcons/new/iconMinus.svg HTTP/1.1" 200 1258
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/customIcons/grey/iconComment.png HTTP/1.1" 200 851
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/customIcons/new/iconAddComment.svg HTTP/1.1" 200 10397
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/customIcons/new/iconPlus.svg HTTP/1.1" 200 1479
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/customIcons/new/iconPeriodicMeeting.svg HTTP/1.1" 200 9727
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/images/comboArrowUp.gif HTTP/1.1" 200 343
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/images/minus.gif HTTP/1.1" 200 491
172.19.93.163 - - [16/Aug/2021:11:56:35 +0200] "GET /view/css/images/plus.gif HTTP/1.1" 200 496
172.19.93.163 - - [16/Aug/2021:11:56:44 +0200] "GET /tool/checkStatusChange.php?newReal=126.25&newLeft=149.75&idAssignment=5378 HTTP/1.1" 200 478
172.19.93.163 - - [16/Aug/2021:11:56:45 +0200] "GET /tool/checkStatusChange.php?newReal=129.25&newLeft=146.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:45 +0200] "GET /tool/checkStatusChange.php?newReal=132.25&newLeft=143.75&idAssignment=5378 HTTP/1.1" 200 478
172.19.93.163 - - [16/Aug/2021:11:56:45 +0200] "GET /tool/checkStatusChange.php?newReal=135.25&newLeft=140.75&idAssignment=5378 HTTP/1.1" 200 478
172.19.93.163 - - [16/Aug/2021:11:56:45 +0200] "GET /tool/checkStatusChange.php?newReal=168.25&newLeft=107.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:46 +0200] "GET /tool/checkStatusChange.php?newReal=171.25&newLeft=104.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:46 +0200] "GET /tool/checkStatusChange.php?newReal=174.25&newLeft=101.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:48 +0200] "GET /tool/checkStatusChange.php?newReal=144.25&newLeft=131.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:48 +0200] "GET /tool/checkStatusChange.php?newReal=144.25&newLeft=131.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:56:49 +0200] "POST /tool/saveImputation.php?destinationWidth=50&destinationHeight=0&isIE=&xhrPostDestination=resultDivMain&xhrPostIsResultMessage=true&xhrPostValidationType=&xhrPostTimestamp=1629107809324 HTTP/1.1" 200 513
172.19.93.163 - - [16/Aug/2021:11:56:56 +0200] "POST /view/imputationMain.php?destinationWidth=1918&destinationHeight=860&isIE=&xhrPostDestination=centerDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1629107816577 HTTP/1.1" 200 24276
172.19.93.163 - - [16/Aug/2021:11:56:56 +0200] "POST /view/menuUserScreenOrganization.php?currentScreen=Imputation&objectExist=false HTTP/1.1" 200 1444
172.19.93.163 - - [16/Aug/2021:11:56:56 +0200] "POST /view/refreshMenuBarButtonFavorite.php?item=Imputation&menuFilter=menuBarCustom HTTP/1.1" 200 871
172.19.93.163 - - [16/Aug/2021:11:57:11 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:11:57:12 +0200] "GET /external/pdfmake/pdfmake.min.js.map HTTP/1.1" 200 1498186
172.19.93.163 - - [16/Aug/2021:11:57:22 +0200] "GET /tool/checkStatusChange.php?newReal=13.5&newLeft=0&idAssignment=5272 HTTP/1.1" 200 478
172.19.93.163 - - [16/Aug/2021:11:57:24 +0200] "GET /tool/checkStatusChange.php?newReal=126.25&newLeft=128.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:25 +0200] "GET /tool/checkStatusChange.php?newReal=129.25&newLeft=125.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:25 +0200] "GET /tool/checkStatusChange.php?newReal=132.25&newLeft=122.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:25 +0200] "GET /tool/checkStatusChange.php?newReal=135.25&newLeft=119.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:26 +0200] "GET /tool/checkStatusChange.php?newReal=168.25&newLeft=86.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:27 +0200] "GET /tool/checkStatusChange.php?newReal=138.25&newLeft=116.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:57:27 +0200] "GET /tool/checkStatusChange.php?newReal=138.25&newLeft=116.75&idAssignment=5378 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:11:58:12 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:11:59:13 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:12:00:14 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 2241
172.19.93.163 - - [16/Aug/2021:12:00:44 +0200] "GET /tool/checkStatusChange.php?newReal=141.25&newLeft=113.75&idAssignment=5378 HTTP/1.1" 200 478
172.19.93.163 - - [16/Aug/2021:12:01:14 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:12:02:15 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:12:03:16 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 613
172.19.93.163 - - [16/Aug/2021:12:03:21 +0200] "POST /tool/saveImputation.php?destinationWidth=50&destinationHeight=0&isIE=&xhrPostDestination=resultDivMain&xhrPostIsResultMessage=true&xhrPostValidationType=&xhrPostTimestamp=1629108201010 HTTP/1.1" 200 513
172.19.93.163 - - [16/Aug/2021:12:04:03 +0200] "POST /view/refreshImputationList.php?destinationWidth=1918&destinationHeight=385&isIE=&xhrPostDestination=workDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1629108243139 HTTP/1.1" 200 20986
172.19.93.163 - - [16/Aug/2021:12:04:11 +0200] "POST /view/imputationMain.php?destinationWidth=1918&destinationHeight=422&isIE=&xhrPostDestination=centerDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1629108251933 HTTP/1.1" 200 24488
172.19.93.163 - - [16/Aug/2021:12:04:11 +0200] "POST /view/menuUserScreenOrganization.php?currentScreen=Imputation&objectExist=false HTTP/1.1" 200 1444
172.19.93.163 - - [16/Aug/2021:12:04:12 +0200] "POST /view/refreshMenuBarButtonFavorite.php?item=Imputation&menuFilter=menuBarCustom HTTP/1.1" 200 871
172.19.93.163 - - [16/Aug/2021:12:04:16 +0200] "GET /tool/checkAlertToDisplay.php HTTP/1.1" 200 460
172.19.93.163 - - [16/Aug/2021:12:04:19 +0200] "GET /tool/checkStatusChange.php?newReal=1&newLeft=0&idAssignment=5345 HTTP/1.1" 200 325
172.19.93.163 - - [16/Aug/2021:12:04:21 +0200] "POST /tool/saveImputation.php?destinationWidth=50&destinationHeight=0&isIE=&xhrPostDestination=resultDivMain&xhrPostIsResultMessage=true&xhrPostValidationType=&xhrPostTimestamp=1629108261173 HTTP/1.1" 200 513
172.19.93.163 - - [16/Aug/2021:12:04:25 +0200] "POST /view/refreshImputationList.php?destinationWidth=1918&destinationHeight=385&isIE=&xhrPostDestination=workDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1629108265033 HTTP/1.1" 200 21006
==> When I click on my save button on my screen, I have no error with apache.
- No error on my console of navigator.
I don't know what is my problem.
I search why the imputation didn't save in database. I do this test :
- I submit my imputation 1 on the first input field of the first project.
- I show my record in the table "work"
- I refresh my code and dosn't show my submit.
- I retape my imputation and I can show it in my screen after reload my page.
What kind of test I can do to find my problem ? Is it possible to have error on database ? or a php configuration?
I don't have this problem with php 7.1 but only with php 7.4
I have done an other try. If I update the script saveImputation.php with
$arrayWork[$j]=$work;
$arrayWork[$j]->work=0.14286;//$workValue;
(To put a default value of work. ( 1h / 7h by day))
At the first time the insert query add record on table work by the work column stay with 0 value (after a refresh page). I need to update a second time to have a good result (after a refresh page).