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
when i try to save real work on somes projects a have error, it's seems link to user or project.
log
12-02-23 10:34:44 ===== TRACE ===== NEW CONNECTED USER 'WWWWW' 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:34:57 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-02-23 10:35:32 ** ERROR ** ERROR ** 2012-02-23 10:35:32 ** ERROR ** on file '/var/www/projectorria/tool/saveImputation.php' at line (15) 2012-02-23 10:35:32 ** ERROR ***** cause = Undefined index: nbLines 2
Your issues (I identified 2 in your log) are strange.
It looks like you're using V1.9 Database with V2.0 code.
If you updated to V2.0, you must disconnect and reconnect as admin to update the database.
If you did so, you should try to upgrade again : update table parameter, line with parameterCode="dbVersion", set parametertValue="1.9.1".
Then disconnect and reconnect.
Check log file and send me any error.
Try real work allocation screen, check log file and send me any error.
Regards.
hi babynus,
i change version in parameter Table, and a have 37 errors during upgrade.
and i have already the errors.
2012-03-03 20:54:29 ===== TRACE ===== ===================================== 2012-03-03 20:54:29 ===== TRACE ===== 2012-03-03 20:54:29 ===== TRACE ===== 37 ERRORS DURING UPDATE TO VERSION V2.0.1 2012-03-03 20:54:29 ===== TRACE ===== 2012-03-03 20:54:29 ===== TRACE ===== ===================================== 2012-03-03 20:54:29 ===== TRACE ===== 2012-03-03 20:54:41 ===== TRACE ===== NEW CONNECTED USER 'admin' 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:22 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-03 20:56:36 ** ERROR ** ERROR ** 2012-03-03 20:56:36 ** ERROR ** on file '/var/www/projectorria/tool/saveImputation.php' at line (15) 2012-03-03 20:56:36 ** ERROR ***** cause = Undefined index: nbLines
Can you have a test :
- Download the file here : http://projectorria.toolware.fr/files/temp/ImputationLine.php.txt
- Rename it as ImputationLine.php (without .txt)
- Paste it in /model directory (replacing existing)
- Test again
- Get log file errors.
- Post result here
Thanks.
hi babynus
this problem occurs only for somes guys, i notice also a problem on retreive imputation on past week, i need change parameter on daily imputation for retreive correct display.
this i the log with your file :
2012-03-04 16:16:29 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:16:42 ** ERROR ** ERROR ** 2012-03-04 16:16:42 ** ERROR ** on file '/var/www/projectorria/tool/saveImputation.php' at line (28) 2012-03-04 16:16:42 ** ERROR ** cause = Undefined index: leftWork_39 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database. 2012-03-04 16:17:17 ** ERROR ***** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database.
best regards
hi
i notive than all errors :
2012-03-04 16:25:58 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database.
came during screen building, before begin enter of value.
it's perhaps cause of validation error.
Best regards
This logged error is not linked to validation isssue : I had these logs without any validation error.
(these log isses are fixed in V2.1)
hi babynus
your special file add this log :
2012-03-04 16:16:42 ** ERROR ** cause = Undefined index: leftWork_39
best regards
OK,
So now I'm pretty sure : your request is truncated.
Have a look at your apache configuration :
maxParameterCount
maxPostSize
To be sure you may first set these value to 0 (zero = no limit), then try to set best value.
Regards
hi Babynus
i change MaxPostSize in php.ini to 19M, and i have always same errors.
i control this parameter in /test/info.php, and it's ok.
Best regards
Do you mean post_max_size in PHP.ini ?
I guess the issue is not from php config : you would have a PHP error, clearly logged in log file.
You must look for maxPostSize in httpd.conf, the apache config file.
hi babynus
a need add in PHP.ini :
max_input_vars = 2000 ; Disponible depuis PHP 5.3.9. default 1000
now it's working fine.
Great !
In addition, I added some improvement in V2.1 to reduce number of posted values for this form.
I came from 927 values down to 419 values...
This should avoid to reproduce the issue for other users migrating to PHP V5.3.9.
hi Babynus,
i found somes informations on set/get php parameters during execution of application :
perhaps you can implement a check/set of this var ?
regards
Good !
Included in V2.1.