[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/