Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: rbarrow - Thursday, 13 August 2015 05:18:40
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

Posted by: Zero2Cool - Thursday, 13 August 2015 14:27:01
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.

Posted by: rbarrow - Thursday, 13 August 2015 15:33:20
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.....

Posted by: rbarrow - Thursday, 13 August 2015 15:33:20

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

Posted by: Zero2Cool - Thursday, 13 August 2015 19:39:25
[quote=rbarrow;66188]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..... [/quote] 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.

Posted by: Zero2Cool - Thursday, 13 August 2015 19:39:25

[quote=rbarrow;66188]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..... [/quote] 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.

Posted by: rbarrow - Thursday, 13 August 2015 20:04:16
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.

Posted by: tha_watcha - Thursday, 13 August 2015 21:40:26
Did you enabled both full text search checkboxes? The one on the install wizard and the one in the host settings?

Posted by: rbarrow - Thursday, 13 August 2015 22:06:27
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....

Posted by: tha_watcha - Friday, 14 August 2015 00:06:46
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.

Posted by: rbarrow - Friday, 14 August 2015 13:43:42
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?

Posted by: rbarrow - Friday, 14 August 2015 13:43:42

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?

Posted by: Mariette - Thursday, 26 May 2016 16:46:01
I do have this issue also. Is there a solution for this?

Posted by: Zero2Cool - Thursday, 26 May 2016 16:48:05
[quote=Mariette;67029]I do have this issue also. Is there a solution for this?[/quote] Try deleting the full text catalog and rebuild it by running the /install for YAF. That got mine working.

Important Information: