Joomla Templates Club 406,261 posts

[ecohaven Friend ecohavenJoin date: July 2007Posts: 56Downloads:0Uploads:8 Thanks: 8 Thanked: 8 times in 1 posts]

#184266

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.

I uninstalled K2 and acymailing, not sure if that caused the problem…
thank you

[ecohaven Friend ecohavenJoin date: July 2007Posts: 56Downloads:0Uploads:8 Thanks: 8 Thanked: 8 times in 1 posts]

#480811

I don’t understand, but this morning, the error is gone. I did delete in the sq, 2 registered users which somehow seem to have been included in the installation? I can’t remember their emails but it was xx.joom.com ??

1 user says Thank You to ecohaven for this useful post

1. JA Developer

[Author]

Posts