Forum Overview :: Site Comments
 
started poking at the old posts again by jeep 05/07/2005, 11:18pm PDT
here's what I got:

there are 980 posts with invalid thread IDs. the old database didn't maintain forum ids in the posts table, only thread ids, so I have to match up the ids like "UPDATE posts, threads SET posts.fid=threads.fid WHERE posts.tid=threads.tid;"

Anyway, this fails on 980 posts or so, which leaves them homeless. It looks like the relevant thread entries are just not in the archive I was given. I think I can reconstruct them using the parent, but that's a longer process. For now I may throw those 1000 posts into deleted posts and see if I can get the rest working normally.

/jeep/
NEXT REPLY QUOTE
 
started poking at the old posts again by jeep 05/07/2005, 11:18pm PDT NEW
    threading straightened out, post text next NT by jeep 05/07/2005, 11:48pm PDT NEW
        post format and truncation fixed, 369 bad inline links to go by jeep 05/08/2005, 4:34pm PDT NEW
            Kickass. Thanks for helping out NT by Entropy Stew 05/08/2005, 9:24pm PDT NEW
 
powered by pointy