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.

[SOLVED] Error: Und...
 
Notifications
Clear all

[SOLVED] Error: Undefined variable: regulTh

5 Posts
4 Users
0 Reactions
2,933 Views
(@hbarel)
Posts: 3
Active Member
Topic starter
 
[#6800]

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).


 
Posted : 05 Jul 2020 12H30
(@avris)
Posts: 8
Active Member
 

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.


 
Posted : 05 Jul 2020 14H09
Gautier
(@gautier)
Posts: 207
Active Member Admin Registered
 

Hello,

ticket #4762 created.
It will be resolved in next corrective patch.


 
Posted : 06 Jul 2020 14H58
(@avris)
Posts: 8
Active Member
 

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


 
Posted : 14 Jul 2020 13H03
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

It is just that de collation could not be determinated correctly.
Add line in parameters.php :

$paramDbCollation='utf8';

 
Posted : 15 Jul 2020 11H38
Share:

Scroll to Top