Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 from 3.3.3 to 4.5.3 errorUpgrade from 3.3.3 to 4.5.3 error
Previous
 
Next
New Post
7/24/2007 11:14 PM
 
Simon Ovens

www.orcadesigns.co.nz
Joined: 7/23/2006
Posts: 58

Ok, so i have two sites to upgrade, the second one is coming up with the following error:

Upgrading DotNetNuke
Current Assembly Version: 04.03.07
Current Database Version: 03.03.03

 

Upgrade Status Report
00: - Upgrading to Version: 4.0.0 Error! (seeC:\Inetpub\wwwroot\Website\Providers\DataProviders\SqlDataProvider\04.00.00.log for more information)


 


--------------------------------------------------------------------------------

Server Error in '/internet' Application.
--------------------------------------------------------------------------------

Cannot insert the value NULL into column 'VersionId', table 'Internet.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'VersionId', table 'Internet.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:


Line 209:                        Response.Write("<h2>Upgrade Status Report</h2>")
Line 210:                        Response.Flush()
Line 211:                        Upgrade.UpgradeDNN(strProviderPath, strDatabaseVersion.Replace(".", ""))
Line 212:
Line 213:                        'Install Resources
 

Source File: C:\Inetpub\wwwroot\Website\Install\Install.aspx.vb    Line: 211

 
 
New Post
7/26/2007 12:29 AM
 
Simon Ovens

www.orcadesigns.co.nz
Joined: 7/23/2006
Posts: 58

Ok so i figured out what was going on with this upgrade.

The version thing was caused by the fact that I wasnt able to restore the live database onto my test envirmoent because the live enviroment is mssql 2005 and the test enviro is 2000 (came up with error regarding to many backup devices, which is apparently fixable by installing the latest sp for mssql 2000). So i ended up using the export wizard which didnt copy over the primary keys, auto_increments and so on, The site worked fine but when upgrading it fell over. Also note that i couldnt generate a script of the db either because of permissions, site is hosted with someone esle.
The sql error was caused by the test enviroments tempdb was a different collation to the dotnetnuke one.......one was sql_latin and the other just latin.

In the end i just used sqlexpress2005 and managed to upgrade one of the site, so onto the next!  
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade from 3.3.3 to 4.5.3 errorUpgrade from 3.3.3 to 4.5.3 error


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