Can't delete portal because of User Directory > DotNetNuke Module Product Forums > Data Springs Inc.

Recently Viewed...

To help you navigate to pages you most recently visited, select from the links below.

Product Forums

Sharepoint Forums

Newsletter

Dynamic Forms Demonstrations

Page Tags

DNN Modules

Back on Track

Dynamic Forms

Dynamic Login

Dynamic Registration

Dynamic Tags

Dynamic User Directory

Flash Contacts

Flash Info Cube

Flash Image Rotator

Flash News Ticker

Info Pics

Interactive User Import

Page Tags

News Ticker

Opt In Email

Presentation Archive

Quick Poll

Quote Creator

Random Rounded Images

Real Estate

Stock Quote Module

Testimonials

Tailored Text / HTML

SnowCovered Top Sellers

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Live Content v1.6.1 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

XMod 5.1

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

Active Forums

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

Document Exchange 5

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Product Forums...

Unanswered Active Topics

Forums Search

Forums > Product Discussion - DotNetNuke Modules > Dynamic User Directory

Subject: Can't delete portal because of User Directory

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

Anne
Posts:17

wading in the water

07/09/2007 4:52 PM
I tried to delete a portal that had an instance of the User Directory on one of its pages, and I got the following error: Error: Portals is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Modules". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Portals". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'PortalID'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Modules". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Portals". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'PortalID'. The statement has been terminated. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) 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, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.grdPortals_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack It seems to have left the portal in kind of a quasi-deleted stage, as I can no longer navigate to the portal to try to delete the UD module that was causing the problem. Not an earth-shattering problem, but it would be nice if it could be fixed in the next release. When is a new release planned for this module?

Chad
Posts:2386

river guide

07/11/2007 8:23 AM
Hi, execute this under Host/SQL and let me know if this fixes you up. ALTER TABLE DataSprings_DynamicUserDirectory DROP CONSTRAINT FK_DataSprings_DynamicUserDirectory_Modules

You are not authorized to post a reply.

Forums > Product Discussion - DotNetNuke Modules > Dynamic User Directory > Can't delete portal because of User Directory

ActiveForums 3.7