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:wamp64wwwprojectboxviewmenuNewGuiLeft.php' at line (208)
2020-12-24 09:37:29.874 ** ERROR ***** [V9.0.0] cause = Undefined variable: allowedCategory
Best regards
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) {
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:wamp64wwwprojectboxviewmenuNewGuiLeft.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:wamp64wwwprojectboxmodelpersistenceSqlElement.php:2678]
2020-12-24 10:07:26.624 ** ERROR ** [V9.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:wamp64wwwprojectboxtooldrawBottomParameterMenu.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:wamp64wwwprojectboxmodelpersistenceSqlElement.php:2678]
2020-12-24 10:12:27.292 ** ERROR ** [V9.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [C:wamp64wwwprojectboxviewmenuNewGuiLeft.php:293]
2020-12-24 10:12:27.292 ** ERROR ** [V9.0.0] #2 getReportsMenu called at [C:wamp64wwwprojectboxviewmenuNewGuiLeft.php:452]
2020-12-24 10:12:27.292 ** ERROR ** [V9.0.0] #3 getNavigationMenuLeft called at [C:wamp64wwwprojectboxviewmenuNewGuiLeft.php:463]
2020-12-24 10:12:27.292 ** ERROR ** [V9.0.0] #4 drawLeftMenuListNewGui called at [C:wamp64wwwprojectboxviewmenuNewGuiLeft.php:60]
2020-12-24 10:12:27.292 ** ERROR ** [V9.0.0] #5 include called at [C:wamp64wwwprojectboxviewmain.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)
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
Thank you
it seems to be ok.
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.
There is another issue, check gfor your logs and look in the forum.
Fixes are proposed.
We'll soon deploy a patch version including all the fixes.