A Forum dedicated to PDXCGP, and SEACGP members    
A Forum dedicated to PDXCGP, and SEACGP members    
Make Homepage

Username:   Password:  Auto Login  
It is currently Tue May 21, 2019 1:38 am
All times are UTC - 7 Hours

General Error
Could Not Get Vehicle Data


SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY g.id' at line 9

SELECT g.*, ROUND(g.weighted_rating, 2) as weighted_rating, images.*, makes.make, models.model, CONCAT_WS(' ', g.made_year, makes.make, models.model) AS vehicle, count(mods.id) AS total_mods, ( SUM(mods.price) + SUM(mods.install_price) ) AS total_spent, user.username, user.user_avatar_type, user.user_allowavatar, user.user_avatar, user.user_id FROM phpbb_garage AS g LEFT JOIN phpbb_users AS user ON g.member_id = user.user_id LEFT JOIN phpbb_garage_makes AS makes ON g.make_id = makes.id LEFT JOIN phpbb_garage_models AS models ON g.model_id = models.id LEFT JOIN phpbb_garage_mods AS mods ON g.id = mods.garage_id LEFT JOIN phpbb_garage_images AS images ON images.attach_id = g.image_id WHERE g.id = GROUP BY g.id

Line : 1729
File : class_garage_vehicle.php