Thread

Upgraded from 1.7.0 to 2.4.0 (20120123) and my profile_views column was reset to zero for each of my members (nearly 2k).  Not sure why.  I have a backup of the exp_members table with the correct view figures.  I’m sure it’s not an important number for many, but key for me.

What’s the best way to get that information back into the table?

Hi chunky,

I’m sorry that you are having this trouble. Unfortunately the best option is to re-do the upgrade to ensure that the information in that table makes it all the way to 2.4. Be sure to carefully read the instructions on retrying after a failed up grade especially this the bold part here:

If you restore your database using a database dump (backup file) without first wiping your database clean, the elements that were removed during the failed upgrade will be restored by the backup. Those elements that were added by the failed upgrade, however, will still be part of the database. The version of ExpressionEngine that was your starting point before the upgrade will likely work without any errors because it’s completely blind to those new database elements. It just ignores them. A second attempt to upgrade ExpressionEngine, however, will result in failure when the Upgrade Wizard tries to add those new elements to the database again.

So before you attempt another upgrade, completely wipe your existing database clean. If it’s possible, delete the database itself and create a new, empty database. Then restore your database from backup, and try the upgrade again.

After re-trying the upgrade please post back on the result. If the data didn’t make it again, we’ll work with you to get it resolved.

Sean