rbarrow
  • Posts: 43
  • Joined: 19/09/2013
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
  • Posts: 1082
  • Joined: 26/04/2011
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
  • Posts: 43
  • Joined: 19/09/2013
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
  • Posts: 1082
  • Joined: 26/04/2011
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
  • Posts: 43
  • Joined: 19/09/2013
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
  • Posts: 4079
  • Joined: 06/03/2010
Did you enabled both full text search checkboxes? The one on the install wizard and the one in the host settings?
UserPostedImage
rbarrow
  • Posts: 43
  • Joined: 19/09/2013
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
  • Posts: 4079
  • Joined: 06/03/2010
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
  • Posts: 43
  • Joined: 19/09/2013
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
  • Posts: 63
  • Joined: 07/06/2004
I do have this issue also. Is there a solution for this?
MJK
Zero2Cool
  • Posts: 1082
  • Joined: 26/04/2011
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.
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

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