Double Posts Double Posts

They have: 6 posts

Joined: Jul 2000

It looks like you had trouble converting from UBB to vB. Did you double up members also? I had that problem and found I needed to delete everything from vB and start over again. When I started over I went forum by forum and did the conversion at a SLOW rate so that the process would never stall. The double posts occur after you restart during a stalled conversion.

Rick Horwitz
explorer4x4.com

Justin S's picture

They have: 2,076 posts

Joined: Jun 1999

It looks like you're correct Rick. But all the Admins are busy around here so nothing gets done too quick. I have lots of time, but don't have the power (AKA: Admin)...

Denmark 3's picture

They have: 881 posts

Joined: Feb 2000

The double member problem has been fixed it looks like.

They have: 2,390 posts

Joined: Nov 1998

yep, double member post has been fixed. And we have a script to fix the double posts (thanks to some tremendous support from VB John). Patrick will try and run it later today.
JP

Justin S's picture

They have: 2,076 posts

Joined: Jun 1999

Cool. Sounds good...

He has: 32 posts

Joined: Mar 1999

Small update:

So far I found out, the MySQL Database doesn't just duplicate the threads, but also give them some new IDs and stuff which makes it even worse.
The only way I can think of is to dump the whole database in flat-text, parse it thru a script and restore the database. Anyway this will result in a small period of approx. one hour when nobody will be able to post. So I'll probably better do it tomorrow morning when all of our US-visitors are asleep Smiling

Or is somebody else here having a better idea?

later

http://www.patrickbaer.com
Professional Photo Retouching Services

Justin S's picture

They have: 2,076 posts

Joined: Jun 1999

Sounds good to me Patrick, although probably not to you Smiling Thanks for all the help...

They have: 6 posts

Joined: Jul 2000

I already told you what worked for me when I had the same problems Laughing out loud

He has: 32 posts

Joined: Mar 1999

Rick, do you know how many posts we would lose if I'd just do a fresh import of the UBB data?

They have: 6 posts

Joined: Jul 2000

Ah, yes... You've been running this forum like that for a while. I deleted my double posts and members before I went live.

They have: 2,390 posts

Joined: Nov 1998

righto all done! At last...
JP

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.