ProjeQtOr free project management software - Planning data not displayed - ProjeQtOr
 

Planning data not displayed

More
11 Mai 2020 16:25 #1 by CAE38
Hello,

There is no data anymore displayed in the columns id, start date, end date....in all plannings (Planning, Global Planning, Planning by resource). I've created a simulation environment to check if there is the same error and it works fine in this new environment.

Very strange!!!! The Gantt planning report is still working.
Can you help me to fix this issue ?

Thank you.
Attached the screenshots.

Please Connexion or Create an account to join the conversation.

More
11 Mai 2020 16:30 #2 by babynus
Replied by babynus on topic Planning data not displayed
do you have any error in log file or in browser console ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
11 Mai 2020 16:33 #3 by CAE38
Replied by CAE38 on topic Planning data not displayed
I had this error this morning :

2020-05-11 11:14:17.290 ***** ERROR ***** [V8.4.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ( endDate >= '' OR endDate IS NULL )' at line 1
2020-05-11 11:14:17.290 ***** ERROR ***** [V8.4.4] For query : select * from affectation where idle=0 AND idProject= AND ( endDate >= '' OR endDate IS NULL )
2020-05-11 11:14:17.290 ***** ERROR ***** [V8.4.4] Strack trace :
2020-05-11 11:14:17.290 ***** ERROR ***** [V8.4.4] #0 Sql->query called at [/opt/lampp/htdocs/projeqtor/model/persistence/SqlElement.php:2539]
2020-05-11 11:14:17.290 ***** ERROR ***** [V8.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/projeqtor/tool/assignTeamForMeeting.php:56]

But no other error since this morning.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.027 seconds