WordPress.org

Ready to get started?Download WordPress

Forums

WP SlimStat
[resolved] SQL errors in plugin (5 posts)

  1. FolioVision
    Member
    Posted 2 years ago #

    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/

  2. FolioVision
    Member
    Posted 2 years ago #

    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

  3. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Please read the installation instructions. You are required to deactivate/activate WP SlimStat if you upgraded to 2.5 :)

    Wake up, Martin!

    Camu

  4. FolioVision
    Member
    Posted 2 years ago #

    Hello Camu,

    thank you for your reply, that is a nice fix.

    Martin

  5. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Cool.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic