Title: No data after upgrade
Last modified: August 31, 2016

---

# No data after upgrade

 *  Resolved [wPcoMuser](https://wordpress.org/support/users/wpcomuser/)
 * (@wpcomuser)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/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](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/](https://wordpress.org/plugins/wp-slimstat/)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428071)
 * Hi,
 * would you be able to post a screenshot of the ip and other_ip columns? (structure
   view in phpMyAdmin)
 * Thanks,
    Jason
 *  Thread Starter [wPcoMuser](https://wordpress.org/support/users/wpcomuser/)
 * (@wpcomuser)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428188)
 * I can do this. I will try to get this done in the next week for you.
 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428196)
 * Cool.
 *  Thread Starter [wPcoMuser](https://wordpress.org/support/users/wpcomuser/)
 * (@wpcomuser)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428225)
 * Here is a snippet of both columns.
 * `http://postimg.org/image/dga19xh2z/`
 * Down around the 1/3 point in the database, the values in the ip and other_ip 
   cols turn into regularly formatted IP addresses, i.e. 24.1.1.1 (or whatever).
 *  Thread Starter [wPcoMuser](https://wordpress.org/support/users/wpcomuser/)
 * (@wpcomuser)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428226)
 * Sorry, found the dt col and sorted on it. The **more recent** entries are plain
   formatted IP addresses, and the **older ones** are some kind of converted format.
 *  Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428228)
 * Hi,
 * what you want to do is to convert the numeric values into strings, using
 *     ```
       INET_NTOA(t1.ip),
       INET_NTOA(t1.other_ip),
       ```
   
 * An UPDATE sql command can be easily drafted, with a
 * `WHERE ip REGEXP '[0-9]+'`
 * (you will need two separate UPDATEs, one for ip and one for other_ip)
 * Hope this helps.
 * Jason.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘No data after upgrade’ is closed to new replies.

 * ![](https://ps.w.org/wp-slimstat/assets/icon.svg?rev=2832242)
 * [SlimStat Analytics](https://wordpress.org/plugins/wp-slimstat/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-slimstat/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-slimstat/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-slimstat/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-slimstat/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-slimstat/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/no-data-after-upgrade/#post-7428228)
 * Status: resolved