Problemen met memberlist na update phpbb garage
Geplaatst: 23 dec 2008, 13:33
- Modificatie & Versie: PHPBB Garage 2.0.B4
Directe link naar de modificatie: http://forums.phpbbgarage.com/viewtopic.php?f=0&t=907
Adres van je forum: http://www.vr6clubholland.nl/forum
phpBB versie: 3.0.4
Wat is het probleem?
Echter ik krijg deze melding met het raadplegen van memerlist groep bijvoorbeeld
http://www.vr6clubholland.nl/forum/memb ... =group&g=4
Code: Selecteer alles
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 = 4 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: 1456
CALL: dbal->sql_query_limit() Code: Selecteer alles
// 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
)