Hi There,

I suspect this is going to be a newbie type question, but I hope you'll bear with me....

I have had to restore a whole DNN site to another location and was presented with a zip file containing the site files, and the database in the form of a .bak file. I have managed to restore the database (which was a big pain, but it appears to be up there) and restoring the files themselves was easy. The database name is 'tandj_dotnetnuke' .

When I view the site, every container contains the same error message:

Error: welcome is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'tandj_dotnetnuke.GetHtmlText' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'tandj_dotnetnuke.GetHtmlText' 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 DotNetNuke.Modules.Html.SqlDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Does anyone have any ideas? I obviously have quite a serious global problem - I have searched forums and googled parts of the error message, but the similar ones I have found seem to be only problems with isolated modules rather than the whole site.

If I havent provided enough information, please let me know. I love DNN - I am sure the problem is caused by something I either haven't done, or something i've done incorrectly.

Thanks,
Nick.