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.

 

[JustinHawk]

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.

Is there any table available in database or it is missing just one table ?

 

[forumSolution]

Is there any table available in database or it is missing just one table ?

Yes same question i was going to asked

 

[Old Nick]

Worst part is I dont have a back up. Never thought about it at the time... yes ... my bad

Your host don't have a backup? Sometimes it is automated.

 

[Paul B]

I raise a ticket at xenforo - they say it is a migration error.

As I responded in your ticket, missing tables after upgrading mysql are definitely a server/host issue.
XF has no involvement with that.

You can recreate the missing table using the parameters I provided but there will be content missing.

Also, there may be other issues so restoring from a backup is the recommended course of action.
Anyone running a site should ALWAYS, ALWAYS take a backup regularly and definitely before doing any server work or XF upgrades.

 

[Shane Greer]

Is there any table available in database or it is missing just one table ?

The rest of the tables seem to be there.

 

[Shane Greer]

As I responded in your ticket, missing tables after upgrading mysql are definitely a server/host issue.
XF has no involvement with that.

You can recreate the missing table using the parameters I provided but there will be content missing.

Also, there may be other issues so restoring from a backup is the recommended course of action.
Anyone running a site should ALWAYS, ALWAYS take a backup regularly and definitely before doing any server work or XF upgrades.

Yeah I pretty much figured it was a migration issue. No idea why they say it is a software issue. Will check if they have a back up.

 

[Old Nick]

Do you have access to your ACP?

 

[JustinHawk]

Yeah I pretty much figured it was a migration issue. No idea why they say it is a software issue. Will check if they have a back up.

Well you can dm me if required, i can help you in fixing the issues. Had faced such issues many times. I will see what can be done.

 

[Shane Greer]

No... my forum page just throws up Unexpected Error.

 

[Paul B]

In your ticket you reported the session table as missing.
This is a different table so that's at least two tables.

The parameters for the xf_user_remember table are:

xf_user_remember

addColumn('remember_id', 'int')->autoIncrement();
addColumn('user_id', 'int');
addColumn('remember_key', 'varbinary', 32);
addColumn('start_date', 'int');
addColumn('expiry_date', 'int');
addUniqueKey(['user_id', 'remember_key']);
addKey('expiry_date');

 

[Shane Greer]

Yeah JustinHawk has had a look and the db now is virtually useless as the migration has not carried over any of my user tables either. What a screw up.

 

[Paul B]

Why did the host not take a backup before upgrading mysql?

 

[Shane Greer]

Yes I have asked that question as it appears they deleted the old db after the migration when they should have left it.

 

[Shane Greer]

If the worst case scenario is that it is flummoxed how easy is it to just run a new install of xenforo and start again from scratch with 2.3?

 

[Paul B]

It takes a couple of minutes to install XF.

However, it may be worth seeing if the deleted database files can be recovered - there are tools to restore deleted files but it's likely going to be a lot of work and possibly not successful.

 

[Shane Greer]

I will see what they come back with and then decide.

 

[Slavik]

it appears they deleted the old db after the migration

Time for a new host.

The level of ineptitude shown here is criminal.

No backups? No verification of a complete transfer? Deleting data. You should name and shame.

 

[Old Nick]

No backups? No verification of a complete transfer? Deleting data.

Difficult to do worse.

 

[Shane Greer]

And Im still waiting for them to reply. So in the interim if I wish to reinstall my forum what is the best way to go about a fresh install that could use the same url as the old one?