Rick
Registered: 06/04/06
Posts: 7880
Loc: Aberdeen, WA
Yeah, that happened during one of the old imports, when we merged all of the classic posts with threads on the old 6.x forum. I've been trying to fix the ones I can as I have time.
hehe, know what you mean - I am *still* (since October) fixing the album owners albums on a photography site after upgrading them from threads 6.5.x to 7.x and not knowing they had deleted a few hundred users over the years. *None* of the 120+ categories in photopost matched their actual owner anymore after threads re-bunched up all the member profiles during the import :smashpc: Photopost made available a script to re-align them but only after I had already manually adjusted 30+ albums, rendering the photopost script useless.
#178747 - 02/19/0701:55 PMRe: Old Posts
[Re: AllenAyres]
Gizmo
Registered: 06/04/06
Posts: 11967
Loc: Portland, OR; USA
I'll probably sound dumb, and i'tll probably just throw out a ton of extra queries, but why not leave the old db up, lookup the username on one and compare it to the username on the new forum then change the photopost uid to th enew threads uid? it seems easy enough with a new php script..
Photopost grabs uid from its permission ssystme (assuming it has one here), looks up the login name from the 6.5 db from the uid in th ephotopost table, then takes and looks up the login name in ubb7 and then updates the photopost table... or at least output the new data.
I've been doing that manually now for a few months - there's probably 10-15 out there still not fixed but writing a script to figure it out is a bit over my head.