1064 error - new install

dhngroup
dhngroup
Offline
0
Followed the instruction to install contents stats. Regardless of a plugin type I am getting similar errors:

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 st.component = "com_content" AND st.date_event BETWEEN SUBDATE(CURDATE(), 7' at line 1 SQL=SELECT COUNT(st.id) AS howmuch, st.date_event FROM drwzf_content_statistics as st LEFT JOIN drwzf_content as s ON s.id = st.reference_id WHERE st.type = 1 AND st.reference_id = AND st.component = "com_content" AND st.date_event BETWEEN SUBDATE(CURDATE(), 7) AND NOW() GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_event

mysql - 5.5.33
php - 5.4.24
Responses (6)
  • Accepted Answer

    Tuesday, September 09 2014, 09:46 AM - #Permalink
    0
    which are the settings of the plugin? can you make a screenshot?
    The reply is currently minimized Show
  • Accepted Answer

    dhngroup
    dhngroup
    Offline
    Tuesday, September 09 2014, 04:45 PM - #Permalink
    0
    The plugins are enabled with default config.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 09 2014, 04:51 PM - #Permalink
    0
    I'm sorry, I meant the configuration of the module. this error occurs in a module, correct? what are the settings on that module?
    The reply is currently minimized Show
  • Accepted Answer

    dhngroup
    dhngroup
    Offline
    Tuesday, September 09 2014, 06:24 PM - #Permalink
    0
    So far I managed to display successfully only with com_content in guest view. As soon as I logged in I received an error again.
    Every other attempt with different component resulted with the same error either in guest or registered mode.

    Thanks
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 09 2014, 06:34 PM - #Permalink
    0
    can you send a link to that page?
    The reply is currently minimized Show
  • Accepted Answer

    dhngroup
    dhngroup
    Offline
    Tuesday, September 09 2014, 09:01 PM - #Permalink
    0
    Sorry but how can I send you a private message? I will provide you the details.
    • Germinal Camps
      more than a month ago
      you can send it to support@ joomlathat.com
    The reply is currently minimized Show
Your Reply