Forum

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.

Error when save Rea...
 
Notifications
Clear all

Error when save RealWorkAllocation

16 Posts
2 Users
0 Reactions
14.7 K Views
(@spiderjn)
Posts: 35
Active Member
Topic starter
 
[#378]

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

 
Posted : 23 Feb 2012 21H50
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 25 Feb 2012 16H42
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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

 
Posted : 03 Mar 2012 23H01
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 04 Mar 2012 15H53
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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


 
Posted : 04 Mar 2012 18H26
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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


 
Posted : 04 Mar 2012 18H33
(@babynus)
Posts: 14952
Member Admin
 

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)


 
Posted : 04 Mar 2012 18H56
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

hi babynus

your special file add this log :

2012-03-04 16:16:42 ** ERROR ** cause = Undefined index: leftWork_39

best regards


 
Posted : 05 Mar 2012 14H22
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 05 Mar 2012 15H21
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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


 
Posted : 05 Mar 2012 17H28
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 05 Mar 2012 18H07
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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.


 
Posted : 05 Mar 2012 20H45
(@babynus)
Posts: 14952
Member Admin
 

Great !


 
Posted : 05 Mar 2012 20H55
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 09 Mar 2012 16H51
(@spiderjn)
Posts: 35
Active Member
Topic starter
 

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


 
Posted : 09 Mar 2012 23H21
(@babynus)
Posts: 14952
Member Admin
 

Good !

Included in V2.1.


 
Posted : 11 Mar 2012 3H36
Share:

Scroll to Top