PDA

View Full Version : Do I have data corruption?

Ted
Sat 4th Nov '00, 12:53am
I converted from UBB to vB last week. A little less than 10,000 posts at the time. All seemed well. But I noticed a thread today (that has three posts in it - one of them mine) where my Username in the authour column is blank. And the other two posts in the thread, which are by the same author, are attributed to the wrong author! Is my vBulletin on the verge of a collapse? Or is this just something that happens in threads from time to time? Thanks.
Ted
Sat 4th Nov '00, 1:07am
Just to clarify... I have now noticed that there are lots of posts with my username blank in the author column. And I have noticed other threads with author names incorrect. (uh oh) :(
Fquist
Tue 7th Nov '00, 2:39pm
Just bringing this to the top since he asked an important question. ;-)
werehere
Tue 7th Nov '00, 2:49pm
I am just guessing here, but I would imagine this was due to the import, and probably is not a corrupt database.

I know I had some on my forums that showed moderators as guests, and a couple blank as well, after UBB import. It turned out that it was simply some import errors, and not a corrupt Mysql database.
Ted
Tue 7th Nov '00, 3:22pm
Thank you Fquist! You da man! (or da woman, whichever the case may be :) )


werehere, so then I probably should not be worried about compounding any problems by upgrading to 1.1.4?

And also please, I noticed that the upgrade instructions recommend making a backup of data before attempting to upgrade, using a script such as phpMyAdmin. Is this really a "must-do"? Reason I ask, the phpMyAdmin installation itself seems rather involved, so I was trying to gauge the importance of the backup procedure before plunging deep into the phpMyAdmin installation.

Thanks.
werehere
Tue 7th Nov '00, 4:59pm
I would highly recommend backing up your data, not only before an upgrade, but that as well!

PhpMyAdmin really is easy to install, just use the same information that vbulletin requires for the configuration. That should work. It is also very easy to do a backup if you have telnet!
Chris Schreiber
Tue 7th Nov '00, 5:04pm
Originally posted by werehere
That should work. It is also very easy to do a backup if you have telnet!

I wrote a little script to do backups via telnet/SSH over here: http://www.vbulletin.com/forum/showthread.php?threadid=4256

I'd also highly recommend installing phpMyAdmin, I use it everyday for various db admin tasks :)

-Chris