Hi,
can you see if Slimstat is reporting an error under Settings > Maintenance > Tracker Error Code? Also, can you check in phpMyAdmin what’s the type of the two columns ip and other_ip in wp_slim_stats?
Thanks,
Camu
Hi,
just a simple “214 Logged in user not tracked recorded on 09.06.2015 @ 12:26”
That seems to be me in the admin panel.
Thanks
Fabian
Hi,
Can you also check the type of those two columns? (See my message here above)
Camu
Hi,
there are no columns ip and other_ip in wp_slim_stats. I’ve found them in wp_slim_stats_3 (wp_slim_stats_4 is empty btw).
In wp_slim_stats_3 ip and other_ip are int(10).
Fabian
Something must have gone wrong during the update. Please add the two columns by mimicking the upgrade steps:
https://plugins.trac.ww.wp.xz.cn/browser/wp-slimstat/trunk/admin/wp-slimstat-admin.php#L507
You can skip the part where you copy the data from the old columns.
Hi,
that’s working.
Is there a way to get the old ip data back?
The overall page hits are still there, but not the day bu day hits of the past.
Fabian
The primary key value in wp_slim_stat and wp_slim_stat_3 was preserved when the table structure was updated. You could use an UPDATE statement with a join between those two table to restore your IP addresses. Please note that you’ll have to convert the value from int to string with INET_NTOA.
Best,
Camu
Hi Camu,
I’ve used the following statement:
UPDATE wp_slim_stats INNER JOIN wp_slim_stats_3 ON wp_slim_stats_3.id = wp_slim_stats.id SET wp_slim_stats.ip = INET_NTOA(wp_slim_stats_3.ip), wp_slim_stats.other_ip = INET_NTOA(wp_slim_stats_3.other_ip)
Not all of the data is restored. Some weeks are missing completely. Don’t know why but this is even better than no data.
Fabian
Hm, probably the data between the update to 4.0 and the update to 4.1.3. But I’m glad you were able to recover all the information.
Can I get this back, too?
But that’s data from the last month. There’s over one week missing. So maybe not because of the 4.0 to 4.1.3 update.
Hm, can you see if it’s in the old database? Maybe install a separate instance of WP + Slimstat 3.9 and then restore the old database to access the info there.
