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 ...4.0.3 to 4.3.5 Upgrade fails4.0.3 to 4.3.5 Upgrade fails
Previous
 
Next
New Post
10/26/2006 8:07 AM
 
I get the error below when upgrading from DNN 4.0.3 to 4.3.5.

After the upgrade I cannot login. I copied the keys to the new web.config so this should not be the problem. The last error logged in the EventLog is shown at the bottom of this post.

Any suggestions?


System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Applications'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Membership'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Users'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Applications'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Membership'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Users'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
   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)


/* Transfer Users  */
/*******************/

If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
    BEGIN
        --Create Temp Table to hold users
        CREATE TABLE dbo.TransferredUsers (
             [TransferredAppId] [uniqueidentifier] ,
             [Username] [nvarchar] (256) NULL
        )

        --Declare Variables
        DECLARE @PortalID int

        -- Transfer Super Users
        EXECUTE TransferUsersToSameContext N'DotNetNuke', NULL

        --Iterate through Portals to transfer users
        SELECT @PortalID = min(PortalID)
        FROM   dbo.Portals
        WHILE @PortalID IS NOT NULL
        BEGIN

            -- Transfer Portal Users
            EXECUTE TransferUsersToSameContext N'DotNetNuke', @PortalID

            SELECT @PortalID = min(PortalID)
            FROM   dbo.Portals
            WHERE  PortalID > @PortalID
        END

        --Drop temp objects
        DROP TABLE dbo.TransferredUsers
        DROP PROCEDURE dbo.TransferUsersToSameContext
    END


This is the error logged when I try to login:

<ArrayOfAnyType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <anyType xsi:type="LogDetailInfo">
        <name>AssemblyVersion</name>
        <value>04.03.05</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>PortalID</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>PortalName</name>
        <value>Brady &amp; Co.</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserID</name>
        <value>-1</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserName</name>
        <value />
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ActiveTabID</name>
        <value>35</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ActiveTabName</name>
        <value>Home</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>RawURL</name>
        <value>/dnnbrady/Home/tabid/35/ctl/Login/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>AbsoluteURL</name>
        <value>/dnnbrady/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>AbsoluteURLReferrer</name>
        <value>http://localhost/dnnbrady/Home/tabid/35/ctl/Login/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserAgent</name>
        <value>Mozilla/5.0 (Windows; U; Windows NT 5.2; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>DefaultDataProvider</name>
        <value>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ExceptionGUID</name>
        <value>d6bf0ce2-df2c-4ed0-9336-36905574f768</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>InnerException</name>
        <value>Object reference not set to an instance of an object.</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileName</name>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileLineNumber</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileColumnNumber</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Method</name>
        <value>DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>StackTrace</name>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Message</name>
        <value>
            DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---&gt; System.NullReferenceException: Object reference not set to an instance of an object.
            at DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin(Int32 portalId, String username, String password, String verificationCode, UserLoginStatus&amp; loginStatus)
            at DotNetNuke.Entities.Users.UserController.ValidateUser(Int32 portalId, String Username, String Password, String VerificationCode, String PortalName, String IP, UserLoginStatus&amp; loginStatus)
            at DotNetNuke.Modules.Admin.Security.Signin.cmdLogin_Click(Object sender, EventArgs e)
            at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
            at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
            at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
            at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
            at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
            at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
            --- End of inner exception stack trace ---
        </value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Source</name>
    </anyType>
</ArrayOfAnyType>


 
New Post
11/1/2006 7:59 AM
 
It seems that upgrading is fraught with danger :(

I write this post in the hope it may trigger some ideas that may help resolve the issue.


I have tried upgrading another site (from 4.0.3 to 4.3.5) which produced errors on the following SQL Provider updates:
3.2.3
3.3.1
4.3.1

In ordere to get these to run I deleted the content of the Folders and Files tables and ran the script manually.

I had assumed file syncronisation would re-populate these tables but this failed. I then found that I could not read the event log. A solution to the event log problem was found at http://support.dotnetnuke.com/issue/ViewIssue.aspx?ID=4273.

Further investigation lead me to import the deleted content of the Files and Folders tables. Sync still failed and File Manager in Admin and Host also produced an error. I then began comparing the folder structure on disk with that listed in the Folders table. I found quite a lot of folders listed in the Folders table that in fact did not exist on disk. These were mainly skin and container folders for the t-worx, XD and Salaro skins originally released with early versions of DNN.

I brought the Folders table in line with the structure on disk.  I could then see the folders listed in File Manager. However they all looked like parent folders. I then added "\" to the end of the folder names in the Folders table. File Manager then listed the folder structure correctly and the Syncronisation task runs successfully.

I still have one problem to solve: How do I get files to list in FIle Manager? The folder structure looks fine but no files are shown in any folder! The Files table is empty. WHat does Syncronisation actually do? Does it not populate the Files table? Will I have to populate this table manually?








 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.0.3 to 4.3.5 Upgrade fails4.0.3 to 4.3.5 Upgrade fails


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