Usergroup error

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
michaelthomsen
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Tue Mar 07, 2006 6:12 am

Usergroup error

Post by michaelthomsen » Tue Jan 22, 2013 2:05 pm

Hi, everything was going great until I started getting a 500 mysql error:

SQL=SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level FROM `hfym_usergroups` AS a LEFT JOIN `hfym_usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt GROUP BY a.id, a.title, a.lft, a.rgt ORDER BY a.lft ASC

Warning: Invalid argument supplied for foreach() in /public_html/libraries/joomla/html/select.php on line 504

Can't edit users or groups, or anything in the control panel.

Any suggestions of how to fix the SQL, I don't understand what it means.
thank you
Top
michaelthomsen
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Tue Mar 07, 2006 6:12 am

Re: Usergroup error

Post by michaelthomsen » Tue Jan 22, 2013 9:47 pm

weird, this morning the error is gone. I did uninstall 2 registered users which seem to have come from the installation from joomlart, don't know if this was the problem.
Top
Locked

Return to “Administration Joomla! 3.x”