Hi

We have started experiencing the following error on one of our sites with DMX.

"A critical error has occurred.
The stored procedure 'dbo.DMX_GetSettings' doesn't exist."

Can you help?

thanks
Gus

Here is the trace

i'm not sure what this SmokeRanch is. I think it's a module someone installed.
(this is our dev site).

Is there a conflict with DMX?


AssemblyVersion: 04.09.05
PortalID: 0
PortalName: AmCham EU Webstore
UserID: 1
UserName: host
ActiveTabID: 37
ActiveTabName: Home
RawURL: /DesktopModules/SmokeRanch.ContentRotator/GetContentItem.aspx?mid=849&contentid=4
AbsoluteURL: /DesktopModules/SmokeRanch.ContentRotator/GetContentItem.aspx
AbsoluteURLReferrer: http://dev-amchameu.dnn1-box.eu/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 51f86fbe-fdf4-4bab-92cc-9a567800b6a2
InnerException: The stored procedure 'dbo.DMX_GetSettings' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: System.InvalidOperationException: The stored procedure 'dbo.DMX_GetSettings' 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 Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.GetSettings(Int32 PortalId) at Bring2mind.DNN.Modules.DMX.Common.Settings.DMXSettingsTable..ctor(Int32 PortalId) at Bring2mind.DNN.Modules.DMX.Common.Settings.HostSettings..ctor() at Bring2mind.DNN.Modules.DMX.Common.Settings.HostSettings.GetHostSettings() at ᜀ.ᜀ(LogLevel A_0, String[] A_1) at Bring2mind.DNN.Modules.DMX.WebDAV.AuthenticationModule.ᜁ() at Bring2mind.DNN.Modules.DMX.WebDAV.AuthenticationModule.ᜁ(Object A_0, EventArgs A_1)
Source:
Server Name: VPS-2082

Hi Gus,

DMX_GetSetting was introduced in DMX 5.3.0. So if it is missing the module dll is a 5.3 but the database is not. This can be the result from:
1. A bad install
2. Manually copying a new dmx dll into your site
3. Database rollback after a module upgrade
etc etc

Peter