Database Error
Message:MySQL Query fail: SELECT a.*, ai.Images, aif.Image, ac.Comments, at.Name as ArticleType, u.Username as Username FROM articles AS a LEFT OUTER JOIN (SELECT Article_ID, count(ID) AS Images FROM articleimages WHERE State=2 GROUP BY Article_ID) AS ai ON ai.Article_ID = a.ID LEFT OUTER JOIN(Select ai1.Article_ID, ai1.File as Image, ai2.Sorting FROM articleimages as ai1 INNER JOIN (SELECT Article_ID, min(Sorting) as Sorting FROM articleimages WHERE State=2 GROUP BY Article_ID) as ai2 WHERE ai1.Sorting = ai2.Sorting AND ai1.Article_ID = ai2.Article_ID AND ai1.State=2) as aif ON aif.Article_ID = a.ID LEFT OUTER JOIN(Select Article_ID, count(ID) AS Comments FROM comments WHERE State<>0 GROUP BY Article_ID) as ac ON ac.Article_ID = a.ID INNER JOIN articletypes AS at ON a.ArticleType_ID = at.ID INNER JOIN users AS u ON a.User_ID = u.ID WHERE a.ID=www.gregoryclan.ch GROUP BY a.ID
MySQL Error:Unknown column 'www.gregoryclan.ch' in 'where clause'
Date:Thursday, October 19, 2017 at 12:53:09 PM
Script:/detail/www.gregoryclan.ch
Database Error
Message:MySQL Query fail: SELECT * FROM articleimages WHERE Article_ID= AND State=2 AND Imgsize=0 ORDER BY Sorting
MySQL Error: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 'AND State=2 AND Imgsize=0 ORDER BY Sorting' at line 2
Date:Thursday, October 19, 2017 at 12:53:09 PM
Script:/detail/www.gregoryclan.ch
Database Error
Message:MySQL Query fail: SELECT * FROM articleimages WHERE Article_ID= AND State=2 AND Imgsize=1 ORDER BY Sorting
MySQL Error: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 'AND State=2 AND Imgsize=1 ORDER BY Sorting' at line 2
Date:Thursday, October 19, 2017 at 12:53:09 PM
Script:/detail/www.gregoryclan.ch
Database Error
Message:MySQL Query fail: SELECT * FROM articlelinks WHERE Article_ID= AND State=2 ORDER BY Sorting ASC
MySQL Error: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 'AND State=2 ORDER BY Sorting ASC' at line 2
Date:Thursday, October 19, 2017 at 12:53:09 PM
Script:/detail/www.gregoryclan.ch
Database Error
Message:MySQL Query fail: SELECT p.Name, p.ID, pg.Name as PgName, p.PropertyGroup_ID as PgID, p.Sorting FROM article2property AS a2p INNER JOIN (Select ID, Name, PropertyGroup_ID, Sorting FROM properties) AS p ON p.ID = a2p.Property_ID INNER JOIN (Select ID, ArticleType_ID, Name FROM propertygroups) AS pg ON (p.PropertyGroup_ID = pg.ID AND pg.ArticleType_ID<>0) WHERE (a2p.Article_ID = AND a2p.Property_ID = p.ID) GROUP BY p.ID
MySQL Error: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 'AND a2p.Property_ID = p.ID) GROUP BY p.ID' at line 4
Date:Thursday, October 19, 2017 at 12:53:09 PM
Script:/detail/www.gregoryclan.ch
Aeberhard/Kaegi Aekae llc. Design Studio
Back to Overview