Geeklog Forums

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

---

Lewis Rosenthal, CNA, CLP, CLE
Rosenthal & Rosenthal, LLC

That's a known bug in the beta, fixed in CVS.

bye, Dirk

Thanks, Dirk!

---

Lewis Rosenthal, CNA, CLP, CLE
Rosenthal & Rosenthal, LLC