erreur sql sur page accueil

mardi 4 novembre 2014

Bonjour après installation d'un script je retrouve cette erreur en bas de la page d'accueil,et la j'y comprends que dalle,si vous avez une idée je vous remercie d'avance!

SELECT a.*, ct.cityname, UNIX_TIMESTAMP(a.createdon) AS timestamp, feat.adid AS isfeat, COUNT(*) AS piccount, p.picfile AS picfile, scat.subcatname, scat.catid, cat.catname FROM phpas_ads a INNER JOIN phpas_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW() INNER JOIN phpas_cities ct ON a.cityid = ct.cityid INNER JOIN phpas_subcats scat ON a.subcatid = scat.subcatid INNER JOIN phpas_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN phpas_adpics p ON a.adid = p.adid AND p.isevent = '0' WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 5Unknown COLUMN 'feat.adtype' IN 'on clause'





0 commentaires:

Enregistrer un commentaire

 

Lorem

Ipsum

Dolor