"No Data to Display" after latest update

Hi Darren,

Can you check if Slimstat is reporting an error under Settings > Maintenance > Debugging?

Thanks
Camu

Hi Camu
Thanks for the rapid response!

I see the following error:

215 Unknown column ‘other_ip’ in ‘field list’ recorded on 06-10-15 @ 11:28 pm

Apparently in a few instances the upgrade script didn’t apply all the structural changes to the database.

In phpMyAdmin, can you check if you have two columns ip and other_ip in your wp_slim_stats table? If not, can you add them with this SQL statement?

ALTER TABLE wp_slim_stats ADD ip VARCHAR(39) DEFAULT NULL AFTER id, ADD other_ip VARCHAR(39) DEFAULT NULL AFTER id

Make sure you replace WP’s table prefix with the actual one used in your setup.

I`ve managed to add those 2 fields to the table, which for some reason disappeared with the recent upgrade.

The data that used to be in those 2 fields are lost I`m assuming unless I restore from a backed up database? I’d prefer not going that route as there are other changes that have taken place within my database outside of Slimstat that I’d not want to rollback.

Darren

Hi Darren,

you could just restore your old Slimstat table, not all the other tables. If you can restore it with a different name, I can help you recover all the info about your IP addresses. In the meanwhile, to avoid this issue for other users (apparently it happened to a handful of users out of thousands) we changed our code to use a different approach while converting the data to the new format. So far we haven’t been able to identify a pattern that points out WHY this happened to a few users, but we’re still looking into it.

Hi Camu,
I think I mayve been overzealous in cleaning my site of unnecessary files and plugins (in an effort to speed the site load time), and deactivated Updraft which was performing beautiful backups for me until a few months ago. Unfortunately, with the one database backup plugin I had activated - ithemes - I only had 2 backup files, and theyre within the last 24hrs, so unfortunately the 2 day old version of the database which I need for retrieving the IPs is gone. I`ve since reactivated Updraft. Lesson learned!

I am sorry about that. On our end, we will be more careful in preserving data as much as possible, even when our tests tell us that we can go ahead and get rid of old stuff. Because there’s always that one case out of thousands where things might go wrong. :/

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.

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

Great, thanks for reporting back.

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.

wPcoMuser, please start your own thread.