WordPress.org

Support

Support » Plugins and Hacks » [Resolved] [Plugin: WP SlimStat] SQL errors in plugin

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

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Resolved] [Plugin: WP SlimStat] SQL errors in plugin’ is closed to new replies.