wPcoMuser on "[Plugin: WP Slimstat Analytics] No data after upgrade"

Following my post six months ago in this thread, https://wordpress.org/support/topic/since-413-udate-no-new-logs?replies=28
, I was asked to start my own thread. Here it is, along with the last few posts from that last thread.

wPcoMuser

I have just realized that I have the same problem, and no data since approximately June.
I get the following error: " 215 Unknown column 'other_ip' in 'field list' "
I have tables called
_slim_stats
_slim_stats_3
(and two empty archive tables)
I tried copying the backup table (_3) to _slim_stats, but that resulted the following error:
215 Unknown column 'content_type' in 'field list'
Should I just create the two columns as above? If so, I guess I lose all IP values. Any way to use the backup table?
If you want this as a separate thread, happy to do so.

wPcoMuser

Appears to be fixed, although all IP information since the June upgrade is lost.

Created two columns in the new slim_stats table, called "ip" and one called "other_ip", with the command as listed earlier in this thread.
Then copied all values from the old backup table (from the upgrade process) to the new one with the following command. Replace PREFIX with the prefix of the tables in question.
UPDATE
PREFIX_slim_stats
INNER JOIN
PREFIX_slim_stats_3
ON
PREFIX_slim_stats.id = PREFIX_slim_stats_3.id
SET
PREFIX_slim_stats.ip = PREFIX_slim_stats_3.ip,
PREFIX_slim_stats.other_ip = PREFIX_slim_stats_3.other_ip

Jason Crouse

Great, thanks for reporting back.

wPcoMuser

I notice that the IP records format has changed. Do you happen to know a command that might convert the old format to the new? Right now I have a mix of values in those two columns.

https://wordpress.org/plugins/wp-slimstat/