Posted on: 12/18/05 10:17pm
By: LewisR
Here's a good one:
GL 1.40b1
Apache 2.0.52 on OS/2 Warp Server for eBusiness
PHP 4.3.10 on OS/2 (Apache module)
MySQL 4.1.8 on NetWare 6.0 SP5
Admin user may access the Events link from the Admins Only list. However, after creating an Event Admin as member of Users, Logged-in Users, and Event Admin, and logging in under that ID, attempting to access the same link yields the following in the GL error.log:
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 = '5') AND (perm_owner >= 2)) OR ((group_id IN. 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 = '5') AND (perm_owner >= 2)) OR ((group_id IN (2,7,13)) AND (perm_group >= 2)) OR (perm_members >= 2)) ORDER BY datestart desc LIMIT 0,50;
Am I missing something? More privs neeed for the Event Admin?
TIA
SQL error accessing Events (Admin Only) by Event Admin
Posted on: 12/19/05 02:18pm
By: Dirk
That's a known bug in the beta, fixed in CVS.
bye, Dirk
SQL error accessing Events (Admin Only) by Event Admin
Posted on: 12/20/05 10:32am
By: LewisR
Thanks, Dirk!