FUDforum: FUDforum 3.0+ » Recovering Database After Botched Upgrade

Home » FUDforum Development » FUDforum 3.0+ » Recovering Database After Botched Upgrade

Show: Today's Messages :: Polls :: Message Navigator

Re: Recovering Database After Botched Upgrade [message #164392 is a reply to message #164391]

Thu, 03 February 2011 16:42

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma:

Senior Member

jm2morri wrote on Thu, 03 February 2011 09:22

It reports "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)". That seems bad.

James.

Sounds like you took a different route to get there (I'd like to know how) but the end result seems to be the same.

For some reason the 3.0.2 upgrade seems to have a hiccup in it and deletes the user table or does not restore it properly.... At any rate it occasionaly gets gone and you can't log in.

Similar to: http://fudforum.org/forum/index.php?t=msg&goto=164058&#msg_164058

I have had the same problem a few times and to recover I needed to "install the previous version, import the dump, export the fud30_users table from the SQL, and during the recovery process (after upgrade) import them back into the SQL so that I had access to the forum".

Let me know if you regain access,

Considering that you said:
Quote:

Now I was smart enough to do a full dump before I started the install. But I can't figure out what to do with it. The dump was from 3.0.1 and the forum is now (after the upgrade) 3.0.2. I know there were db changes between the two.

You may need to delete the forum entirely, or if you are not comfortable with that create a whole new forum database and all to export the users table, at any rate you MUST import a ver 3.0.1 data dump into a 3.0.1 forum for it to work and then upgrade from there! keep your users table available until you are satisfied.

Read through the whole thread linked above particularly naudefj's recommendation to rerun the upgrade after deleting TV_1.

"I'm a Witcher, I solve human problems; not always using a sword!"

Report message to a moderator

[Message index]

		Recovering Database After Botched Upgrade By: jm2morri on Wed, 02 February 2011 18:14
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 01:36
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 10:38
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 11:20
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 15:22
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 16:42
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 18:48
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 19:49
		Re: Recovering Database After Botched Upgrade By: jm2morri on Thu, 03 February 2011 20:24
		Re: Recovering Database After Botched Upgrade By: The Witcher on Thu, 03 February 2011 20:59

Previous Topic:	Condensed Categories displaying "opened" when clicked
Next Topic:	Lost Forum Group "+" and "-" Image to Expand and Collapse Forum Category

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 02:51:04 GMT 2024

Total time taken to generate the page: 0.04921 seconds