Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 04:59 pm EDT

Geeklog Forums

SQL error accessing Events (Admin Only) by Event Admin


Status: offline

LewisR

Forum User
Junior
Registered: 06/30/03
Posts: 29
worried
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That's a known bug in the beta, fixed in CVS.

bye, Dirk
 Quote

Status: offline

LewisR

Forum User
Junior
Registered: 06/30/03
Posts: 29
Thanks, Dirk!
Lewis Rosenthal, CNA, CLP, CLE
Rosenthal & Rosenthal, LLC
 Quote

All times are EDT. The time is now 04:59 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content