Title: [Plugin: WP SlimStat] SQL errors in plugin
Last modified: August 20, 2016

---

# [Plugin: WP SlimStat] SQL errors in plugin

 *  Resolved [FolioVision](https://wordpress.org/support/users/foliovision/)
 * (@foliovision)
 * [14 years, 7 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/)
 * Dear WP SlimStat authors,
 * our error_log is filled with various warnings from this plugin:
 * `[19-Oct-2011 12:07:07] WordPress database error Unknown column 'user' in 'where
   clause' for query INSERT INTO wp_slim_stats (`ip`,`user`,`language`,`country`,`
   searchterms`,`resource`,`dt`,`browser_id` )
    SELECT ‘2915102265’,”,’xx’,’us’,”,’/
   2009/01/****.html’,’1319008027′,” FROM DUAL WHERE NOT EXISTS ( SELECT `id` FROM
   wp_slim_stats WHERE `ip` = ‘2915102265’ AND `user` = ” AND `language` = ‘xx’ 
   AND `country` = ‘us’ AND `searchterms` = ” AND `resource` = ‘/2009/01/***.html’
   AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME(‘1319008027’),FROM_UNIXTIME(`dt`))) <
   30) AND `browser_id` = ” LIMIT 1 ) made by require, wp, WP->main, do_action_ref_array,
   call_user_func_array, wp_slimstat->slimtrack [19-Oct-2011 12:07:07] WordPress
   database error Unknown column ‘user’ in ‘where clause’ for query SELECT `id` 
   FROM wp_slim_stats WHERE `ip` = ‘2915102265’ AND `user` = ” AND `language` = ‘
   xx’ AND `country` = ‘us’ AND `searchterms` = ” AND `resource` = ‘/2009/01/***.
   html’ AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME(‘1319008027’),FROM_UNIXTIME(`dt`)))
   < 30) AND `browser_id` = ” LIMIT 1 made by require, wp, WP->main, do_action_ref_array,
   call_user_func_array, wp_slimstat->slimtrack [19-Oct-2011 12:07:10] WordPress
   database error Unknown column ‘type’ in ‘where clause’ for query INSERT INTO 
   wp_slim_browsers (browser, version, platform, css_version, type) SELECT ‘Baiduspider’,’
   2.0′,’unknown’,’0′,1 FROM DUAL WHERE NOT EXISTS ( SELECT browser_id FROM wp_slim_browsers
   WHERE browser = ‘Baiduspider’ AND version = ‘2.0’ AND platform = ‘unknown’ AND
   css_version = ‘0’ AND type = 1 LIMIT 1) made by require, wp, WP->main, do_action_ref_array,
   call_user_func_array, wp_slimstat->slimtrack [19-Oct-2011 12:07:10] WordPress
   database error Unknown column ‘type’ in ‘where clause’ for query SELECT browser_id
   FROM wp_slim_browsers WHERE browser = ‘Baiduspider’ AND version = ‘2.0’ AND platform
   = ‘unknown’ AND css_version = ‘0’ AND type = 1 LIMIT 1 made by require, wp, WP-
   >main, do_action_ref_array, call_user_func_array, wp_slimstat->slimtrack [19-
   Oct-2011 12:07:10] WordPress database error Unknown column ‘user’ in ‘where clause’
   for query INSERT INTO wp_slim_stats ( `ip`, `user`, `language`, `country`, `searchterms`,`
   resource`, `dt`, `browser_id` ) SELECT ‘3024881086’,”,’tr-tr’,’cn’,”,’/2010/03/****.
   html?replytocom=19396′,’1319008030′,” FROM DUAL WHERE NOT EXISTS ( SELECT `id`
   FROM wp_slim_stats WHERE `ip` = ‘3024881086’ AND `user` = ” AND `language` = ‘
   tr-tr’ AND `country` = ‘cn’ AND `searchterms` = ” AND `resource` = ‘/2010/03/****.
   html?replytocom=19396’ AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME(‘1319008030’),
   FROM_UNIXTIME(`dt`))) < 30) AND `browser_id` = ” LIMIT 1 ) made by require, wp,
   WP->main, do_action_ref_array, call_user_func_array, wp_slimstat->slimtrack [
   19-Oct-2011 12:07:10] WordPress database error Unknown column ‘user’ in ‘where
   clause’ for query SELECT `id` FROM wp_slim_stats WHERE `ip` = ‘3024881086’ AND`
   user` = ” AND `language` = ‘tr-tr’ AND `country` = ‘cn’ AND `searchterms` = ”
   AND `resource` = ‘/2010/03/w***t.html?replytocom=19396’ AND (TIME_TO_SEC(TIMEDIFF(
   FROM_UNIXTIME(‘1319008030’),FROM_UNIXTIME(`dt`))) < 30) AND `browser_id` = ” 
   LIMIT 1 made by require, wp, WP->main, do_action_ref_array, call_user_func_array,
   wp_slimstat->slimtrack `
 * Please have a look into this. The error_log file was 600MB after few months. 
   The plugin is on the latest version, but perhaps it was an older version before
   and the upgrade routine didn’t added the columns to the table.
 * Let us know what do you think.
 * Thank,
    Martin
 * [http://wordpress.org/extend/plugins/wp-slimstat/](http://wordpress.org/extend/plugins/wp-slimstat/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [FolioVision](https://wordpress.org/support/users/foliovision/)
 * (@foliovision)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/#post-2355526)
 * Hello,
 * this is not fixed yet, could anyone recommend at least some quick fix?
 * Could be perhaps add the missing column the table?
 * Thanks,
    Martin
 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/#post-2355530)
 * Please read the [installation instructions](http://wordpress.org/extend/plugins/wp-slimstat/installation/).
   You are required to deactivate/activate WP SlimStat if you upgraded to 2.5 🙂
 * Wake up, Martin!
 * Camu
 *  Thread Starter [FolioVision](https://wordpress.org/support/users/foliovision/)
 * (@foliovision)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/#post-2355531)
 * Hello Camu,
 * thank you for your reply, that is a nice fix.
 * Martin
 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/#post-2355532)
 * Cool.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘[Plugin: WP SlimStat] SQL errors in plugin’ 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/)

 * 4 replies
 * 2 participants
 * Last reply from: [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * Last activity: [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-sql-errors-in-plugin/#post-2355532)
 * Status: resolved