Just downloaded the newsletter module and received the following error: any ideas ?

StartJob

Début de traitement de script Sql : 01.00.00.sqldataprovider

Failure

Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_NewsletterAdd', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_NewsletterAdd System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_NewsletterDelete', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_NewsletterDelete System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_NewsletterGet', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_NewsletterGet System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_NewsletterList', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_NewsletterList System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_NewsletterUpdate', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_NewsletterUpdate System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_UserAdd', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_UserAdd System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_UserDelete', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_UserDelete System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_UserGet', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_UserGet System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_UserList', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_UserList System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.Orizonti_Newsletter_UserUpdate', because it does not exist in the system catalog. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) drop procedure dbo.Orizonti_Newsletter_UserUpdate

Sorry about that...  I had an error in the SQL script...  Fixed and added it to the download.

Please download it again and let me know if that works...

Thanks,

Russel

I tried to install and got the following error.

Failure Did not find any .dnn file ??? Failure ExceptionSystem.Exception: File load failed, aborting at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.ReadZipStream() at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

Thanks

After installing and getting it up and going, I had the following problem.  I don't know what is going on...Thanks for the help!

Error: Send Newsletters is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Key cannot be null. Parameter name: key ---> System.ArgumentNullException: Key cannot be null. Parameter name: key at System.Collections.Hashtable.ContainsKey(Object key) at System.Collections.Hashtable.Contains(Object key) at Orizonti.Newsletter.sendNewsletter.btnSend_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Todd Hudson

Only a list, not a role.

Thanks

Todd,

I'm build a hashtable of all the email addresses (to prevent dupes) and use it as the list to send emails.  Any chance you've got a datarow with  blank as the email address?  I need to catch it gracefully anway, but that would be my guess as to the problem...

Take a look and let me know...

Thanks,

Russel

I've the same problem.. Doesn't make any difference when choosing between list or role. If I choose list, there's only 1 contact and he has a emailaddress..

Thx.

André

DotNetNuke.Services.Exceptions.ModuleLoadException: Key cannot be null. Parameter name: key ---> System.ArgumentNullException: Key cannot be null. Parameter name: key at System.Collections.Hashtable.ContainsKey(Object key) at System.Collections.Hashtable.Contains(Object key) at Orizonti.Newsletter.sendNewsletter.btnSend_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---