Search
Register
Login
Today: 09/12/2005 we have setup our new dedicated English forum.
From today on, please use this forum instead of the English forums on DNNPortal.DE.
I will lock the English forums on DNNPortal.DE.
I received the following errors in the DNN upgrade log on the HOST settings page.
I have heard that 3.0.12 was not a production release!! I am concerned that my production site is not stable now. Is there a way for me to do a clean install and maintain my blog information ???
System.Data.SqlClient.SqlException: The constraint 'PK_Users' is being referenced by table 'NewBlog_Blogs', foreign key constraint 'FK_NewBlog_Blogs_Users'. Could not drop constraint. See previous errors. 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) ALTER TABLE dbo.Users DROP CONSTRAINT PK_Users System.Data.SqlClient.SqlException: Table 'Users' already has a primary key defined on it. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.Users ADD CONSTRAINT PK_Users PRIMARY KEY CLUSTERED ( UserID ) ON [PRIMARY]
That is not so easy.
If you have direct access to your database you have á chance, but without having access to the database there is no way.
But I have an idea.
We must try to upgrade first your existing installation, so that we can install the newest version of NewBlog, with this version it is possible to export your blog data and import it later in a new installation.
Which version of NewBlog do you have installed ?
If you can send me the version of NewBlog I will send you a SQL script to remove the foreign key, so that it could be possible to upgrade your portal.
Hi,I am running DNN 3.2.2 and on one of my portals I have Newblog 03.01.18 (I think I installed it on a 3.1.2 version and have upgraded DNN several times).I want to remove the module or upgrade it to the latest version of the Blog subproject. I know that there are some problems and for example I have recently tried to create a DTS copy of my DNN database and receive the error:-
ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_NewBlog_Blogs_Portals'. The conflict occurred in the database 'mydb', table 'Portals', column 'PortalID'.
Can I upgrade or should I remove the module completely and install the new version (I will not lose too much info)? Is there anything I need to do to the DB first?
Many thanks
Page generated in 0.1249976 seconds.