On my DNN install with SQL 2012 I have the full text feature installed and in YAF, I have use SQL Full Text checked.

ALL searches fail...I get no results. Disabling the Use SQL Full Text option does give me SOME results but not all.

How can I get SQL Full Text working?

Thanks,
Roy

I believe I had a similar issue and I had to delete the full text catalog or index, whatever it was called and then run /install and make sure full text was checked.

Had already tried re-indexing DNN....but seems to have no effect on YAF.

I ran rebuild on the YAF FT catalog in SQL....no effect

Not sure what you mean you had to run install...??? SQL or YAF? You do run install on SQL to enable FullText...but that was already done. If you are talking about YAF, I have HOURS of work in laying out these forums...I would be afraid running YAF install would cause issues...

Just unclear on what you think I need to do to make this work.....

Had already tried re-indexing DNN....but seems to have no effect on YAF.

I ran rebuild on the YAF FT catalog in SQL....no effect

Not sure what you mean you had to run install...??? SQL or YAF? You do run install on SQL to enable FullText...but that was already done. If you are talking about YAF, I have HOURS of work in laying out these forums...I would be afraid running YAF install would cause issues...

Just unclear on what you think I need to do to make this work.....

If you have deleted the YAF Full Text catalog or index (not sure which it is called) on your SQL database you need to run the YAF /install to rebuild it.

if you're worried about causing issues, make a full backup of your site and database.

I confirmed that SQL Full Text is installed at the SQL 2012 server. Deleted the YAF catalog from the database and then reinstalled YAF in DNN. ( I made plenty of backups!....)

Still broken....YAF without the SQL Full Text checked...works fine....with the Use Full Text option...it does not work...no errors...just no results.

Did you enabled both full text search checkboxes? The one on the install wizard and the one in the host settings?

Install wizard? Never saw anything about it in the standard DNN module install process. I did check the box in the host settings.

If you are talking about the sql 2012 install wizard then yes....

no i mean the install/upgrade wizard which starts after you install a new version and visit the forum the first time. You can also run the wizard manually from within the admin menu under Upgrade > Install.

OK...NOW I understand what you mean and yes...I checked it when I installed and ran it again and checked it.

Just to note a few things:

The FT index catalog IS created (YAFSearch) but it has 0 unique key count and 0 item count....in other words it isn't indexing anything. I also have another module on this site (DigArticle) that uses SQL FT and it is working just fine.

So it appears that the issue is the the YAF code is not initiating the process...

Anything I can do?

I do have this issue also. Is there a solution for this?

---

I do have this issue also. Is there a solution for this?

Try deleting the full text catalog and rebuild it by running the /install for YAF. That got mine working.