Rollback / Re-install mlf 2.4.6 with backup fails (General)

by BlindFish1003, Saturday, March 19, 2022, 09:06 (191 days ago)

Hi there,

i ran into some issues after upgrading from 2.4.6 to 2.4.24 and decided to go back to 2.4.6.

A full backup was created before upgrading.

First attempt was to restore the backup on the 2.4.24 installation, but this stopped with an error message.

Second attempt was a clean installation based on 2.4.6 with a new and empty database. This worked as expected. However, the restore of my backup failed again with an error that a table or column would not exist. Unfortunately, i didn't write it down immediately.

Any ideas how i can get my forum back up and running?

Rollback / Re-install mlf 2.4.6 with backup fails

by BlindFish1003, Saturday, March 19, 2022, 10:24 (191 days ago) @ BlindFish1003

So, i got one step closer getting this issued solved.

Actually i expected the phpmyadmin or the built-in mlf recovery to create the required tables itself what it did not. And because the table prefix was different on the new database and the one backed up, i had this problem.

The import however fails when inserting the user data.
The table created on install seems to have more values than there are in my backup which is strange as i was running 2.4.6 and chose the exact same version for my plain installation.

As the backup file only contains the insert statements, it is hard to tell which values are missing in my sql dump. But from counting i can tell that there is a difference of only one value.

Rollback / Re-install mlf 2.4.6 with backup fails

by BlindFish1003, Saturday, March 19, 2022, 12:17 (191 days ago) @ BlindFish1003

I cannot delete this topic so i'll post the solution which seems to work for me:

By comparing the data in the various fields it turned out that the userdata table in my backup was missing the entries_read column. After deleting it, the import passed through smoothly and i re-created the column manually.

I have absolutely no idea why there was a difference for the new and backed up data, both claiming to be version 2.4.6.

Avatar

Rollback / Re-install mlf 2.4.6 with backup fails

by Auge ⌂, Saturday, March 19, 2022, 18:02 (191 days ago) @ BlindFish1003

Hello

By comparing the data in the various fields it turned out that the userdata table in my backup was missing the entries_read column. After deleting it, the import passed through smoothly and i re-created the column manually.

I have absolutely no idea why there was a difference for the new and backed up data, both claiming to be version 2.4.6.

There was versions with a broken backup function because of table columns, that got introduced in a new version but was not added to the backup [edit]and restore[/edit] function[edit]s[/edit]. But the column for the read entries, that once existed in the user data table (entries_read) was there since ages, so I doubt, that this is a case of a forgotten table column.

On the other hand I doubt, that the backup with the list of read entries in the user data table was made with MLF version 2.4.6. This, because we introduced the new function for storing read entries in a dedicated table back in MLF version 2.3.99.2 (that was the first public beta version for MLF 2.4) and removed the column entries_read from the user data table at that point. A backup with the column mlf2_user_data.entries_read should have been created with an older version than 2.3.99.2.

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!

RSS Feed of thread