R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Database index error
Last Post 01 Jan 1900 05:00 AM by . 2 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
smillerUser is Offline
New Member
New Member
Posts:24

--
20 Jun 2007 06:02 PM  
I just got the error pasted below when installing the Doctor package. I believe this is actually do to an issue with our recent DotNetNuke upgrade, rather than an issue with ListX or with the package itself.

Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)
Shane Miller
rgallaisUser is Offline
Basic Member
Basic Member
Posts:146

--
20 Jun 2007 06:19 PM  
Hi Shane,

This issue has been reported and the next listX release will fix that: http://dnn.bi4ce.com/Support/Forums/tabid/106/forumid/7/tpage/1/view/topic/postid/5844/Default.aspx

Thanks for the bug report,

Regards
Romain Gallais<br>Business Intelligence Force, Inc. (bi4ce)
smillerUser is Offline
New Member
New Member
Posts:24

--
20 Jun 2007 06:22 PM  
Ah, thanks for letting me know! That saves me some time.
Shane Miller
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share