Posted on: 11/29/05 05:45pm
By: Anonymous (Ikkedendikke)
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
Oops
Posted on: 11/29/05 05:47pm
By: Anonymous (Ikkedendikke)
Sorry for dropping this in the wrong place.