Wenn ich auf die Gruppen-Legende klicke bekomme ich:
Es geht om diesen Code-Abschnitt (1691 ist die letzte Zeile):SQL ERROR [ mysqli ]
Unknown column 'u.user_id' in 'on clause' [1054]
SQL
SELECT u.user_id, v.id as vid FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_garage_vehicles v ON ( v.user_id = u.user_id AND v.main_vehicle = 1 ) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 5 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 25
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: memberlist.php
LINE: 1691
CALL: dbal->sql_query_limit()
Code: Alles auswählen
// Get us some users :D
$sql = "SELECT u.user_id, v.id as vid
FROM " . USERS_TABLE . " u
$sql_from
LEFT JOIN " . GARAGE_VEHICLES_TABLE . " v
ON (
v.user_id = u.user_id AND v.main_vehicle = 1
)
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);
Gruss
Holger