Forum search not working for old data.

Involved Joined: Apr 22, 2006 Posts: 356

this is not an RN issue I do not believe so mod please put it in a better place if you so desire. I imported data from a postnuke site into rn2.10.01. The forum tables were almost identical. I have all the data there. I can view the old forums, post to them, everything accept search them. The search feature will only look at the new posts. I am not sure where to look to find the reason or the fix. Crying or Very sad

thanks for any help!

Subject Matter Expert Joined: Feb 23, 2004 Posts: 358

The tables bbsearch_wordlist and bbsearch_wordmatch contain the search information. Postnuke or whatever, the issue is the phpBB tables and whether or not they are matched correctly.

So there's what you need to look for and compare...

PHrEEk

registered · Posted: Mon Oct 15, 2007 5:20 am

Kevin, what a tangled web you are weaving here. Is this all the same site that we've been trying to help you debug? Postnuke to RN?

Well, PHrEEkie has the right idea. It is time for you to get yourself an XAMPP environment local on your PC (if you have not already), install a fresh instance of RN 2.10.01 database into mySQL and then also your current state database, then get mySQLDiff and run a comparison. Until the two match up perfectly on the core tables, you are going to have problems lurking...

Posted: Mon Oct 15, 2007 1:46 pm

Just want to add...

If the old bbsearch tables were not brought over correctly, and your forums are back up running (re: you are able to search NEW posts), then you are going to have a merge nightmare since new bbsearch tables are being populated. If you empty the tables and successfully re-populate them with the old data, now the new posts will not show up in searches. It gets messy real quick, and those 2 tables are inarguably the largest tables in a core Nuke/phpBB database!

A few years back, I believe there was a script running around that would rebuild the search data for phpBB 2.x. If you could find such a beast, that would make your task monumentally easier.

PHrEEk

Posted: Tue Oct 16, 2007 3:38 pm

Thanks guys. It is resolved. When I imported the data from the old site, I broke the db down into sections. I simply had not imported the search table data. Stupid on my part.

You would be suprised to know that there really wasn't much difference in the table structure from pn to rn, at least for the core tables. Basically all they did with the pn db was added "pn" in front of the field names. Most of the changes were a simple find/replace for the field names. The forums were almost identical, just changing the names IE: changing nuke_phpbb_search to nuke_bbsearch and such. there were a couple fields in some tables that I had to drop since rn bb did not use them.

It only took me about 2 hours to go through the pn db and convert what I needed to the rn db. The users table I had to do a bit of work on since I had added cnbya and some other things, just had to add the default values. I used wordpad and find/replace became my friend. The db had over 1000 users, and over 5000 forum posts.

Montego, I have several sites, all running a different version of rn2.10+ and modded a bit different. The biggest issue is with the cnbya mod I got fromfade2gray, but he had debugged most of it. Just the issue with updating the profile. I confess, some if it is my ignorance and sometimes forgetting to complete all the steps.

Thanks again for all everyones help. This site is a godsend.

Posted: Wed Oct 17, 2007 5:47 am

kevinkap, I am just glad you got it all sorted out. Sounds like some project!

One suggestion though is to not use wordpad. It can actually cause other issues. I would suggest using one of the better textual editors such as TextPad or EditPad. I think there are others mentioned throughout these threads too, but my memory is failing me atm.