View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - V8.6.1 No display in Global Planning - Page 2 - ProjeQtOr
 
 

V8.6.1 No display in Global Planning

More
28 Dec 2020 16:51 - 28 Dec 2020 16:52 #7 by rainbow
Replied by rainbow on topic V8.6.1 No display in Global Planning
I changed the add line to
$paramDbCollation='latin1';
yet still no item is displayed.

I also tried to add a new activity in the menu, yet the issue still persists.



It seems like the collation is not recognised. I extracted parts of the error codes below and attached full error log.
2020-12-28 23:24:58.053 ***** ERROR ***** [V8.6.1]    Strack trace :
2020-12-28 23:24:58.056 ***** ERROR ***** [V8.6.1]    #0 Sql->query called at [C:\Users\Rainbow\Downloads\Wnmp\html\projeqtor\tool\jsonPlanning.php:286]
2020-12-28 23:24:58.058 ***** ERROR ***** [V8.6.1]    #1 include called at [C:\Users\Rainbow\Downloads\Wnmp\html\projeqtor\view\globalPlanningList.php:534]
2020-12-28 23:24:58.061 ***** ERROR ***** [V8.6.1]    #2 include called at [C:\Users\Rainbow\Downloads\Wnmp\html\projeqtor\view\globalPlanningMain.php:79]
2020-12-28 23:25:02.369 ***** ERROR ***** [V8.6.1] Exception-[HY000] SQLSTATE[HY000]: General error: 1273 Unknown collation: 'latin1'
2020-12-28 23:25:02.372 ***** ERROR ***** [V8.6.1]    For query : SELECT planningelement.*

File Attachment:

File Name: projeqtor_...2-28.log
File Size:642 KB


Will the different version switching has any impact on the database such that changing to an older version will cause such impact?
Before such error, in V8.5.1 there is no such error. After I updated to V9.0.0, I encountered some issues, which I then tried to change to an older version V8.6.6, yet no display in global planning. I then tried to change to V8.6.1, yet the issue still persists.

Thanks!
Attachments:
Last edit: 28 Dec 2020 16:52 by rainbow.

Please Log in or Create an account to join the conversation.

More
28 Dec 2020 17:47 #8 by babynus
Replied by babynus on topic V8.6.1 No display in Global Planning
Hi,

Possibly the source comes from your migration process.
You installed a new DB which does not use that same collation as the previous one.
Migrating from DB that has no issue will not introduce any issue.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
08 Jan 2021 11:15 #9 by rainbow
Replied by rainbow on topic V8.6.1 No display in Global Planning
Hi Babynus,

Thanks for your reply. I tried to use a new database that works at v8.5.5 and update to v8.6.6 but still didn't work. 

I found out that the parameter script (as below) in V8.6.6 is missing after upgrade from v8.5.5 to v8.6.6. I suspect in the version update script, scripts on the parameter update are missing.

$enforceUTF8='1'; 

After adding the script above, the global planning display works. I suspect updating the version update script for UTF8 settings would prevent similar cases in the future version updates. Hope it helps others who face the same issue!

Thanks,
Rainbow

Please Log in or Create an account to join the conversation.

More
23 Sep 2021 13:40 #10 by K.KOUASSI
Replied by K.KOUASSI on topic V8.6.1 No display in Global Planning
where i execute the command
$enforceUTF8='1';

Please Log in or Create an account to join the conversation.

More
23 Sep 2021 14:09 #11 by babynus
Replied by babynus on topic V8.6.1 No display in Global Planning

K.KOUASSI post=31254 wrote: where i execute the command
$enforceUTF8='1';

We won't reply to questions you add on an existing thread and that not relative to this tread. Please open new thread / subjet.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.052 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form