And heres the error we get for our court availability! Its pretty much saying our procedure doesn't exist, however like I said this module works fine when we are using it as admin

AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: The stored procedure 'dbo.TriforceConsulting_GetViewCourtAvailabilitys' doesn't exist.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.InvalidOperationException: The stored procedure 'dbo.TriforceConsulting_GetViewCourtAvailabilitys' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at TriforceConsulting.Modules.ViewCourtAvailability.SqlDataProvider.GetViewCourtAvailabilitys(Int32 ModuleId) at TriforceConsulting.Modules.ViewCourtAvailability.ViewCourtAvailabilityController.GetSearchItems(ModuleInfo ModInfo) at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 PortalID)

A couple of things to check then would be to look and ensure that in your SQLProvider there isn't any entries that you are not using that mgiht reference this.  (If using generated code or templates)

You might also want to ensure that if you specified an object qualifier in your DNN install that you have allowed its use in your module (Again if this applies)

It is very hard to say exactly what is wrong without seeing the code but it does appear that it is expecting procedures that do not exist.

---

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.


Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services