I am running DNN v4.5.1 with Links v3.0.7

When I login as 'admin' and try to delete a link (e.g. the "Croydon Christian Church" link on website:  www.frostbyte.com.au) at get an error:

Error: Edit Links is currently unavailable

If I then login as 'host' and try to perform the same function I get the following error display:

Error: Edit Links is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.DeleteLink' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.DeleteLink' 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.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Links.SqlDataProvider.DeleteLink(Int32 ItemId, Int32 ModuleId) at DotNetNuke.Modules.Links.EditLinks.cmdDelete_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

The detailed error message seems pretty clear ... I can confirm that there is no stored procedure dbo.DeleteLink in the SQL database ... can you shed any light on "why" this is so?

Thanks for any help,

Steve.

Hmmm. Weird. We have another server also running DNN 4.5.1 which was upgraded the same day and by the same person that upgraded the one I've mentioned above.  The other server does have a dbo.DeleteLink stored procedure, as follows:

************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for dbo. and   *****/
/*****                                                  *****/
/************************************************************/

/** Change the procedure to allow for ModuleID to be passed in. **/
CREATE procedure dbo.DeleteLink

 @ItemId int,
 @ModuleId int

as

delete
from dbo.Links
where  ItemID = @ItemId AND ModuleID = @ModuleId
GO

So is this fix going to be as simple as creating the SP with the code I've posted above?  I have just enough knowhow to be dangerous, but should be able to manage this if its the right way out of the situation.

Of course, now I'm starting to wonder whether there are OTHER sp's which might be missing after the upgrade ....