DNN version is 5.6.2

When I try a search I get the following:

DotNetNuke.Services.Exceptions.ModuleLoadException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance. ---> System.Data.SqlClient.SqlException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Forums.SqlDataProvider.Search_FullText(Int32 PortalId, Int32 ModuleId, Int32 UserId, Int32 ForumId, Boolean IsSuper, Int32 RowIndex, Int32 MaxRows, String SearchString, Int32 MatchType, Int32 SearchField, Int32 Timespan, Int32 AuthorId, String Author, String Forums, String Tags, String ForumsAllowed) at Active.Modules.Forums.af_search_new.BindPosts(Int32 Column, String Sort) at Active.Modules.Forums.af_search_new.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Hi Donald,
You need to contact your hosting provider. It looks like they have a configuration problem with SQL Server Full Text Search.

Thanks Will. I contacted PowerDNN and the guy didn't know anything about this SQL problem. He said to tell you I have a dedicated server and that you might be able to give me directions as to how to start the service etc.

Donald,
Escalate your ticket with PowerDNN. I know they have fixed it for other customers before, but they usually push it back to us the first time around. I don't know the exact problem, but I know PowerDNN has fixed it before for others.

Just did that. Thanks Will.

Thanks Will. Already escalated.

While You are watching there is a small issue with the Search button itself. It appears that the button length is not correct because the magnifying glass is above the word Search causing it to be cut off on the bottom. Seems like you want it left of the word based on the textbox height. Can you point me to the place to fix this?

PowerDNN kicked the first issue back to you. They said you should know what your module needs to run. I'm caught in the middle! Help!

Sorry Donald, I'll send PowerDNN an email.

Thanks. How about the button problem?

Attached picture of my search button.

Donald, not sure about your button problem. It doesn't happen by default. It probably has something to do with the font size of your skin or browser. You can see on this site that we don't have that problem. I would suggest posting a screen capture so we can see what you see.

Hi Donald,
Will just emailed me and I believe we have the issue resolved for you. I also created this KB article that explains the issue and how to resolve it:

https://support.powerdnn.com/index.php?/Knowledgebase/Article/View/303/0/you-receive-an-error-when-trying-to-use-full-text-indexing

I've already logged into your server and have performed the resolution for that article. Can you please re-test and let me know if that resolves your issue?

Always glad to help,
Tony Valenti
PowerDNN

It's not throwing an exception error now. It's just not finding anything even though it's there.

Image attached.

On the search button. My site is limited to 900pix wide. Could that affext the button width?

When the search page loads I get an Unknown propery 'Zoom' warning at: *+html div.RadComboBoxDropDown .rcbList { zoom: 1; } /* IE7 item width fix */

When I hit the search button I get an error: Error: uncaught exception: [Exception... "Index or size is negative or greater than the allowed amount" code: "1" nsresult: "0x80530001 (NS_ERROR_DOM_INDEX_SIZE_ERR)" location: "http://www.cadontechnologies.com/js/dnn.js Line: 176"]

Turning Full Text Search off, saving then turn back on cleaned up the last errors. Search is now working. My only problem left is the button image.

Add this to one of your css files, then refresh the page.

div#afcontainer.afcontainer table tbody tr td span.ambtnwrap {width:67px !important;}

I added it to Module.css and it fixed the problem. Thanks.