Welcome to Geeklog, Anonymous Friday, September 29 2023 @ 12:49 am EDT

Geeklog Forums

SQL bug for newly created users with many rights



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,1Cool) 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!




Sorry for dropping this in the wrong place.

All times are EDT. The time is now 12:49 am.

  • 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