rbarrow
  •  rbarrow
  • 82% (Honored)
  • YAF Lover Topic Starter
2015-08-13T03:18:40Z
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
Sponsor
Zero2Cool
2015-08-13T12:27:01Z
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
  •  rbarrow
  • 82% (Honored)
  • YAF Lover Topic Starter
2015-08-13T13:33:20Z
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
2015-08-13T17:39:25Z
Originally Posted by: rbarrow 

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.
rbarrow
  •  rbarrow
  • 82% (Honored)
  • YAF Lover Topic Starter
2015-08-13T18:04:16Z
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
2015-08-13T19:40:26Z
Did you enabled both full text search checkboxes? The one on the install wizard and the one in the host settings?
UserPostedImage
rbarrow
  •  rbarrow
  • 82% (Honored)
  • YAF Lover Topic Starter
2015-08-13T20:06:27Z
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
2015-08-13T22:06:46Z
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.
UserPostedImage
rbarrow
  •  rbarrow
  • 82% (Honored)
  • YAF Lover Topic Starter
2015-08-14T11:43:42Z
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
2016-05-26T14:46:01Z
I do have this issue also. Is there a solution for this?
MJK
Zero2Cool
2016-05-26T14:48:05Z
Originally Posted by: Mariette 

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.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved