View ProjeQtOr On SourceForge.net
ProjeQtOr free project management software - [SOLVED] Error: Undefined variable: regulTh - ProjeQtOr
 

[SOLVED] Error: Undefined variable: regulTh

More
05 Jul 2020 10:30 #1 by hbarel
When calculating the plan, I get: (from log)
***** ERROR ***** [V8.5.1] cause = Undefined variable: regulTh (in line 844 of PlannedWork.php)
Seems as $regulTh is defined in line 833 which is within a condition that ($delaiTh and $delaiTh>0).
The topic has been locked.
More
05 Jul 2020 12:09 #2 by avris
It appears due to $regulTh is only conditionally assigned if workDayDiffDates() returns non-zero (to avoid division by zero).

Does it make sense to set $regulTh equal to $ass->leftWork if workDayDiffDates() returns 0?

Another issue that may/may not be related - we see in the log the following error:

xxxx-xx-xx --:--:--.--- ***** ERROR ***** [V8.5.1] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'

(xxxx-xx-xx --:--:00.--- is timestamp) - message is followed by a stack trace

It happens several times and started last couple of days ago.
The topic has been locked.
More
06 Jul 2020 12:58 #3 by Gautier
Hello,

ticket #4762 created.
It will be resolved in next corrective patch.
The topic has been locked.
More
14 Jul 2020 11:03 #4 by avris
Thank you.

I see the following in the log:

Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'

What is the reason, and could you please supply a workaround?

Thanks,
Avri
The topic has been locked.
More
15 Jul 2020 09:38 - 15 Jul 2020 09:39 #5 by babynus
Hi,

It is just that de collation could not be determinated correctly.
Add line in parameters.php :
$paramDbCollation='utf8';

Babynus
Administrator of ProjeQtOr web site
Last edit: 15 Jul 2020 09:39 by babynus.
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.040 seconds