BB to Nuke

Involved Joined: Oct 09, 2006 Posts: 413 Location: UK

I know this is a subject that manages to flumox a lot of people, but ive read lots on this and tried allsorts; with no joy.

I transferred all of our database to a new, fresh db on the same server using phpMyAdmin.
I checked carefully that i moved all of the previous Nuke_bb_ tables across. Then after setting up Ravennuke 76, i used the 'resync' buttons in the PhpBB admin. Now the problem is.. The forums show the topics with the correct usernames and number of replies etc etc, but when i click on them, it says 'no post exists for this topic'
What could be causing this? I assume that because all of the db info was already in nuke_BB tables, that we were already using bb2 nuke.

Sells PC To Pay For Divorce Joined: Posts: 5661

well it misses somehow the posts...,or its count off....
this can easely be solved by checking all your phpbb tables and convince yourself all data is imported/transfered...

Posted: Sat Nov 04, 2006 4:50 pm

well it would seem to be all there, but something is telling it that the info isnt there. Am i missing some simple but important detail?

Posted: Sat Nov 04, 2006 4:56 pm

yes...trust me on this...
compare the tables ...old with the new...you will see what you missed....

Posted: Sat Nov 04, 2006 4:58 pm

how do u mean compare? do i have to read every line of every table?

Posted: Sat Nov 04, 2006 5:02 pm

well i think in the tables topic or postings something like that...
ive done a lot of this work...
as soon as you forget something bb is completely blind....

so yes.....
i know its a lot of tables but as soon as you forget somes rows and its content the forum is dead...
it shows the total posts etc....but inside it doesnt show any content....
check your tables of the forum.....

Posted: Sat Nov 04, 2006 5:03 pm

ok i kinda get the idea m8..Man Hitwalker ur quick on the replies Cheers

Posted: Sat Nov 04, 2006 5:05 pm

well thats what support is about huh.... Laughing

Posted: Sat Nov 04, 2006 5:07 pm

jeesh..slow down m8

But yeh it is good and i really thank the guys here, including yourself..for providing a reliable nuke and being there when us newbs screw it up.

Thankyou

Posted: Sat Nov 04, 2006 5:11 pm

well if you screw it up thats fine..... Wink

your allowed to do that once.....
but we do hope you learn from it......
next time you will be helping someone else..... Laughing

Posted: Sat Nov 04, 2006 5:16 pm

oh i have learnt a lot. Basically i was dropped in as admin by default, at once i decided our nuke was crap and very unreliable, very susseptable to hacks so i toured around and found RN76 to be the best. Et Voilla i am here, just the major stuff like this thats screwing me, all the modules,block stuff ive fixed. However as a site, the owners would like there old posts back.

Posted: Sat Nov 04, 2006 5:25 pm

well take your time....rome wasnt built in one day...
and after you found and fixed it,you will be the hero... Wink

Posted: Sun Nov 05, 2006 5:25 pm

Well..as usual Hitwalker you were correct Very Happy

The nuke_bbposts_text table didnt import properly (maybe due to its size)

What i did to fix...
1/ closed the forums
2/exported the current data to my old database (using the 'add if not exists' and update functions)
3/exported the old nuke_bbposts_text table using the same criteria. Into my new db
4/ re-opened the forums

The reason for closing them is quite simple, you do not want people posting if you are trying to match up data, because there topics will only get lost.

Hope that may help others.

Posted: Sun Nov 05, 2006 5:27 pm

nice to hear that......
so feels good huh...solving it.... Wink

Posted: Sun Nov 05, 2006 5:29 pm

d*** yeh, its been a problem hurting me for a while now. 43761 queries imported. Thats a lot of data, too much to simply give up on.

Posted: Sun Nov 05, 2006 5:32 pm

Well done!
And thanks Hit for for the guidance Smile

Posted: Sun Nov 05, 2006 5:32 pm

yes it is.....
backup your site when done...

Posted: Sun Nov 05, 2006 5:35 pm

hahaha, just requested a full backup too lol

Posted: Mon Nov 06, 2006 3:32 pm

How did you move the tables?
Did you use a database converter like mine? [ Only registered users can see links on this board! Get registered or login! ]

I haven't used it to upgrade to RavenNuke specifically, but it generally does a good job with it. Otherwise, it will give you the error messages you need to debug the tables.

Posted: Mon Nov 06, 2006 8:35 pm

well i did it the only way i thought it could be done. The good old fashioned phpMyAdmin and notepad trick. One by one, piece by piece. A little tedious though with 197 tables in our old db.
I will look into your converter though, anything to make my life easier kaching!