Kleines Problem mit dem Garage Mod

[Holger]

Hi!

Wenn ich auf die Gruppen-Legende klicke bekomme ich:

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()

Es geht om diesen Code-Abschnitt (1691 ist die letzte Zeile):

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);

Wahrscheinlich ein JOIN-Problem oder?

Gruss
Holger

[Holger]

Bugfix gefunden!
http://bugs.phpbbgarage.com/view.php?id=140

/Holger