Register   Login
     
  Latest Posts  
RE: Comments - make approved before showing?
by odove on 3/15/2010 1:39 PM
RE: Is there a way to add image, based on x of DATE
by ray-isc on 3/15/2010 12:40 PM
Where is the NA Latest Article Module setting stored?
by ray-isc on 3/15/2010 12:15 PM
RE: NA Latest - Template question
by Declic Video on 3/15/2010 10:55 AM
RE: NA Latest - Template question
by spirit on 3/15/2010 10:46 AM
RE: Sort by custom Date Field error
by Digital Past on 3/15/2010 9:52 AM
RE: Selective access to view article details
by badri on 3/15/2010 9:17 AM
SubType edit?
by IMISOFT on 3/15/2010 8:48 AM
RE: NA Latest - Template question
by Declic Video on 3/15/2010 8:32 AM
RE: NA Latest - Template question
by spirit on 3/15/2010 8:24 AM
  Forums  
Subject: Multicheckbox search error
Prev Next
You are not authorized to post a reply.

Author Messages
CabinMommaUser is Offline
Gold Membership
Ventrian Active Member
Ventrian Active Member
Posts:44

1/03/2009 9:21 PM  

Hi Scott,

We have a custom field that is a multicheckbox, which we have as a searchable field.  We have recently started having issues with it during searches.  Our production site is on 1.07.12.  I checked our test site (mirror of our live save for some visuals - moving fields, etc) and it was having the same problem.  So, I updated to 1.07.16 in our test environment to see if that would help, but it did not.

I'm assuming it's a data problem on our end, but I can't see the problem.  I turned on another multicheckbox field for search and it causes the same problem. 

I'm going to email you our site links and some login information in the hopes that you have the time and inclination to take a look and see if you can see the issue.

The error I get is :

Error: Find Childcare is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Ventrian.PropertyAgent.SqlDataProvider.ListProperty(Int32 moduleID, Int32 propertyTypeID, Int32 status, Int32 authorID, Int32 brokerID, Boolean isActive, Boolean isPending, Boolean isExpired, Boolean showFeaturedOnly, Int32 sortBy, Int32 sortByID, Int32 sortByIDType, Int32 sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Double latitude, Double longitude) at Ventrian.PropertyAgent.PropertyController.List(Int32 moduleID, Int32 propertyTypeID, SearchStatusType status, Int32 authorID, Int32 brokerID, Boolean showFeaturedOnly, SortByType sortBy, Int32 sortByID, SortDirectionType sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Int32& totalRecords, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Int32& typePosition, Double latitude, Double longitude) at Ventrian.PropertyAgent.ViewType.BindProperty() at Ventrian.PropertyAgent.ViewType.Page_Initialization(Object sender, EventArgs e) --- End of inner exception stack trace ---

Thanks in advance for any light you might be able to shed.

paula

Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17161


1/06/2009 5:41 PM  
I've sent you emails about this.

Scott McCulloch
Site Administrator
You are not authorized to post a reply.
Forums > Modules > Property Agent > Multicheckbox search error



ActiveForums 3.7