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