SMF Support > SMF 1.1.x Support

Forum Dead - Corrupt tables , unable to repair or restore.... HELP!

<< < (11/11)

ModelBoatMayhem:
Errors restarted 1 second after enabling 'Error reporting'.

Guest Today at 00:30:53 180.76.5.165    e6b9ba1b4e1ce196506821fe2f44ae03 http://www.modelboatmayhem.co.uk/forum/index.php?topic=19393.msg188535 512: loadMemberContext(): member id 5234 not previously loaded by loadMemberData()
File: /home/mbmayhem/public_html/forum/Sources/Load.php

MrPhil:
I suspect that the problem is that the database tables were not updated or restored in sync. My understanding is that an old members table is in use, with lots of members readded (under different IDs than before), and other tables assume different member IDs than are now provided. In other words, a right fine mess!

ModelBoatMayhem:
OK, seems like I've reached stalemate...

Do I really annoy everyone that rejoined and loose all the new post or risk reinstating the old membership that I don't know if it will work... hmmmm......  :(

Did you mention there may be a way of manually connecting old memberships to new ones, where could i find information about that please?

 

MrPhil:
Well, back up the entire database so that if things go terribly wrong, you can roll back to where you are now. I wouldn't think that people who rejoined would be terribly annoyed at being restored to their old settings, so long as they have their posts, etc. At worst, they'll have forgotten their old password and will need to ask for a new one (password restore). Completely new members will have to rejoin (sorry about that!). Perhaps you can make a list of all new members and manually add them (they'll have to request new passwords). As for lost posts, perhaps you can manually cut and paste in the new ones as new posts (I wouldn't try inserting them directly into the database), if you can match them up to existing (old) user names. Worst case, they'll be lost for good (although still available in the .sql backup). It will be a lot of manual labor to do that, so think carefully before proceeding.

Keep the forum in maintenance mode ($maintenance = 1) until you (admin) have looked around a bit and are certain that things are working smoothly, before letting in the other members. If you still get those errors (no improvement), restore the latest database backup that you just took, and we'll have to look around for some other cause.

As for "manually connecting old memberships to new ones", you're asking about reconciling a re-added member who has a different member ID than they used to have? I suppose that you could go directly into the database (phpMyAdmin) and UPDATE each message posted by NewID to be posted by OldID. That might be feasible, and would avoid losing recent posts. Don't forget to add in new-new members and update their messages and PM's in a similar manner (note that their messages may end up assigned to an old member, if they were assigned a member ID that was in the old database. You would have to look at the timestamp on a message to see if its associated member ID is an old one or a new one... very messy). Again, a lot of work -- is it worth it? Offhand, I don't know if there are additional items tied to member IDs beyond messages, topics, and PMs -- there may be.

It may just be easiest to restore the whole system to a recent, complete backup and let the chips fall where they may (and consider it a lesson learned to back up frequently and verify that your backup is good!).

Navigation

[0] Message Index

[*] Previous page