Spaca
Spaca
Offline
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

Accepted Answer

Spaca
Spaca
Offline
Wednesday, January 07 2015, 03:47 PM - #Permalink
0
Ok, where to send it?
The reply is currently minimized Show
Responses (4)
  • Accepted Answer

    Wednesday, January 07 2015, 11:47 AM - #Permalink
    0
    first, try to set your joomla error reporting to "simple" in joomla global configuration.

    then, make sure the content statistics SYSTEM plugin is installed and enabled.

    in this scenario: what do you see on the module manager?
    The reply is currently minimized Show
  • Accepted Answer

    Spaca
    Spaca
    Offline
    Wednesday, January 07 2015, 01:22 PM - #Permalink
    0
    Thank 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.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, January 07 2015, 03:36 PM - #Permalink
    0
    ok, can you send me access to your administrator area so I can take a look at it?
    The reply is currently minimized Show
  • Accepted Answer

    Spaca
    Spaca
    Offline
    Thursday, January 08 2015, 07:06 PM - #Permalink
    0
    Everything works fine now, thank you for your help!
    The reply is currently minimized Show
Your Reply