Not working, sql errors

  • Resolved pattaya_web

    (@pattaya_web)


    9 years, 2 months ago

    Hi,

    I’ve just installed this and perhaps I’ve set it up wrong, but I’m not seeing any results after 24 hours.

    With debug mode activated each of the sections is filled with

    SELECT author, COUNT(*) counthits FROM wp_ojup_slim_stats WHERE author IS NOT NULL AND dt BETWEEN 1441065600 AND 1442404422 GROUP BY author ORDER BY counthits DESC LIMIT 0, 100

    My MySQL error log is showing repeated entries of:

    SELECT author, COUNT(*) counthits FROM wp_ojup_slim_stats WHERE author IS NOT NULL AND dt BETWEEN 1441065600 AND 1442404422 GROUP BY author ORDER BY counthits DESC LIMIT 0, 100

    If I activate User Role Editor the entire site falls over

    Thank you

    John

    https://www.ads-software.com/plugins/wp-slimstat/

Viewing 10 replies - 16 through 25 (of 25 total)
  • Plugin Author Jason Crouse

    (@coolmann)

    WHERE resource IS NOT NULL AND content_type <> "404" AND dt BETWEEN 1443139200 AND 1443215117
   GROUP BY resource HAVING COUNT(visit_id) => 1

    This bug will be fixed in our next update. Contact us if you want to test it in advance.

    Thread Starter pattaya_web

    (@pattaya_web)

    Hi thanks for that. Yes please, would like to test the pre-release if it’s stable.

    The only error I’m seeing in the error log is:

    /wp-admin/index.php
Undeclared entity error at line 11, column 21

    When I looked at index.php Line 11 is blank. I’m guessing this is a problem in a database table, but don’t know where to go and look, or what to do if I found it LoL

    Plugin Author Jason Crouse

    (@coolmann)

    That is not a Slimstat file.

    Thread Starter pattaya_web

    (@pattaya_web)

    I never said it was a Slimstats file.

    You said look in the server error logs and I said “The only error I’m seeing in the error log is” the one I pasted.

    Plugin Author Jason Crouse

    (@coolmann)

    True. However I still see the error 500. I suspect the script is hitting your PHP memory limit. Please ask your service provider to increase that limit to see if the problem can be solved that way. Take a look at our FAQs here above to learn more about this.

    Thread Starter pattaya_web

    (@pattaya_web)

    Hi, Thanks. Can you tell me where/ how to see/ find this 500 error so I can send it on to the hosting company?

    Thank you

    John

    Plugin Author Jason Crouse

    (@coolmann)

    Hi,

    if you use Chrome, you can access the Developer Tools and then go to the Network tab. Here you can find all the activity between the browser and the server, including HTTP headers, request headers, response headers and so on. If you filter by XHR (ajax requests), you’ll see all the calls the javascript tracker generates back to the server.

    Hope this helps,
    Camu

    Plugin Author Jason Crouse

    (@coolmann)

    Out of curiosity, I checked your site again, and after 2 minutes and 30 seconds the tracker was finally able to run (after about 45 calls to video embed scripts which slowed down my browser to a crawl). This time I didn’t get a 500 error message. The tracking script was able to record my visit and assigned me a visit_id, which I found in the cookie. So it looks like the script is now working. However it takes an incredibly long time for the tracker to get a response from the server. I would recommend switching to Server Mode ( Settings > General > Tracking Mode ). Also, if you don’t need to collect data about screen resolutions, you could enable Stealth Mode to make it even faster. Try that and let me know.

    Thread Starter pattaya_web

    (@pattaya_web)

    Hey Camu,

    Thanks very much. Greatly appreciated (yes, I know how to show my gratitude).

    I just flicked it over to Server mode and see how it goes. Stealth was already disabled.

    Is there anything I can do about those video embed scripts?

    Thanks very much

    Plugin Author Jason Crouse

    (@coolmann)

    Not sure what you could do about the video embeds, all I can say is that it took an unusual long time to load the page from the US.

Viewing 10 replies - 16 through 25 (of 25 total)
  • The topic ‘Not working, sql errors’ is closed to new replies.

Tags