ProjeQtOr free project management software - Error when saving Timesheet - ProjeQtOr
 

Error when saving Timesheet

More
01 Mar 2019 21:56 #1 by karl.binet
Hi,

V7.4.2

On monday, february 25, a user entered time into is Timesheet and when he saved, received an error



Look at the log file and saw this error

2019-02-25 09:44:12.612 ===== TRACE ===== WARNING - Left work not retrieved from screen
2019-02-25 09:44:12.612 ===== TRACE ===== - Maybe max_input_vars is too small in php.ini (actual value is 4000)
2019-02-25 09:44:12.612 ***** ERROR ***** [V7.4.2] ERROR *****
2019-02-25 09:44:12.612 ***** ERROR ***** [V7.4.2] on file '/var/www/html/tool/saveImputation.php' at line (40)
2019-02-25 09:44:12.612 ***** ERROR ***** [V7.4.2] cause = Error - Maybe max_input_vars is too small in php.ini

so I went and change the value of max_input_vars to 5000, after changing this value, the issue was solved and the user is able to save is timesheet after entering is time.

But again, today, same error

2019-03-01 15:13:36.295 ===== TRACE ===== WARNING - Left work not retrieved from screen
2019-03-01 15:13:36.295 ===== TRACE ===== - Maybe max_input_vars is too small in php.ini (actual value is 5000)
2019-03-01 15:13:36.295 ***** ERROR ***** [V7.4.2] ERROR *****
2019-03-01 15:13:36.295 ***** ERROR ***** [V7.4.2] on file '/var/www/html/tool/saveImputation.php' at line (40)
2019-03-01 15:13:36.295 ***** ERROR ***** [V7.4.2] cause = Error - Maybe max_input_vars is too small in php.ini

So my questions, do i just raise the max_input_var again to an higher value or the problem comes from somewhere else.

Note that it is not all users that cannot save there time.
Note that the user who cannot save is time has a lot of activity assigned to him

Also found out that after raising the php max_input_vars to 5000, it created another issue with screen customization plugin.

2019-03-01 14:43:26.857 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2019-03-01 14:43:26.857 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2019-03-01 14:43:26.857 ===== TRACE ===== - Projet
2019-03-01 14:43:26.859 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2019-03-01 14:44:40.145 ===== TRACE ===== =====================================
2019-03-01 14:44:40.145 ===== TRACE =====
2019-03-01 14:44:40.145 ===== TRACE ===== PLUGIN SQL FILE : ../plugin/screenCustomization/temp.sql
2019-03-01 14:44:40.145 ===== TRACE =====
2019-03-01 14:44:40.334 ===== TRACE ===== Table "project" altered.
2019-03-01 14:44:40.334 ===== TRACE =====
2019-03-01 14:44:40.334 ===== TRACE ===== DATABASE UPDATED
2019-03-01 14:44:40.334 ===== TRACE ===== WITH NO ERROR
2019-03-01 14:44:40.334 ===== TRACE =====
2019-03-01 14:44:40.529 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2019-03-01 14:44:40.529 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2019-03-01 14:44:40.529 ===== TRACE ===== - Projet
2019-03-01 14:44:40.530 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2019-03-01 14:50:17.278 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2019-03-01 14:50:17.278 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2019-03-01 14:50:17.278 ===== TRACE ===== - Projet
2019-03-01 14:50:17.280 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2019-03-01 14:50:44.526 ***** ERROR ***** [V7.4.2] '' is not a valid length for a 'varchar'.
Value must be numeric and <=4000


I have attach log file for february 25 and today, march 1.

Regars
Attachments:

Please Connexion or Create an account to join the conversation.

More
04 Mar 2019 18:21 #2 by babynus
Replied by babynus on topic Error when saving Timesheet
This issue occurs when user have many (several dozens and possibly hundreds) on lines in Timesheet.
You must ask yourself if it is normal : in my opinion, user with hundreds of lines will loose much time to identify the expected line.
So possibly :
- ended activities are not closed (think about closing old tasks)
- users should consider using display options (checkbnoxes on top of screen) to restrcit number of lines.
- possibly activities are too small (so too numerous) : don't forget is is project management, not production management

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.082 seconds