phpBB.de

Code: Alles auswählen

SQL ERROR [ mysqli ]

Unknown column 'u.user_id' in 'on clause' [1054]

SQL

SELECT u.user_id FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_profile_fields_data fd ON (u.user_id = fd.user_id) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 11 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 25

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 224
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: [ROOT]/memberlist.php
LINE: 1487
CALL: dbal->sql_query_limit()

Code: Alles auswählen

if(isset($sort_key_sql['y'])) {
             $sql = "SELECT u.user_id
                     FROM " . USERS_TABLE . " u
                     $sql_from
                     LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)
                     WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                     $sql_where
                     ORDER BY $order_by";
          } else {
         
          $sql = "SELECT u.user_id
             FROM " . USERS_TABLE . " u
                $sql_from
             WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                $sql_where
             ORDER BY $order_by";
             }
          $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);