Forum

V9.0 - screen block...
 
Notifications
Retirer tout

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

7 Posts
3 Utilisateurs
0 Reactions
5,509 Vu
 sa
(@_sa_)
Posts: 39
Trusted Member
Début du sujet
 
[#7111]

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


 
Posté : 24/12/2020 12:01 pm
(@babynus)
Posts: 14952
Membre Admin
 

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) {

 
Posté : 24/12/2020 12:08 pm
 sa
(@_sa_)
Posts: 39
Trusted Member
Début du sujet
 

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)


 
Posté : 24/12/2020 12:21 pm
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 24/12/2020 2:29 pm
 sa
(@_sa_)
Posts: 39
Trusted Member
Début du sujet
 

Thank you
it seems to be ok.


 
Posté : 24/12/2020 4:51 pm
(@alfredo237)
Posts: 1
New Member
 

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.


 
Posté : 27/12/2020 11:02 pm
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 28/12/2020 12:35 pm
Share:
Retour en haut