Error in /sections/staff/functions.php
Closed this issue · 2 comments
lun4r commented
MySQL error when opening staff.php after last /sections/staff/functions.php update.
MySQL: Invalid Query:
SELECT
m.ID,
p.Level,
m.Username,
m.Paranoia,
m.LastAccess,
i.SupportFor
FROM users_main AS m
JOIN users_info AS i ON m.ID = i.UserID
JOIN permissions AS p ON p.ID = m.PermissionID
WHERE p.DisplayStaff = '1'
AND p.Level <
ORDER BY p.Level, m.LastAccess ASC
SQL 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 'ORDER BY p.Level, m.LastAccess ASC' at line 14)
dalilgriffith commented
Make sure the MOD variable is defined in config.php and corresponds to the ID field for the Moderator row in your permissions table.
lun4r commented
Yep. Looks like worked.
Thank you!