Title: Not working, sql errors
Last modified: August 30, 2016

---

# Not working, sql errors

 *  Resolved [pattaya_web](https://wordpress.org/support/users/pattaya_web/)
 * (@pattaya_web)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/)
 * 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://wordpress.org/plugins/wp-slimstat/](https://wordpress.org/plugins/wp-slimstat/)

Viewing 10 replies - 16 through 25 (of 25 total)

[←](https://wordpress.org/support/topic/not-working-sql-errors/?output_format=md)
[1](https://wordpress.org/support/topic/not-working-sql-errors/?output_format=md)
2

 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551049)
 *     ```
       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](https://wordpress.org/support/users/pattaya_web/)
 * (@pattaya_web)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551050)
 * 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 Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551051)
 * That is not a Slimstat file.
 *  Thread Starter [pattaya_web](https://wordpress.org/support/users/pattaya_web/)
 * (@pattaya_web)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551052)
 * 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 Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551060)
 * 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](https://wordpress.org/support/users/pattaya_web/)
 * (@pattaya_web)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551063)
 * 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 Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551064)
 * 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 Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551065)
 * 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](https://wordpress.org/support/users/pattaya_web/)
 * (@pattaya_web)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551066)
 * 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 Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551067)
 * 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)

[←](https://wordpress.org/support/topic/not-working-sql-errors/?output_format=md)
[1](https://wordpress.org/support/topic/not-working-sql-errors/?output_format=md)
2

The topic ‘Not working, sql errors’ is closed to new replies.

 * ![](https://ps.w.org/wp-slimstat/assets/icon.svg?rev=2832242)
 * [SlimStat Analytics](https://wordpress.org/plugins/wp-slimstat/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-slimstat/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-slimstat/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-slimstat/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-slimstat/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-slimstat/reviews/)

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 25 replies
 * 2 participants
 * Last reply from: [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/not-working-sql-errors/page/2/#post-6551067)
 * Status: resolved