WhatCD/Gazelle

Error in /sections/staff/functions.php

Closed this issue · 2 comments

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)

Make sure the MOD variable is defined in config.php and corresponds to the ID field for the Moderator row in your permissions table.

Yep. Looks like worked.
Thank you!