V9.0 - screen blocked when choosing to activate the new design

Début
Précédent
1
2
Suivant
Fin

sa
Topic Author
Offline
Junior Member

24 Déc 2020 10:01 #1 by sa

V9.0 - screen blocked when choosing to activate the new design was created by sa

Hello

After connection with a 'project manager' profile

I choose to activate the new design; the screen hangs with the message "loading"
the logs are:
2020-12-24 09:37:29.874 ***** ERROR ***** [V9.0.0] ERROR *****
2020-12-24 09:37:29.874 ***** ERROR ***** [V9.0.0] on file 'C:\wamp64\www\projectbox\view\menuNewGuiLeft.php' at line (208)
2020-12-24 09:37:29.874 ***** ERROR ***** [V9.0.0] cause = Undefined variable: allowedCategory

Best regards

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

24 Déc 2020 10:08 - 24 Déc 2020 10:09 #2 by babynus

Replied by babynus on topic V9.0 - screen blocked when choosing to activate the new design

Hi,

This issue identified as Ticket #5131
To fix it, add 1 line after line 19+0 in projeqtor/view/menuNewGuiLeft.php

function sortMenus(&$listMenus, &$result, $parent,$level,$rightPluginAcces=false ){
  $level++;
  $hr=new HabilitationReport();
  $user=getSessionUser();
  $lst=$hr->getSqlElementsFromCriteria(array('idProfile'=>$user->idProfile, 'allowAccess'=>'1'), false);
  $allowedCategory=array();
  foreach ($lst as $h) {

Babynus
Administrator of ProjeQtOr web site

Last edit: 24 Déc 2020 10:09 by babynus.

Please Connexion or Create an account to join the conversation.

sa
Topic Author
Offline
Junior Member

24 Déc 2020 10:21 #3 by sa

Replied by sa on topic V9.0 - screen blocked when choosing to activate the new design

Well done

However I have other message after adding the line.

2020-12-24 10:00:40.075 ***** ERROR ***** [V9.0.0] ERROR *****
2020-12-24 10:00:40.075 ***** ERROR ***** [V9.0.0] on file 'C:\wamp64\www\projectbox\view\menuNewGuiLeft.php' at line (208)
2020-12-24 10:00:40.075 ***** ERROR ***** [V9.0.0] cause = Undefined variable: allowedCategory
2020-12-24 10:07:26.623 ***** ERROR ***** [V9.0.0] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de ') and (level not in ('','Project')) order by menu.sortOrder' à la ligne 1
2020-12-24 10:07:26.623 ***** ERROR ***** [V9.0.0] For query : select * from menu where name in () and (level not in ('','Project')) order by menu.sortOrder
2020-12-24 10:07:26.623 ***** ERROR ***** [V9.0.0] Strack trace :
2020-12-24 10:07:26.623 ***** ERROR ***** [V9.0.0] #0 Sql->query called at [C:\wamp64\www\projectbox\model\persistence\SqlElement.php:2678]
2020-12-24 10:07:26.624 ***** ERROR ***** [V9.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\wamp64\www\projectbox\tool\drawBottomParameterMenu.php:61]
2020-12-24 10:12:27.291 ***** ERROR ***** [V9.0.0] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de ') order by file' à la ligne 1
2020-12-24 10:12:27.291 ***** ERROR ***** [V9.0.0] For query : select * from report where idReportCategory in () order by file
2020-12-24 10:12:27.291 ***** ERROR ***** [V9.0.0] Strack trace :
2020-12-24 10:12:27.291 ***** ERROR ***** [V9.0.0] #0 Sql->query called at [C:\wamp64\www\projectbox\model\persistence\SqlElement.php:2678]
2020-12-24 10:12:27.292 ***** ERROR ***** [V9.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:\wamp64\www\projectbox\view\menuNewGuiLeft.php:293]
2020-12-24 10:12:27.292 ***** ERROR ***** [V9.0.0] #2 getReportsMenu called at [C:\wamp64\www\projectbox\view\menuNewGuiLeft.php:452]
2020-12-24 10:12:27.292 ***** ERROR ***** [V9.0.0] #3 getNavigationMenuLeft called at [C:\wamp64\www\projectbox\view\menuNewGuiLeft.php:463]
2020-12-24 10:12:27.292 ***** ERROR ***** [V9.0.0] #4 drawLeftMenuListNewGui called at [C:\wamp64\www\projectbox\view\menuNewGuiLeft.php:60]
2020-12-24 10:12:27.292 ***** ERROR ***** [V9.0.0] #5 include called at [C:\wamp64\www\projectbox\view\main.php:1297]
2020-12-24 10:13:27.501 ***** ERROR ***** [V9.0.0] HACK ================================================================
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] Try to hack detected
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] Source Code = checkValidAccessForUser() Reject for User - no access to screen 'User'
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] QUERY_STRING = objectClass=User&objectType=&objectClient=&budgetParent=&objectElementable=
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] REMOTE_ADDR = 172.25.101.1
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] SCRIPT_FILENAME = C:/wamp64/www/projectbox/tool/jsonQuery.php
2020-12-24 10:13:27.502 ***** ERROR ***** [V9.0.0] REQUEST_URI = /projectbox/tool/jsonQuery.php?objectClass=User&objectType=&objectClient=&budgetParent=&objectElementable=
2020-12-24 10:13:27.898 ===== TRACE ===== NEW CONNECTED USER 'XXXX' (using remember me feature)
2020-12-24 10:13:30.530 ***** ERROR ***** [V9.0.0] HACK ================================================================
2020-12-24 10:13:30.530 ***** ERROR ***** [V9.0.0] Try to hack detected
2020-12-24 10:13:30.530 ***** ERROR ***** [V9.0.0] Source Code = checkValidAccessForUser() Reject for User - no access to screen 'User'
2020-12-24 10:13:30.530 ***** ERROR ***** [V9.0.0] QUERY_STRING = objectClass=User&objectType=&objectClient=&budgetParent=&objectElementable=
2020-12-24 10:13:30.531 ***** ERROR ***** [V9.0.0] REMOTE_ADDR = 172.25.101.1
2020-12-24 10:13:30.531 ***** ERROR ***** [V9.0.0] SCRIPT_FILENAME = C:/wamp64/www/projectbox/tool/jsonQuery.php
2020-12-24 10:13:30.531 ***** ERROR ***** [V9.0.0] REQUEST_URI = /projectbox/tool/jsonQuery.php?objectClass=User&objectType=&objectClient=&budgetParent=&objectElementable=
2020-12-24 10:13:30.950 ===== TRACE ===== NEW CONNECTED USER 'XXXX' (using remember me feature)

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

