Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Install It!  Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!
Previous Previous
 
Next Next
New Post 6/21/2008 7:40 AM
User is offline julia_llac
159 posts
www.travel2siam.ru
9th Ranked


Re: Upgrade DNn from 3 to 4 get  
Modified By julia_llac  on 6/21/2008 4:17:00 PM)

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 7:58 AM
User is offline Ian Robinson
607 posts
www.engagesoftware.com
7th Ranked


Re: Upgrade DNn from 3 to 4 get  

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


Ian Robinson
Engage Software
St. Louis, MO
314.966.4000



The leading provider of DotNetNuke support, training and custom development.
 
New Post 6/21/2008 8:09 AM
User is offline julia_llac
159 posts
www.travel2siam.ru
9th Ranked


Re: Upgrade DNn from 3 to 4 get  
Modified By julia_llac  on 6/21/2008 11:46:33 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 8:33 AM
User is offline Ian Robinson
607 posts
www.engagesoftware.com
7th Ranked


Re: Upgrade DNn from 3 to 4 get  

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


Ian Robinson
Engage Software
St. Louis, MO
314.966.4000



The leading provider of DotNetNuke support, training and custom development.
 
New Post 6/21/2008 9:47 AM
User is offline julia_llac
159 posts
www.travel2siam.ru
9th Ranked


Re: Upgrade DNn from 3 to 4.4.1 and further 4.6.2 
Modified By julia_llac  on 6/21/2008 4:08:16 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 Previous
 
Next Next
  Forum  General DotNetN...  Install It!  Upgrade DNn from 3 to 4 get runtime error AND customErrors mode="Off is not working!
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Willhite & Sharron Realtors
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com
PointClick DotNetNuke Solutions
PointClick Technologies provides high-end DNN Hosting for businesses.
PointClick.Net Hosted Solutions
Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP