0
Hello,
I follewed all instructions and everything gone fine, but when I open any of your Content Statistics modules in Extension manager, I will get lot of warnings (See picture attached). If I enable any of modules I can't see web page but following error text in browser:
"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 'AND ( S.PUBLISHED = 1 OR S.PUBLISHED = 2 ) AND ( S.PUBLISH_UP <= NOW() OR S.PUB' AT LINE 1 SQL=SELECT S.*, COUNT(ST.ID) AS HOWMUCH, S.TITLE AS ITEM_NAME, CONCAT("INDEX.PHP?OPTION=COM_EASYBLOG&VIEW=ENTRY&ID=", S.ID) AS ITEM_LINK FROM WJC6P_CONTENT_STATISTICS AS ST LEFT JOIN WJC6P_EASYBLOG_POST AS S ON S.ID = ST.REFERENCE_ID LEFT JOIN WJC6P_EASYBLOG_CATEGORY AS CA ON CA.ID = S.CATEGORY_ID WHERE ST.TYPE = 1 AND ST.COMPONENT = "COM_EASYBLOG" AND S.CATEGORY_ID = AND ( S.PUBLISHED = 1 OR S.PUBLISHED = 2 ) AND ( S.PUBLISH_UP <= NOW() OR S.PUBLISH_UP = "0000-00-00 00:00:00" ) AND ( S.PUBLISH_DOWN >= NOW() OR S.PUBLISH_DOWN = "0000-00-00 00:00:00" ) GROUP BY S.ID ORDER BY HOWMUCH DESC LIMIT 5"
Joomla! version, 3.3.6.
EasyBlog 3.9.19775
Sincerely,
Spaca
I follewed all instructions and everything gone fine, but when I open any of your Content Statistics modules in Extension manager, I will get lot of warnings (See picture attached). If I enable any of modules I can't see web page but following error text in browser:
"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 'AND ( S.PUBLISHED = 1 OR S.PUBLISHED = 2 ) AND ( S.PUBLISH_UP <= NOW() OR S.PUB' AT LINE 1 SQL=SELECT S.*, COUNT(ST.ID) AS HOWMUCH, S.TITLE AS ITEM_NAME, CONCAT("INDEX.PHP?OPTION=COM_EASYBLOG&VIEW=ENTRY&ID=", S.ID) AS ITEM_LINK FROM WJC6P_CONTENT_STATISTICS AS ST LEFT JOIN WJC6P_EASYBLOG_POST AS S ON S.ID = ST.REFERENCE_ID LEFT JOIN WJC6P_EASYBLOG_CATEGORY AS CA ON CA.ID = S.CATEGORY_ID WHERE ST.TYPE = 1 AND ST.COMPONENT = "COM_EASYBLOG" AND S.CATEGORY_ID = AND ( S.PUBLISHED = 1 OR S.PUBLISHED = 2 ) AND ( S.PUBLISH_UP <= NOW() OR S.PUBLISH_UP = "0000-00-00 00:00:00" ) AND ( S.PUBLISH_DOWN >= NOW() OR S.PUBLISH_DOWN = "0000-00-00 00:00:00" ) GROUP BY S.ID ORDER BY HOWMUCH DESC LIMIT 5"
Joomla! version, 3.3.6.
EasyBlog 3.9.19775
Sincerely,
Spaca
Responses (4)
-
Accepted Answer
-
Accepted Answer
0Thank you for quick answer. Error reporting is set to "simple" and all required plugins are installed and enabled. However, all warnings are still here in module manager. If I choose error reporting to "none" all warnings disappear from module manager, but previously reported error in webpage is still here. -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »