Active Forums 5.1 Release Candidate 3 Posted

Nov 27, 2013 at 4:33 AM
Just posted the latest release candidate build. This includes several important fixes. A big thanks to those of you who helped track down the search bug and to Chris for fixing it.

Downloads:

GitHub: https://github.com/jbrunken/ActiveForums/releases

CodePlex: https://activeforums.codeplex.com/releases/view/115273

Note: If you are using full text search, be sure to go into the Forum Settings and toggle the full text search off then on again. This will ensure that you get the updated search procedures installed in your database.

I'm very hopeful that this will turn out to be the first production approved release since 5.0.3.

As always, any feedback is appreciated.
Nov 27, 2013 at 4:34 AM
Installing now

Thanks!!!
Nov 27, 2013 at 5:06 AM
Hopefully you grabbed 5.1.2. I forgot to remove 5.1.1, so it was still there for a few minutes after I made this post.
Nov 27, 2013 at 10:13 AM
HI:
Installed in 7.1.2 and still not having access to languajes: https://activeforums.codeplex.com/discussions/470689

Any idea?
Nov 27, 2013 at 3:36 PM
I'm going to research the language issue tonight.

Has anyone run into any other issues? How is the search working?
Nov 27, 2013 at 4:01 PM
The first impression is good. Will do some extra testing tonight.
Nov 27, 2013 at 10:28 PM
No luck, I did a complete new test. Updating DNN6 to 7 and AF 4 to 5.1.2 The search error is back. When I look in the proc activeforums_Search_FullText it looks like it is not changed. I see the following script.
ALTER PROCEDURE [dbo].[activeforums_Search_FullText]
    @PortalId int,
    @ModuleId int,
    @UserId int,
    @ForumId int,
    @IsSuperUser bit,
    @RowIndex int = 0,
    @MaxRows int = 20,
    @SearchString nvarchar(200), 
    @MatchType int = 0,
    @SearchField int = 0,--0=Subject&Body, 1= Subject, 2=Body
    @Timespan int = 0,
    @AuthorId int = 0,
    @Author nvarchar(200),
    @Forums varchar(8000),
    @Tags nvarchar(400),
    @ForumsAllowed nvarchar(1000)
as
DECLARE @BodyRank int
DECLARE @SubjectRank int
SET @BodyRank = 1
SET @SubjectRank = 1
If @SearchField = 1
    SET @BodyRank = NULL
If @SearchField = 2
    SET @SubjectRank = NULL
