Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (3)

Top user logins - SQL error

Content Statistics
Tuesday, February 23 2016, 08:52 PM
koaconsulting
koaconsulting
Offline
0
I set the Content provider to be "comprofiler" and the Content criteria to be "Top user logins" then set the Position to be contentstats_backend_1 and then when I reload the Joomla control panel I get the following SQL error:

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 'LIMIT 5' at line 1 SQL=LIMIT 5

I haven't set any other options but even when I do try changing various things it doesn't seem to help. I am using the newest version of Joomla and Content Statistics and Community Builder. Please help!

Thanks!
Responses (3)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, February 23 2016, 10:07 PM - #Permalink
    0
    Hello,

    Can you share what is the configuration on the module? can you make a screenshot of the options?
    The reply is currently minimized Show

  • Accepted Answer

    koaconsulting
    koaconsulting
    Offline
    Tuesday, February 23 2016, 10:48 PM - #Permalink
    0
    Thanks for getting back to me. It's all the default options, the only thing I changed are the items I listed in my first post. Here is the screenshot anyway.
    Attachments:
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Wednesday, February 24 2016, 10:11 AM - #Permalink
    0
    I see..

    the configuration seems correct. there must be something we're missing.

    Could you send me joomla admin access to the site, so I can take a look? my email is support@ joomlathat.com
    The reply is currently minimized Show
Your Reply