No data collected

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.www.ads-software.com/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.