IF @AuthorId = 0 AND @Author != ''
    BEGIN
        DECLARE @DisplayOpt varchar(50)
        SELECT @DisplayOpt = SettingValue FROM dbo.activeforums_Settings WHERE ModuleId = @ModuleId AND SettingName = 'USERNAMEDISPLAY'
        If @DisplayOpt = 'Fullname' 
            SET @DisplayOpt = 'FirstName  + '' '' + LastName '
        DECLARE @sql nvarchar(2000)
        SET @sql = N'SELECT @RET = UserId FROM dbo.Users WHERE ' + @DisplayOpt + ' = ''' + @Author + ''''
        print @sql
        exec sp_executesql @stmt = @sql, @params = N'@RET as INT OUTPUT', @ret = @AuthorId OUTPUT;
        if @AuthorId = 0 SET @AuthorId = -1
    END
DECLARE @RowCount int
--DECLARE @tmpResults TABLE (resultid int identity(1,1),topicid int, matchpct decimal(15,4))
DECLARE @tmpResults TABLE (resultid int identity(1,1),topicid int,contentid int, matchpct decimal(15,4))
IF @SearchField = 0
    BEGIN
INSERT INTO @tmpResults(topicid,contentid, matchpct)            
    Select c.topicid,c.contentid, b.[RANK] as MatchPct
            FROM dbo.vw_activeforums_TopicView C INNER JOIN
            dbo.activeforums_Functions_Split(@ForumsAllowed,';') as fs ON fs.id = c.ForumId INNER JOIN
            FREETEXTTABLE(dbo.activeforums_Content, (Body,[Subject]), @SearchString,200) as B ON C.ContentId = B.[KEY]
            WHERE c.ModuleId = @ModuleId
            
    END
IF @SearchField = 1
BEGIN
INSERT INTO @tmpResults(topicid,contentid, matchpct)            
    Select c.topicid,c.contentid, b.[RANK] as MatchPct
            FROM dbo.vw_activeforums_TopicView C INNER JOIN
            dbo.activeforums_Functions_Split(@ForumsAllowed,';') as fs ON fs.id = c.ForumId INNER JOIN
            FREETEXTTABLE(dbo.activeforums_Content, ([Subject]), @SearchString,200) as B ON C.ContentId = B.[KEY]
            WHERE c.ModuleId = @ModuleId


            
    END
IF @SearchField = 2
BEGIN
            INSERT INTO @tmpResults(topicid,contentid, matchpct)
    Select c.topicid,c.contentid, b.[RANK] as MatchPct
            FROM dbo.vw_activeforums_TopicView C INNER JOIN
            dbo.activeforums_Functions_Split(@ForumsAllowed,';') as fs ON fs.id = c.ForumId INNER JOIN
            FREETEXTTABLE(dbo.activeforums_Content, (Body), @SearchString,200) as B ON C.ContentId = B.[KEY]
            WHERE c.ModuleId = @ModuleId


            
    END

--declare @topics TABLE (topicid int unique, matchpct decimal(15,4), rownum int)
declare @topics TABLE (topicid int,contentid int, matchpct decimal(15,4), rownum int)
INSERT INTO @topics(topicid,contentid, matchpct,rownum)
        SELECT hits.TopicId,hits.ContentId, hits.MatchPct, ROW_NUMBER() OVER (ORDER BY DateCreated DESC, hits.MatchPct DESC) as rownum FROM
                (
                    SELECT  t.topicid,t.datecreated,t.contentid         
                    FROM         dbo.vw_activeforums_TopicView AS T INNER JOIN
                    dbo.activeforums_Content AS C ON T.ContentId = C.ContentId 
                    WHERE 
                        
                        (@TimeSpan = 0 OR DATEDIFF(hh,T.DateCreated,GetDate()) <= @TimeSpan) AND
                        (@AuthorId = 0 OR T.AuthorId = @AuthorId) AND
                        (@ForumId <= 0 OR T.ForumId =  @ForumId) AND
                        (@Tags = '' OR (@Tags <> '' AND T.TopicId IN (
                                                        SELECT TopicId FROM dbo.activeforums_Tags INNER JOIN
                                                        dbo.activeforums_Topics_Tags ON dbo.activeforums_Tags.TagId = dbo.activeforums_Topics_Tags.TagId
                                                        WHERE   dbo.activeforums_Tags.TagName = @Tags))) AND
                        (@SearchString <> '' OR @Tags <> '') AND
                        
                        (@Forums = '' OR T.ForumId IN (SELECT id FROM dbo.activeforums_Functions_Split(@Forums,':')))
            ) as results INNER JOIN @tmpResults as hits ON results.contentid = hits.contentid
SELECT Count(*) from @topics
SELECT T.PortalId, T.ModuleId, T.ForumId, T.ForumName, T.TopicId, T.ReplyId, IsNull(T.Subject,'') as Subject,
     T.Summary, T.AuthorId, IsNull(T.AuthorName,'') as AuthorName, IsNull(T.Username,'') as UserName, IsNull(T.FirstName,'') as FirstName, 
        IsNull(T.LastName,'') as LastName, IsNull(T.DisplayName,'') as DisplayName, T.DateCreated, 
                      T.DateUpdated, T.ContentId, TopicIcon, StatusId, TopicType, IsPinned, IsLocked, ViewCount, ReplyCount,IsNull(c.Body,'') as Body FROM         
            dbo.vw_activeforums_TopicView AS T INNER JOIN
                    @topics AS r ON T.contentid = r.contentid INNER JOIN
                    dbo.activeforums_Content as c ON c.ContentId = t.ContentId
WHERE rownum > @RowIndex AND rownum <= (@RowIndex + @MaxRows)
ORDER BY  T.DateCreated DESC,MatchPct DESC

Nov 27, 2013 at 11:44 PM
That's not even close to the right proc. The 5.1 source code doesn't even contain the work "FREETEXTTABLE". It looks like the old proc from 4.x.

Did you go into settings and disable full text and then re-enabled it? That's an essential step in the upgrade process.
Nov 28, 2013 at 7:26 AM
After I re-enabled it again it works.
Nov 28, 2013 at 9:17 AM
RC3: Search very fast. Always undere 1 sec. on a forum with 9000 topics and 89,000 replys

Only one issue: Searching for a short string ("a" for example) I not obtain results and I obtain the "no discussions found...." message. If it's a lenght limit a message as "the search string must at least xxx chars" is better.
Nov 28, 2013 at 9:31 AM
I found an issue with search.

Searching only for tags or author (leaving blank the Keyword(s) files) an error occour.

Tracing the SQL activity the error is:
Msg 468, Level 16, State 9, Procedure activeforums_Search_Standard, Line 244
Cannot resolve a collation conflict "SQL_Latin1_General_CP1_CI_AS" e "Latin1_General_CI_AS" in the operation equal to.

Try to run in SQL this:
exec dbo.activeforums_Search @PortalId=0,@ModuleId=934,@UserId=1,@SearchId=0,@RowIndex=0,@MaxRows=20,@SearchString=N'',@MatchType=0,@SearchField=0,@Timespan=0,@AuthorId=0,@Author=N'authorname',@Forums=N'1:2:3:4:10:11:5:6',@Tags=N'',@ResultType=0,@Sort=0,@MaxCacheHours=1,@FullText=1

Replace authorname whit the name of an existing author
Nov 28, 2013 at 1:26 PM
Thanks guys.

@skiank: good catch, can you do me a favor and enter that as our first issue on GitHub? I'm pretty serious about wanting to get the ball rolling over there.

I'm going to try and post some more info today on why the move to GitHub is so important.

Sent from my iPhone

Nov 28, 2013 at 3:29 PM
jbrunken wrote:
Thanks guys. @skiank: good catch, can you do me a favor and enter that as our first issue on GitHub? I'm pretty serious about wanting to get the ball rolling over there. I'm going to try and post some more info today on why the move to GitHub is so important. Sent from my iPhone
Done! Right? I don't know GitHub... My issue is in the correct place?
Nov 28, 2013 at 3:46 PM
Yes, that's perfect. Thanks!

I realize that GitHub may be new to many of the DNN/Active Forum users, but I think once it gets rolling, everyone will understand why we moved. It's going to make contributing to the project much easier for everyone, and that's what the project needs most.
Nov 30, 2013 at 3:43 PM
If there are no new show stopper bugs found by Monday, I'm going to go ahead and more this release to production status.

I know that it still has several bugs that need to be tracked down, but all of those bugs exist in 5.0.3 as well. 5.1.0 has some major enhancements and we are way, way overdue for a new production release.
Dec 2, 2013 at 5:21 AM
jbrunken wrote:
Did you go into settings and disable full text and then re-enabled it? That's an essential step in the upgrade process.
Installed the RC3 on my test site, forgot to turn off full text search. Turned off and then on but now it won't stick - stays off "no". Did a repair with it off, cleared cache and restart but still won't stick. Full Text Search is enabled on the DB.

Should Full Text Search be disabled prior to upgrading?
Dec 2, 2013 at 2:42 PM
@mervharvey: Are you absolutely sure you installed RC3 (v5.1.2)? The behavior you are describing sounds like a bug that existed in RC1 and RC2.

Whenever you load the Forum Settings page, it runs a check to get the status of Full Text search. It will only show up as enabled if it detects that everything is installed and working properly.

One thing you can do is manually run the activeforums_Search_GetFullTextStatus proc. It will return "1" if everything is setup right. Let me know what that proc is returning.
Dec 2, 2013 at 6:51 PM
Edited Dec 2, 2013 at 6:52 PM
@JB: Installed this file ActiveForums_05.01.02_Install.zip. The proc returned -2
Dec 2, 2013 at 7:18 PM
Edited Dec 3, 2013 at 3:54 PM
-2 indicates that it can't find the full text index for the search.

If it you haven't already done so, try saving your settings with full text turned off, and then turn it back on.

If that doesn't work, I'd suggest manually running the full text procsavailable here:

https://github.com/jbrunken/ActiveForums/blob/v05.01.02/sql/FullTextInstallPart1.sql
https://github.com/jbrunken/ActiveForums/blob/v05.01.02/sql/FullTextInstallPart2.sql

After running both of those, try the process again.
Dec 3, 2013 at 3:50 PM
Can anyone else confirm an issue with enabling full text search?

Looks like we're going to have to have at least one more release candidate for 5.1 to fix an unrelated issue.

If you've found issues, please post them on GitHub. The window for getting fixes included in 5.1 is rapidly closing.
Dec 3, 2013 at 6:42 PM
@JB: I'm going to install a clean copy of the site to my testing server and try again. Don't know if this had any bearing on what happened but just prior to running the upgrade I deleted Active Social (leaving the .dll in the bin). Tried running the scripts. There was errors. I will try them again on the next install. Will leave AS installed this time.

The guys over at PowerDNN clone the site to a Test server for me but they have stuffed it up. Should have it right soon.

BRB
Dec 3, 2013 at 6:49 PM
Sounds good. Let me know what you find out. BTW, how did you try and execute those procs? You need to go to the SQL tool in the host menu and run them with "Run as Script" turned on. If you didn't do that, it would explain the errors.

FYI, I don't think that removing Active Social should have any impact on AF 5.X. If you find that not to be the case, please let me know so I can fix it.
Dec 3, 2013 at 10:02 PM
Edited Dec 3, 2013 at 10:02 PM
jbrunken wrote:
Can anyone else confirm an issue with enabling full text search?
I have 4 different test sites with 5.1.2 and on all I can enable/disable full text search.
Dec 3, 2013 at 10:15 PM
I'm on RC3 7.1.2 and I can enable/disable full text search no problem. I did have to turn it off, update then then on update after installing rc3.

I will test another site tonight and report back on its status.
Dec 4, 2013 at 3:47 AM
5.1 is now officially released for production use.

On to 5.2!
Dec 4, 2013 at 4:51 AM
@JB: The guys over at PowerDNN finally got it sorted, think that the usual people must be on holidays.

Okay so a disabled Full Text Search before upgrading. Upgraded using 5.1.3 (thought that I'd get a fresh copy of 5.1.2 and saw that you have released 5.1.3). Installed fine. Went to settings and Enabled Full Text Search. No stick again.

With the FullTexTInstall scripts I was running them from Management Studio. I'll try them now from the SQL Tool.

BRB
Dec 4, 2013 at 5:05 AM
RESULT.

FullTextInstallPart1.sql - Okay

FullTextInstallPart2.sql - FAILS

System.Data.SqlClient.SqlException (0x80131904): Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.ald_activeforums_Content' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f23e8a91-81e2-45c7-8856-9d5689df2544 / Object: StoredProcedure dbo.[ald_activeforums_Search_FullText] Script Date: 09/09/2013 18:50:31 / CREATE PROCEDURE dbo.[ald_activeforums_Search_FullText] @PortalId int, @ModuleId int, @UserId int, @SearchString nvarchar(200), -- String of 1 or more search terms, all separated by spaces @MatchType int = 0, -- 0 = match any, 1 = match all, 2 = exact match of entire expression only @SearchField int = 0, -- 0 = Subject & Body, 1 = Subject, 2 =Body @Timespan int = 0, @AuthorId int = 0, @Forums nvarchar(max), -- Intersection of forums allowed and forums requested @Tags nvarchar(400), -- Comma delmited tags @ResultType int = 0, -- 0 = topics, 1 = posts @Sort int = 0 -- 0 = relevance then post date (last), 1 = post date (last) AS -- Temp table to store our full text search results -- Parse out the Words DECLARE @Word nvarchar(200) DECLARE @WordTable table (Word nvarchar(200) NOT NULL) DECLARE @WordCount int = 0 IF @SearchString IS NOT NULL AND @SearchString <> '' BEGIN IF(@MatchType = 2) INSERT INTO @WordTable VALUES(@SearchString) ELSE INSERT INTO @WordTable SELECT string FROM dbo.ald_activeforums_Functions_SplitText(@SearchString, ',') SET @WordCount = (SELECT COUNT(*) from @WordTable) END -- If we dont' have any words, no point in doing the search IF @WordCount = 0 BEGIN DECLARE @emptyResults TABLE (rn int, tid int, cid int, mcpt decimal(15,4)) SELECT * FROM @emptyResults RETURN END -- Parse out the Tags DECLARE @Tag nvarchar(400) DECLARE @TagTable table (Tag nvarchar(400) NOT NULL) DECLARE @TagCount int = 0 IF @Tags IS NOT NULL AND @Tags <> '' BEGIN INSERT INTO @TagTable SELECT string FROM dbo.ald_activeforums_Functions_SplitText(@Tags, ',') SET @TagCount = (SELECT COUNT(*) from @TagTable) END -- Build our contains statement DECLARE @Contains nvarchar(4000) = '' DECLARE @Delimiter nvarchar(5) = ' OR '; DECLARE @CurrentWord nvarchar(200) = NULL IF @MatchType = 1 SET @Delimiter = ' AND ' DECLARE WordCursor CURSOR FOR SELECT Word FROM @WordTable OPEN WordCursor FETCH NEXT FROM WordCursor INTO @CurrentWord WHILE @@FETCH_STATUS = 0 BEGIN IF @Contains <> '' SET @Contains = @Contains + @Delimiter SET @Contains = @Contains + '"' + @CurrentWord + '"' FETCH NEXT FROM WordCursor INTO @CurrentWord END CLOSE WordCursor DEALLOCATE WordCursor DECLARE @ForumsTable table (Id INT not null) insert INTO @ForumsTable SELECT id FROM dbo.ald_activeforums_Functions_Split(@Forums,':') -- Grab our full text results declare @tmpResults TABLE (cid INT not null, tid INT not null, mcpt DECIMAL) SET NOCOUNT ON; IF @SearchField = 0 BEGIN INSERT INTO @tmpResults (cid, tid, mcpt) SELECT tmp.[KEY], tv.TopicId, tmp.[RANK] FROM CONTAINSTABLE(dbo.ald_activeforums_Content, (Body,[Subject]), @Contains) as tmp INNER JOIN dbo.vw_ald_activeforums_TopicViewForSearch as tv on tmp.[KEY] = tv.ContentId INNER JOIN @ForumsTable as f on f.id = TV.ForumId WHERE tv.ModuleId = @ModuleId AND tv.PortalId = @PortalId END IF @SearchField = 1 BEGIN INSERT INTO @tmpResults (cid, tid, mcpt) SELECT tmp.[KEY], tv.TopicId, tmp.[RANK] FROM CONTAINSTABLE(dbo.ald_activeforums_Content, ([Subject]), @Contains) as tmp INNER JOIN dbo.vw_ald_activeforums_TopicViewForSearch as tv on tmp.[KEY] = tv.ContentId INNER JOIN @ForumsTable as f on f.id = TV.ForumId WHERE tv.ModuleId = @ModuleId AND tv.PortalId = @PortalId END IF @SearchField = 2 BEGIN INSERT INTO @tmpResults (cid, tid, mcpt) SELECT tmp.[KEY], tv.TopicId, tmp.[RANK] FROM CONTAINSTABLE(dbo.ald_activeforums_Content, (Body), @Contains) as tmp INNER JOIN dbo.vw_ald_activeforums_TopicViewForSearch as tv on tmp.[KEY] = tv.ContentId INNER JOIN @ForumsTable as f on f.id = TV.ForumId WHERE tv.ModuleId = @ModuleId AND tv.PortalId = @PortalId END IF @ResultType = 1 BEGIN -- Get our main result set SELECT TOP 1000 ROW_NUMBER() OVER (ORDER BY CASE @Sort WHEN 1 THEN DateCreated ELSE mcpt END DESC, DateCreated DESC) as rn, tid, cid, mcpt FROM ( SELECT t.tid, t.cid, c.DateCreated, t.mcpt FROM @tmpResults AS T INNER JOIN dbo.ald_activeforums_Content AS C ON T.cid = C.ContentId WHERE (@TimeSpan = 0 OR DATEDIFF(hh,c.DateCreated,GetDate()) <= @TimeSpan) AND (@AuthorId = 0 OR C.AuthorId = @AuthorId) AND (@TagCount = 0 OR T.tid IN ( SELECT TopicId FROM dbo.ald_activeforums_Tags INNER JOIN dbo.ald_activeforums_Topics_Tags ON dbo.ald_activeforums_Tags.TagId = dbo.ald_activeforums_Topics_Tags.TagId INNER JOIN @TagTable TT ON TT.Tag = dbo.ald_activeforums_Tags.TagName)) ) AS results RETURN END IF @ResultType = 0 BEGIN -- Get our main result set SELECT TOP 1000 ROW_NUMBER() OVER (ORDER BY CASE @Sort WHEN 1 THEN MAX(LastReplyDate) ELSE SUM(mcpt) END DESC, MAX(LastReplyDate) DESC) as rn, tid, MAX(cid) as cid, SUM(mcpt) as mcpt FROM ( SELECT t.tid, t.cid, t.mcpt, CASE WHEN rc.DateCreated IS NULL THEN c.DateCreated ELSE rc.DateCreated END as LastReplyDate FROM @tmpResults AS T INNER JOIN dbo.ald_activeforums_ForumTopics FT on T.tid = FT.TopicId INNER JOIN dbo.ald_activeforums_Content AS C ON T.cid = C.ContentId LEFT OUTER JOIN -- Left outer joins to get last reply date dbo.ald_activeforums_Replies as R on FT.LastReplyId = r.ReplyId LEFT OUTER JOIN dbo.ald_activeforums_Content as RC on R.ContentId = rc.ContentId WHERE (@TimeSpan = 0 OR DATEDIFF(hh,CASE WHEN rc.DateCreated IS NULL THEN c.DateCreated ELSE rc.DateCreated END,GetDate()) <= @TimeSpan) AND (@AuthorId = 0 OR c.AuthorId = @AuthorId) AND (@TagCount = 0 OR T.tid IN ( SELECT TopicId FROM dbo.ald_activeforums_Tags INNER JOIN dbo.ald_activeforums_Topics_Tags ON dbo.ald_activeforums_Tags.TagId = dbo.ald_activeforums_Topics_Tags.TagId INNER JOIN @TagTable TT ON TT.Tag = dbo.ald_activeforums_Tags.TagName)) ) AS results GROUP BY tid RETURN END

Maybe this is the cause of all the trouble I've had with AF/AS since I purchased it from DNN.
Dec 4, 2013 at 5:26 AM
Yeah, now that I think about it, that is to be expected. The second part of the SQL proc won't execute until the full text index is created. I had to jump through some hoops to get all of this stuff to work without breaking Azure installs, so that's why it's a bit convoluted.

Before you run the second proc, go into management studio and execute the "activeforums_Search_ManageFullText" with the "enabled" parameter set to 1.

If everything works, that proc should return 1 as the result. After that, you should be able to run the second proc from the host menu to finish things up. Once you've done that, go back into your settings and see if full text is showing up as enabled.
Dec 4, 2013 at 6:58 AM
Edited Dec 4, 2013 at 6:59 AM
JB:

Not quite sure.

DECLARE @FullTextEnabled bit
If @Enable = 1
    BEGIN

    SET @FullTextEnabled = 0
Should I set

DECLARE @FullTextEnabled bit
If @Enable = 1
    BEGIN

    SET @FullTextEnabled = 1
By modifying the script?
Dec 4, 2013 at 7:13 AM
Not sure if I got this right. Above I was think "Modify" the script. Then I realized "Execute Stored Proc. Set value at 1 and this error

Msg 7653, Level 16, State 1, Line 1
'PK_activeforums_Content' is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, does not have a filter, and has maximum size of 900 bytes. Choose another index for the full-text key.

Tried again with Pass Null Value checked and it worked of course with a 0 return.
Dec 4, 2013 at 3:09 PM
Thanks, that tells me what I need to know to fix the issue.

I've created a new issue for this on GitHub:

https://github.com/jbrunken/ActiveForums/issues/20

I'll put together a hotfix for 5.1.
Dec 4, 2013 at 4:09 PM
Good. I'll wait for the fix and test it.
Dec 5, 2013 at 1:52 AM
@mervharvey: In case you didn't see my note, please re-download and do a repair install on 5.1.3 and see if you can enable full text search now.