Re: Could Not Get Vehicle Data

maryo — 25.7.2009 , 17:45

Autor: maryo

Zaslal: 25.7.2009 , 17:45

WHERE g.id = GROUP BY g.id
Tady chybi nejaky idcko

Could Not Get Vehicle Data

Lubosh — 25.7.2009 , 14:00

Autor: Lubosh

Zaslal: 25.7.2009 , 14:00

Když jsem prohlížel v garáži auto 665+1 a v guestbooku jsem klikl na auto někoho jiného, např. Verči, která tam něco píše, tak mi to napsalo tohle:

Could Not Get Vehicle Data

DEBUG MODE

SQL Error : 1064 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 '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 garage AS g LEFT JOIN users AS user ON g.member_id = user.user_id LEFT JOIN garage_makes AS makes ON g.make_id = makes.id LEFT JOIN garage_models AS models ON g.model_id = models.id LEFT JOIN garage_mods AS mods ON g.id = mods.garage_id LEFT JOIN garage_images AS images ON images.attach_id = g.image_id WHERE g.id = GROUP BY g.id

Line : 1678
File : class_garage_vehicle.php

Anglicky neumím, takže nevím co se tam píše... Třeba je to nějaká banální chyba.... Jen aby se o tom vědělo

:: www.honda-club.cz ::

Re: Could Not Get Vehicle Data

Could Not Get Vehicle Data