HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


[ANSWERED] In what database is post information stored?

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#66467 (In Topic #14188)
Avatar

Community saint

In a quest to create archives, books are found, all with blank pages.

Greetings,

I had decided to attempt to create an archive board, so to speak, on my site before I open it back up. You see, with 6 beta 2 and following the unlucky events that transpired over Christmas, I decided to build the site back up from scratch, only really importing the members (which all worked well). It was actually good timing to, considering that we werein the middle of a big overhaul on what our site has to offer and the forum based RP was getting a complete change up. This way it could all be done, without bringing in too much of the old cruft from the old databases and such.

I have most things set up to where I can open the site but not yet take part in anything on the site, sort of so that my members can at least see that work is being done.

That is until now when I had the not so brilliant idea of "Hey, why let those brilliant old stories go to waste? Lets make a read only forum archive where those old stories can still be read!"

So, I created a zone and a virtual rooted forum for it. Success!
I then painstakingly searched through my older database backup file (using Kate of course), and pulled out what I thought should do the job to populate the new database, that being ocp4_f_forums, ocp4_f_posts, and ocp4_f_topics. I ofcourse made use of kate's find and replace function to replace all instances of ocp4 with ocp6 and norova.net with legendsofnorova.com.

Once the database was populated, I set up the forums and ran the ocp maintence tools. I even ran the upgrader tool for good measure. However once I checked the forums, the links were all tehre, even to the private topics (which I intend to erase lol), and even with  the last edited date and such, but there was no content within the posts.

Odd, I though, so I scoured the database till my eyes bled, and found what looked like post data in ocp4_stats. So I populated the database with that (replaceing the url and ocp4 with the correct info), ran the tools, and took another look. Still empty.

So, the question is, where is the post data stored? I can't seem to find it, and I have looked lol. I have looked for 2 days now lol. 


Last edit: by mythus

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#66469
Avatar

'translate'

But I would be very wary of just copying data over. I suppose as long as you don't overwrite any conflicting ID's then run the orphaned language strings cleanup tool, it has a reasonable chance of working.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#66471
Avatar

Community saint

AH…

Well, this sucks then. It seems for some odd, unknown reason all of my backed up databases stop at ocp4_stats. Which is odd, considering that I know I have restored from backup database at least once before.

It especially sucks since for some reason the restore.php file from the ocPortal-made backup i have simply refuses to function. So even more yay.

It's a good thing I am not dependent upon any backup information lol. It sure would have been nice to provide those archives. I suppose the dark gods of Yahell have decided that it was not in their best intrest to permit this operation.

I've worked on this particular idea far too long and too hard. I need to get my site back up and producing stories, role playing fun, and maybe even some monies to pay for hosting and whatnot. So, I suppose I'll put this on the back burner, and mark this topic as answered. After all, I now know where it is stored…

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: