Forum Replies Created

Viewing 1 replies (of 1 total)
  • Hi Camu

    Suddenly there is “No data to display” on my SlimStat. I’m sure I’ll be recommended to upgrade as my versions are old but nevertheless, is it possible to recover the stats?
    Here is some info about versions:

    wordpress 2.9.1
    phpMyAdmin 3.5.2

    webserver is
    Apache/2
    Database client version: libmysql – 5.5.25a
    PHP extension: mysqli Documentation

    A sample from the Error log of db is

    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] WordPress database error BIGINT UNSIGNED value is out of range in '(<cache>(unix_timestamp()) - <code>web182-pfw_db</code>.<code>wp_slim_stats</code>.<code>dt</code>)' for query INSERT INTO <code>wp_slim_stats</code> ( <code>searchterms</code>, <code>resource</code>, <code>ip</code>, <code>language</code>, <code>country</code>, <code>dt</code>, <code>browser_id</code> )\r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\tSELECT '', '/?feed=rss2', '3512069771', 'xx', 'us', '1353904825', '22'\r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\tFROM DUAL\r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\tWHERE NOT EXISTS ( SELECT <code>id</code> \r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\t\tFROM <code>wp_slim_stats</code>\r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\t\tWHERE <code>searchterms</code> = '' AND <code>resource</code> = '/?feed=rss2' AND <code>ip</code> = '3512069771' AND <code>language</code> = 'xx' AND <code>country</code> = 'us' AND (UNIX_TIMESTAMP() - <code>dt</code> < 30) AND <code>browser_id</code> = '22' LIMIT 1 ) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, wp_slimstat->slimtrack
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] WordPress database error BIGINT UNSIGNED value is out of range in '(<cache>(unix_timestamp()) - <code>web182-pfw_db</code>.<code>wp_slim_stats</code>.<code>dt</code>)' for query SELECT <code>id</code> \r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\t\tFROM <code>wp_slim_stats</code>\r
    [Mon Nov 26 03:40:25 2012] [error] [client 209.85.238.139] \t\t\t\tWHERE <code>searchterms</code> = '' AND <code>resource</code> = '/?feed=rss2' AND <code>ip</code> = '3512069771' AND <code>language</code> = 'xx' AND <code>country</code> = 'us' AND (UNIX_TIMESTAMP() - <code>dt</code> < 30) AND <code>browser_id</code> = '22' LIMIT 1  made by require, wp, WP->main, do_action_ref_array, call_user_func_array, wp_slimstat->slimtrack

    Let me know if you need any more info. Thank you

    Tarik

Viewing 1 replies (of 1 total)