So, the conversion from access to mysql appeared to go well.  As far as I know, the only thing that is not working is the Search function.  It just returns "Search Error" and "No Results Found".  Any ideas where to look? Maybe I am overlooking something?

 

Any help appreciated!

 

 

 

 

I wanted to keep my search issue seperate from the conversion thread.

 

http://www.equestrianpages.com/forum/ - http://www.equestrianpages.com/forum/

 

 

Still nothing.

 

Odd...

 

I just checked the other one that I converted from version 7 access to version 9 mysql

 

Same thing

 

http://www.ufovidmag.com/forum/ - http://www.ufovidmag.com/forum/

 

Both are running on the same Web server (IIS5) and mysql server (FC7 mysql 5.xx).

 

Then I stopped the ufovidmag.com site, stopped and restarted IIS.  No change.

 

It's Windows2000 IIS5 (I know its old), so not 100% sure on the Application Pool configuration, its set to Default Application in the Home Directory tab.  I've never touched it before.  Scripts Only execution, Medium Pooled for Application protection.  I have the performance bar set to 10,000 or less a day (all the way to the left).  Doubt that has anything to do with it.  Just trying to give you as much info.  Appreciate the help.

 

Its gotta be something server wide it seems or something similar to the configuration of each site.

 

I tried renaming the global.asa file and doing a search, but I didn't stop and start IIS while doing so.  Going to give that at try and see.

 

The current global.asa file just appears to have FrontPage db setups from when I was learning how to do basic ASP stuff.

 

Is there a test search query that I can use in mysqladmin or Navicat to run on the database and see what sort of output (or not) is given?  I tried to look through to code and see if could have been simple, but it appears to be quite a complex query.  Maybe with something like 'horse' in it, as that should produce a lot of hits in the equestrianpage.com forum.

 

I'm almost leaning towards the possible conversion from Access to mySQL?  Maybe character set issues, like a character that was valid in the Access database isn't in mySQL?  Though I figure Navicat would have said something about that?  Strange though, when converting the database to mySQL, the database itself seemed relatively simple and straight forward.

 

The only "strange" occurance that I have noticed beyond the search not working, is in the ufovidmag forum, the "UFO->General Disscussion" forum is displayed before the "UFOVIDMAG->General Discussion".  So it would be UFO->General Discussion, then UFOVIDMAG->General Discussion, then UFO->Yakima, then the rest of the UFO area, and the rest of the forums in proper order.  I wonder if that is it. I need to re-order the forums?

 

When I click within one of the forums, then go back to the Forum Home, it is displayed correctly.  I'd say this happens about once every ten times I view the Forum Home.  I have not observed this behavior on the equestrianpages.com forum at all.

 

I am using the latest mySQL ODBC that I downloaded and installed prior to the database conversion, update(s).  The week of August 12th.  I hope I am not sending you off on unrelated stuff.

 

Searching for text within new posts (after the migration to mysql) does not work.  Same result.

 

 

 

Bizarrely, another problem manifested itself as well.  I was getting an 800029 Exception at Line 581 in register.asp when a new user would sign up.  Looking through the code, this referenced the Group tables.  I checked out the table via Navicat to make sure that there was no corruption of data (obvious corrupt).  I didn't think there was any since the rest of the forum appears to function properly.

 

So what I did, was I went through each Group setup, and just updated them all.  Didn't make any changes, just went through the motion of updating each one.

 

Then to make sure that I actually made changes to the database entry for the default group, I briefly changed it from one to another.

 

This fixed the sign up error and now users can sign up.

 

And bizarrely enough, the search now functions!

 

GOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOALL!

 

It appears that the database conversion from Access to MySQL using the NaviCat method, you have to get the program to 'update' the database fields at least one time for them to really kick in.  I think I've had to do this for most every type of setting, but it works and I am so very happy that I made the switch.

 

Word to the newbies... Do not go down the Access DB path.  I can understand us cabbage patchers that have been using WebWiz since the dinosaurs, but it's like buying a Lamborghini with a lawn mower engine.

 

Thanks DJ Air and Borg for the time you put in to this odd issue.

We are recieving the following meessage:

 

Search Error

No Search Results Found

 

Only new posts show up in the search results.

 

I tried to update the forum details in the admin section but that did not work.

 

This wasn't my problem.  The search never worked for old or new posts.  I suspect that you are having more of an issue of what Borg mentioned in this thread.

 

I used the Navicat For MySQL method to convert Access to mySQL with default US English installs of all software.