Jump to content


Photo

Problem with groups hierarchy

groups hierarchy bug sql

  • Please log in to reply
5 replies to this topic

#1 ecvaldas

ecvaldas

    Member

  • Members
  • PipPip
  • 18 posts

Posted 04 September 2013 - 02:24 PM

When I build a group hierarchy, for example: 

MANAGER -> SALES MANAGER -> SALES 

and add a freshly created user account to SALES, user gets SQL error  after trying to access any page:

"An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.

SQLSTATE[HY000]: General error: 1456 Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine get_group_inherited_actual_right_ignoring_everyone"

 

I am on hosted machine.

 

Anyone has any ideas? 

 



#2 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 04 September 2013 - 05:50 PM

What version of Zurmo are you using? Can you replicate on the Live Demo: http://demo.zurmo.co...o/default/login


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro


#3 ecvaldas

ecvaldas

    Member

  • Members
  • PipPip
  • 18 posts

Posted 04 September 2013 - 06:11 PM

What version of Zurmo are you using? Can you replicate on the Live Demo: http://demo.zurmo.co...o/default/login

 

Hello,

I'm running the latest one 2.2.0 on PHP 5.4.

It does not happen on the Live Demo :/ 



#4 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 04 September 2013 - 06:17 PM

Hello,

I'm running the latest one 2.2.0 on PHP 5.4.

It does not happen on the Live Demo :/ 

It looks like a database issue with your hosting provider. That is really all i can tell. If you want to test further, you can do a 30 day trial here: http://zurmo.com/free-trial


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro


#5 ecvaldas

ecvaldas

    Member

  • Members
  • PipPip
  • 18 posts

Posted 04 September 2013 - 06:55 PM

Ok, sent them an email, if they will find the issue I will post here so it might be useful to other users. 

 

Thank you



#6 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 04 September 2013 - 07:33 PM

Great thank you.


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro






Also tagged with one or more of these keywords: groups, hierarchy, bug, sql

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users