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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!
Previous
 
Next
New Post
6/21/2008 10:40 AM
 

Cathal

I got the problem , it was few missing <-- and --> but you did help :) I was treparing to send you my web config by mail and decided to see if there's anything I will see in the last moment so I will not look really stupid... so checked and double checked everythung, then uploaded and it worked... there was an error with upgrade 04.03.05

( log  file reads

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'LastUpdated' in table 'dbo.Folders' is specified more than once.
   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)


/* Add LastUpdated Column to Folders */
/*************************************/

ALTER TABLE dbo.Folders ADD
 LastUpdated datetime NOT NULL CONSTRAINT DF_Folders_LastUpdated DEFAULT getUtcDate()
)

but site worked and looked ok ... so I went with another upgrade (of which I am so sorry at the moment ( again ) ) but that's another story

 
New Post
6/21/2008 10:58 AM
 

Hey Julia,

Try setting your connection strings up as follows:

 <connectionStrings>
    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke_2;uid=dnn2_user;pwd=dnn;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke_2;uid=dnn2_user;pwd=dnn;" />

 

Hope that helps,

Ian


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
6/21/2008 11:09 AM
 

I don;t know what actually helped... BUT I got it !!! it makes me sick at the moment ( I guess from disbelief that my nightmare is over !! ) that all went smooth  with only one error

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'LastUpdated' in table 'dbo.Folders' is specified more than once.

should I worry about it now? I don;t know

 BUT I THANK EVERYONE ALL WHO MADE THIS DNN THANKS SOOO MUCH  IT"S THE BEST THING! ( even with all these errors I got  ) WHEN IT WORKS IT MAKES MY DAY !!!

 
New Post
6/21/2008 11:33 AM
 

Hey Julia,

I would take the time to investigate this one and correct it. Is there any more detail to the error message? Can you navigate to the host-> sql menu or directly to the database and verify the integrity of the table in question? "select * from folders" should do the trick

Thanks,

Ian


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
6/21/2008 12:47 PM
 

HO HO HO !! we wouldn't know!

 we were so happy about the fact that everything is back to normal we decided to screw ( possibly ) things up again and do a further upgrade !!! in the process now ;) pushing my luck as usually...

------

few hours later I had to open another topic :) about error while upgrading to DNN481 DAMN ! http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/237066/scope/posts/Default.aspx

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!


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