Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.
ISSUE SUMMARY: When delete Event, Group, User or whatever my site get this error: error 1064 SQL syntax and no one can login.
STEPS TO REPLICATE:
1: Greate user and delete. Whole site goes down.
2: Restoring from backup works.
3
4
5
RESULT
1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) OR ( a.`permission` = '0' AND a.`contentid` > '0' AND c.`approvals` = '0') O' at line 1 SQL=SELECT a.* FROM `#__community_events` AS a INNER JOIN `#__community_events_category` AS b ON a.`catid` = b.`id` LEFT JOIN `#__community_groups` AS c ON a.`contentid` = c.`id` WHERE a.`published` = '1' AND ( ( a.`permission` = '0' AND a.`contentid` = '0') OR ( a.`permission` = '1' AND a.`id` IN ()) OR ( a.`permission` = '0' AND a.`contentid` > '0' AND c.`approvals` = '0') OR ( a.`contentid` > '0' AND c.`approvals` = '1' AND c.`id` IN (1,2,3,5,6)) ) AND a.`enddate` > DATE(NOW()) ORDER BY a.`id` DESC LIMIT 0, 1
It appears that the page you were looking for does not exist.
Other things to try
Go back home
If you came here by mistake, try going back to home page.