[deleted] Also please have a look at the db screenshot of all the tables I have and see if u can spot anything missing or anything that shouldn't be there.
Unfortunately I have no time to solve this for you, but this is what I would do:
- First, I would install a beta 2 version of flarum, with its own independent directory and its own independent database, both different from any other you already have. Name it FLARUM_B2. Install it with the minimum settings, just enough to make it work. What you want to have is a vanilla, almost empty DB.
- Second, I would install a beta 5 version of flarum, with its own independent directory and its own independent database, both different from any other you already have. Name it FLARUM_B5. Install this with the minimum settings just enough to make it work. What you want to have is a vanilla, almost empty DB.
I can see you have the capacity to run phpmyadmin, so now in it you should have everything you need to work out what is really different in terms of tables between the 2 versions of Flarum.
This is what you should have now available in phpmyadmin:
- Your compromised DB
- The vanilla flarum beta 2 DB (FLARUM_B2)
- The vanilla flarum beta 5 DB (FLARUM_B5)
BACK UP YOUR DATA NOW, ALL OF THEM .
This is also something (do not take it personal) you should have done immediately before starting the update of flarum which failed. If you had a backup of your flarum beta 2 DB you wouldn't be in this position now, sorry.
Let' s continue. What you need to do now is comparing the tables by hand, one by one, especially the ones where you have all the important data you mentioned. Try to understand the differences between the tables in the 2 vanilla DB you just created
Once is clear how the DB of flarum Beta 5 is structured, carefully manually fill in the data you need to migrate to beta 5, copying them from the compromised/broken DB.
Maybe it will be possible to do an export of certain tables in SQL format from the compromised DB, then do some adaptation by hand in the SQL file, and finally importing them into FLARUM_B5 DB.
There is, in my honest opinion, no other way.
This is website management 101:
- Back up your data before any data manipulation/version update
- Back up your data before any data manipulation/version update and move the backup somhere else
- Try to avoid jumps between non sequencial versions
- Read carefully the upgrade instructions many times.
- If you made a backup and things get screwed up, you can always restore and retry.
I hope it helps and also, respectfully, teaches a lesson.
