Thema: CBE + PonyML Tab riesen fehler

Hab alles nach Plan installiert nur wenn ich im CBE den Pony Tab Publish mache bekomme ich diesen Fehler und die ganze Seite wird zerschossen aber wenn ich Unpublish mache sieht alles wieder ok aus !



PT-E-8: Query Error -> DB function failed with error number 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 'SELECT count(cmtid) FROM jos_ponygallery_comments WHERE cmtpic= SQL=SELECT (SELECT count(cmtid) FROM jos_ponygallery_comments WHERE cmtpic=id) AS cmtcount, p.id AS picid, p.catid, p.imgthumbname, p.imgfilename, p.imgdate, p.imgtitle, p.imgtext, p.imgcounter, p.imgvotes, (p.imgvotesum/p.imgvotes) AS vote,c.name AS cattitle, co.cmttext, co.cmtdate, co.cmtname, co.cmtid FROM jos_ponygallery AS p LEFT JOIN jos_ponygallery_comments AS co ON p.id = co.cmtpic LEFT JOIN jos_ponygallery_catg AS c ON c.cid = p.catid LEFT JOIN jos_ponygallery_comments co2 ON co.cmtpic = co2.cmtpic AND co.cmtdate < co2.cmtdate WHERE co2.cmtpic IS NULL AND c.published = '1' AND c.access <= 1 AND p.published = 1 AND p.approved = 1 AND p.owner = 'Durmus' ORDER BY p.imgdate DESC
SQL =
SELECT (SELECT count(cmtid) FROM jos_ponygallery_comments WHERE cmtpic=id) AS cmtcount,
p.id AS picid, p.catid, p.imgthumbname, p.imgfilename,
p.imgdate, p.imgtitle, p.imgtext, p.imgcounter, p.imgvotes,
(p.imgvotesum/p.imgvotes) AS vote,c.name AS cattitle,
co.cmttext, co.cmtdate, co.cmtname, co.cmtid
FROM jos_ponygallery AS p
LEFT JOIN jos_ponygallery_comments AS co ON p.id = co.cmtpic
LEFT JOIN jos_ponygallery_catg AS c ON c.cid = p.catid
LEFT JOIN jos_ponygallery_comments co2 ON co.cmtpic = co2.cmtpic
AND co.cmtdate < co2.cmtdate
WHERE co2.cmtpic IS NULL
AND c.published = '1'
AND c.access <= 1
AND p.published = 1
AND p.approved = 1
AND p.owner = 'Durmus' ORDER BY p.imgdate DESC

sorry hab

Joomla! 1.0.15 Stable

PonyML Version 2.5.1