This project is read-only.

DNN Module Install Error

Aug 10, 2010 at 9:17 PM
Edited Aug 10, 2010 at 9:17 PM

The NewsManager looks like a promising module. Sadly, I haven't gotten to enjoy it yet as I'm always getting these errors during the install: Any ideas? Thanks.

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_aspnet_Users' already exists on table 'aspnet_Users'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE UNIQUE INDEX IX_aspnet_Users ON aspnet_Users ( UserName ASC ) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_anm_Authors'. Cannot insert duplicate key in object 'dbo.anm_Authors'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) INSERT INTO [anm_Authors] ([role],[author]) VALUES (1,'admin') System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_anm_Authors_aspnet_Users". The conflict occurred in database "BornToWinDNN5_2009", table "dbo.aspnet_Users", column 'UserName'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) INSERT INTO [anm_Authors] ([role],[author]) VALUES (1,'host') System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_anm_Settings'. Cannot insert duplicate key in object 'dbo.anm_Settings'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) INSERT INTO [anm_Settings] ([id],[SiteName],[SiteEmail],[SiteUrl],[Template],[TopMenu],[SideMenu],[SearchMenu],[ArchiveMenu],[EmailConfirm],[MailUser],[MailPassword],[smtpserver],[Banner],[Year],[Month],[HBGColor],[BGcolor],[BGimage],[Width]) VALUES (1,'','','',1,'False','True','True','True','False','','','','',YEAR(GETDATE()),MONTH(GETDATE()),'ffffff','ffffff','','100%')

Aug 11, 2010 at 10:15 AM
Maybe, have you tried to install the module more than one time ?
Aug 11, 2010 at 12:15 PM
Edited Aug 11, 2010 at 12:18 PM
Download the module from here: http://www.allnewsmanager.net/allnewsmanager/download/AllNewsManager.NET_Anm_01.00.00_Install.zip

Try again, now you should not have problem to install the module.
Aug 11, 2010 at 3:14 PM

 

 

 

Failure

Yes, I had tried the previous installation several times - receiving the same error. I have re-downloaded the module using the provided link & attempted an install 4 times.
Most of the errors from the above post went away, but one remained.
I know next to nothing about SQL, so I don't really understand why there would be a conflict in 'UserName', etc.
Is there a DNN version requirement (I didn't see one in the doc)? I'm running 05.01.03 (compared to the current 05.04.04).

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_anm_Authors_aspnet_Users". The conflict occurred in database "BornToWinDNN5_2009", table "dbo.aspnet_Users", column 'UserName'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM anm_Authors WHERE author='host') BEGIN INSERT INTO [anm_Authors] ([role],[author]) VALUES (1,'host') END

 

Thanks.

Aug 11, 2010 at 4:54 PM
Edited Aug 11, 2010 at 4:57 PM
The DNN version is ok. The problem should be that your dnn host user is not called host. I made a little change on the sql script, try to download and install this: http://www.allnewsmanager.net/allnewsmanager/download2/AllNewsManager.NET_Anm_01.00.00_Install.zip

After installed, log in as 'admin' to enter the admin section of the module.
Aug 11, 2010 at 5:47 PM

Downloaded the changed module from the above url.
However, after multiple attempts, it now spends a long time on the very first step of the installation (before asking about license, file extension whitelist, etc.) and ends in a timeout.

[HttpException (0x80004005): Request timed out.] (Highly enlightening stack trace)

Thanks for working with me on this problem.

Aug 11, 2010 at 6:02 PM
let's try in a second moment, if you are on your local machine, try to restart your computer. I tested the module from the above url and it works.

Thank you for the support, it helps for the next release of the dnn module ;-)
Aug 11, 2010 at 6:22 PM

You're right. A simple restart fixed it.

Thanks!

Aug 11, 2010 at 6:33 PM
Edited Aug 11, 2010 at 6:34 PM

One (hopefully) last question:

"After installed, log in as 'admin' to enter the admin section of the module."
Does the admin account have to be named "admin", because I don't see any place for specialized settings/content entry when logging in administrator or host accounts, just the generic DNN module settings page.

Aug 11, 2010 at 6:58 PM
Log in as admin, after you can see on top right the link "Admin Page" as in the demo site: http://dnndemo.allnewsmanager.net/
Aug 11, 2010 at 7:26 PM

I am logging in as a user with the security of Administrator and I've got my usual Admin tab on the menu. The space on the other side of the " [username] Logout || " in the module (where Admin Page should be) remains blank.
Manually adding "?p=AdminArticles" to the end of the url (just in case :p ) gives me an internal message in the module that "You don't have permission to access this page."

Aug 12, 2010 at 8:18 AM
The first time you need to login as the user named "admin", after you can see the Admin Page of the module and then you can let other users to administrate the module from "Authors" menu.
Sep 10, 2010 at 6:13 AM

Hi Experts,

I tried to install your dnn module, which seems to matches my needs.

But during installation I get following error:

Info File ckeditor\strongKey.pfx read successfully
Info Loading bin/FredCK.CKEditor.dll
Info File bin\FredCK.CKEditor.dll read successfully
EndJob Reading files done.
Failure ExceptionSystem.Exception: Dnn load failed, aborting at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnLoaderFactory.GetDnnAdapter() at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

I am working with DNN Version 04.09.04 on a produktiv system.

Please, let me know what is wrong

Many thanks in advance and best regards

George

Sep 10, 2010 at 7:58 AM

Sorry, I tested the module only on Dnn5. But I think should work on Dnn4 too.

 

Try to open the .zip file and change the AllNewsManager.NET_Anm.dnn

from:

<dotnetnuke type="Package" version="5.0">

to:

<dotnetnuke type="Package" version="4.0">

it's the first row of the text file.

 

Sep 11, 2010 at 8:34 AM

Hi,

I have updated dotnetnuke to the newest version and the installation works fine.

So I had a reason to update -)

many thanks

Sep 11, 2010 at 9:05 AM

The module works very fine -)

I will rate your module