24 Déc 2020 12:29 - 24 Déc 2020 12:29 #4 by babynus

Replied by babynus on topic V9.0 - screen blocked when choosing to activate the new design

2 errors in your logs.

in projeqtor/view/menuNewGuiLeft.php, replace line 292 from

   $where=" idReportCategory in (".implode(",", $lstIdCate).")";

   $where=" idReportCategory in (0,".implode(",", $lstIdCate).")";

in projeqtor/tool/drawBottomParameterMenu.php, add 1 line after line 59, from

  $sortMenu=array_flip($sortMenu);
  $clause="name in ($lstString) and (level not in ('','Project'))";

  $sortMenu=array_flip($sortMenu);
  if (! $lstString) $lstString="''";
  $clause="name in ($lstString) and (level not in ('','Project'))";

Thanks for reporting the issues

Babynus
Administrator of ProjeQtOr web site

Last edit: 24 Déc 2020 12:29 by babynus.

The following user(s) said Thank You: sa

Please Connexion or Create an account to join the conversation.

sa
Topic Author
Offline
Junior Member

24 Déc 2020 14:51 - 24 Déc 2020 14:52 #5 by sa

Replied by sa on topic V9.0 - screen blocked when choosing to activate the new design

Thank you
it seems to be ok.

Last edit: 24 Déc 2020 14:52 by sa.

Please Connexion or Create an account to join the conversation.

alfredo237
Offline
New Member

27 Déc 2020 21:02 #6 by alfredo237

Replied by alfredo237 on topic V9.0 - screen blocked when choosing to activate the new design

Hello
After connection with a 'project manager' profile I choose to activate the new design
by clicking on the activate button.
I made the two code changes suggested above, but unfortunately they didn't work.

Please Connexion or Create an account to join the conversation.

Début
Précédent
1
2
Suivant
Fin

Moderators: babynus, protion

Time to create page: 0.048 seconds

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

V9.0 - screen blocked when choosing to activate the new design

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

V9.0 - screen blocked when choosing to activate the new design

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form