Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
wiz
Involved
Involved


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

PostPosted: Sat Nov 04, 2006 9:58 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website AIM Address
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Sat Nov 04, 2006 4:37 pm Reply with quote

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...
 
View user's profile Send private message
wiz
PostPosted: Sat Nov 04, 2006 4:50 pm Reply with quote

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?
 
hitwalker
PostPosted: Sat Nov 04, 2006 4:56 pm Reply with quote

yes...trust me on this...
compare the tables ...old with the new...you will see what you missed....
 
wiz
PostPosted: Sat Nov 04, 2006 4:58 pm Reply with quote

how do u mean compare? do i have to read every line of every table?
 
hitwalker
PostPosted: Sat Nov 04, 2006 5:02 pm Reply with quote

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.....
 
wiz
PostPosted: Sat Nov 04, 2006 5:03 pm Reply with quote

ok i kinda get the idea m8..Man Hitwalker ur quick on the replies Cheers
 
hitwalker
PostPosted: Sat Nov 04, 2006 5:05 pm Reply with quote

well thats what support is about huh.... Laughing
 
wiz
PostPosted: Sat Nov 04, 2006 5:07 pm Reply with quote

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
 
hitwalker
PostPosted: Sat Nov 04, 2006 5:11 pm Reply with quote

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
 
wiz
PostPosted: Sat Nov 04, 2006 5:16 pm Reply with quote

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.
 
hitwalker
PostPosted: Sat Nov 04, 2006 5:25 pm Reply with quote

well take your time....rome wasnt built in one day...
and after you found and fixed it,you will be the hero... Wink
 
wiz
PostPosted: Sun Nov 05, 2006 5:25 pm Reply with quote

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.
 
hitwalker
PostPosted: Sun Nov 05, 2006 5:27 pm Reply with quote

nice to hear that......
so feels good huh...solving it.... Wink
 
wiz
PostPosted: Sun Nov 05, 2006 5:29 pm Reply with quote

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.
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Sun Nov 05, 2006 5:32 pm Reply with quote

Well done!
And thanks Hit for for the guidance Smile
 
View user's profile Send private message Send e-mail
hitwalker
PostPosted: Sun Nov 05, 2006 5:32 pm Reply with quote

yes it is.....
backup your site when done...
 
wiz
PostPosted: Sun Nov 05, 2006 5:35 pm Reply with quote

hahaha, just requested a full backup too lol
 
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Mon Nov 06, 2006 3:32 pm Reply with quote

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.

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
wiz
PostPosted: Mon Nov 06, 2006 8:35 pm Reply with quote

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!
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©