by sol'd out » Wed Oct 12, 2011 12:14 am
SQL error when clicking on the Garage button in someone's profile. Looks like it's going for the old database? Error message as follows:
General Error
SQL ERROR [ mysql4 ]
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 'd out' GROUP BY v.id ORDER BY date_created ASC LIMIT 30' at line 4 [1064]
SQL
SELECT v.*, i.*, mk.make, md.model, u.username, u.user_colour, count(m.id) AS total_mods FROM (phpbb_garage_vehicles v, phpbb_garage_makes mk, phpbb_garage_models md, phpbb_users u) LEFT JOIN phpbb_garage_modifications m ON (v.id = m.vehicle_id) LEFT JOIN phpbb_garage_products p ON (p.id = m.product_id) LEFT JOIN phpbb_garage_vehicles_gallery vg ON (v.id = vg.vehicle_id AND vg.hilite = 1) LEFT JOIN phpbb_garage_images i ON (vg.image_id = i.attach_id) WHERE v.pending = 0 AND (v.make_id = mk.id and mk.pending = 0) AND (v.model_id = md.id and md.pending = 0) AND v.user_id = u.user_id AND u.username = 'sol'd out' GROUP BY v.id ORDER BY date_created ASC LIMIT 30
BACKTRACE
FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: includes/mods/class_garage.php
LINE: 761
CALL: dbal->sql_query_limit()
FILE: garage.php
LINE: 472
CALL: garage->perform_search()