View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - V9.0 - screen blocked when choosing to activate the new design - ProjeQtOr
 
 

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

More
24 Dec 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 Log in or Create an account to join the conversation.

More
24 Dec 2020 10:08 - 24 Dec 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 Dec 2020 10:09 by babynus.

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

More
24 Dec 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 Log in or Create an account to join the conversation.

More
24 Dec 2020 12:29 - 24 Dec 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).")";
to
   $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'))";
to
  $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 Dec 2020 12:29 by babynus.
The following user(s) said Thank You: sa

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

More
24 Dec 2020 14:51 - 24 Dec 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 Dec 2020 14:52 by sa.

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

More
27 Dec 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 Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.046 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