Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumSQL Error upgrade issue to 04.05.03SQL Error upgrade issue to 04.05.03
Previous
 
Next
New Post
7/30/2009 11:31 AM
 

Hi,

I have the site up and running.
Installed for the second time the forum module.
This time, everything went well.
No errors at all.
The site is up and running with the new Forum.
Next, I have to check al the new changes.

With regards, Ton Hermes


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
7/30/2009 6:53 PM
 

I just got the same error in an installation. DNN 5.1.1 SQL2008 instaled languages sv dk en.

But I realized that Ithe site was running in SQL 2000 mode so I just have to blame myself

However I changed to 2005 and did a new install and got the same error so now I dont know who to blame....

I do a new try with 2008 stay tuned..

Same result with 2008 maybe the uninstall does not work in release 5.1.1 but I dont care any more .  looks like this release needs some testing....!!

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. vid System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) vid System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) vid System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) vid System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) vid System.Data.SqlClient.SqlCommand.ExecuteNonQuery() vid DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) vid DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DECLARE @default_constraint_name SYSNAME, @sql NVARCHAR(3750) IF EXISTS ( SELECT name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) SET @sql = N'ALTER TABLE dbo.Forum_EmailQueue_TaskEmails DROP Constraint ' + @default_constraint_name EXEC sp_executesql @sql END System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. vid System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) vid System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) vid System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) vid System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) vid System.Data.SqlClient.SqlCommand.ExecuteNonQuery() vid DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) vid DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_EmailQueue_TaskEmails ADD CONSTRAINT DF_Forum_EmailQueue_TaskEmails_DateAdded DEFAULT (GETDATE()) FOR DateAdded

 
New Post
7/30/2009 10:53 PM
 

So far the only isuse we have seen that wasn't previously known is this one, which is Private Messaging related only.


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
7/31/2009 7:40 AM
 

Sorry Crispy, the release is fine some minor bugs in a large module its very good. But don't forget the OleAut - Date last index issue :)

 
New Post
7/31/2009 11:12 AM
 

Jan, I did forget about that but I have yet to have it verified. I have tried and haven't been able to reproduce and our team tester who does use another culture in the same format hasn't been able to reproduce it yet. I am not saying it isn't an issue, just that nobody on the team has confirmed that one and I haven't heard from others yet.


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumSQL Error upgrade issue to 04.05.03SQL Error upgrade issue to 04.05.03


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out