XF 2.2 My Last Hope

[Shane Greer]

Ok so it appears I have mucked up and lost 12 years of forum work - this I guess is my last chance of trying to find a fix.

Long story but here goes.

• I decided to upgrade to v2.3.
• Error pops up in admin I need Mysql8.0 - Im only running 5.7
• I go to my server hosts - they can upgrade my servers to 8.0
• I jump through the hoops - site is migrating. I will need to change db host when fully migrated.
• 2 weeks later site still shown as migrating. I contact server support and they 'fix' the migration quickly.
• I edit my src/config file to point to my new database.
• Go back on my site - Unexpected Error
• Page source shows - <!-- MySQL statement prepare error [1146]: Table &#039;fgmnewforum.xf_user_remember&#039; doesn&#039;t exist -->
• I go back to server hosts and enter the phpmyadmin and correct - no table there.
• I go to server support and advise them the migration has not worked.
• They say it is a xenforo problem.
• I raise a ticket at xenforo - they say it is a migration error.

Worst part is I dont have a back up. Never thought about it at the time... yes ... my bad. Is there anyway I can rebuild those tables so they are in the new db?

Any help or opinions greatfully accepted.

 

[Vroomm]

I messed up a different way the other day. I did backups but the xenforo files were of newer version and the database of older version. How did that happen? As they say **** happens and it did happen.

There was panic for 20 minutes until I realised what had happened and quickly downloaded older version of XF and phew the forum was back online.

Backup you must but don’t forget there’s database and also the files on disk

 

[MySiteGuy]

Geeze, I just read through this thread. What a mess! Whether they fixed it or not, I'd still switch hosts. All this time and stress, could have been avoided if you had even a fairly decent host with techs who know what they're doing.

A bigger lesson, is to make backups and always have a disaster recovery set downloaded.

Now that it's recovered, and it's no longer salt in the wound, this needs to be said:
The harsh reality is running a forum this long, and not doing something so basic, is negligent. They aren't at fault for what happened to the database conversion, but the "buck stops here" and in the end almost losing would have been the result of not do such a basic thing as occasionally downloading a backup. Pretty much every host has a way to run and download a manual backup.

 

[mjda]

A bigger lesson, is to make backups and always have a disaster recovery set downloaded.

Now that it's recovered, and it's no longer salt in the wound, this needs to be said:
The harsh reality is running a forum this long, and not doing something so basic, is negligent. They aren't at fault for what happened to the database conversion, but the "buck stops here" and in the end almost losing would have been the result of not do such a basic thing as occasionally downloading a backup. Pretty much every host has a way to run and download a manual backup.

Yes, absolutely true! I save full site backups 3 times a week. Absolute worst case scenario for me is I lose two full days worth of content.