Geeklog Forums

Hello,

I encountered a bug when creating a new users and making him Admin on several items (like Article Admin, Block Admin, ...).
When clicking on Events (in the Admin section) I get the following error:

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 'WHERE (((owner_id = '3') AND (perm_owner >= 2)) OR ((group_id I. SQL in question: SELECT gl_events.*, gl_users.username FROM gl_events LEFT JOIN gl_users ON gl_events.owner_id=gl_users.uid WHERE 1 AND WHERE (((owner_id = '3') AND (perm_owner >= 2)) OR ((group_id IN (2,7,5,13,12,8,14,3,6,9,20,1) AND (perm_group >= 2)) OR (perm_members >= 2)) ORDER BY datestart desc LIMIT 0,50;

Hope it helps in the further development of this magnificent tool!

Ciao,

Stijn

Sorry for dropping this in the wrong place.