SQL Full Text Search not working · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

rbarrow
82% (Honored)
YAF Lover Topic Starter

9 years ago

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

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

9 years ago

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.

rbarrow
82% (Honored)
YAF Lover Topic Starter

9 years ago

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.....

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

9 years ago

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

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

Originally Posted by: rbarrow

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.

rbarrow
82% (Honored)
YAF Lover Topic Starter

9 years ago

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.

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

9 years ago

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

rbarrow
82% (Honored)
YAF Lover Topic Starter

9 years ago

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....

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

9 years ago

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.

rbarrow
82% (Honored)
YAF Lover Topic Starter

9 years ago

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?

Mariette
78.4% (Friendly)
YAF Commander

8 years ago

#10

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

MJK

Zero2Cool
100% (Exalted)
YAF Leader YAF Version: YAF 3.1.16

8 years ago

#11

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

Originally Posted by: Mariette

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

Important Information: