Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 10:03 am EDT

Geeklog Forums

SQL bug for newly created users with many rights


Ikkedendikke

Anonymous
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,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!

Ciao,

Stijn
 Quote

Ikkedendikke

Anonymous
confused
Sorry for dropping this in the wrong place.
 Quote

All times are EDT. The time is now 10:03 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