Hi,

I tried doing a test upgrade from 4.5.0 to 4.8.0 on my local machine (using the db backup from the live site) and I got the error below.  It's in the 04.06.00.log file.  Does anyone have an idea of what the problem is here?

Norman

****************************

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ModuleID', table 'clearcanvas.dbo.easycgi_dnn_ModuleSettings'; column does not allow nulls. UPDATE fails.
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)


/* Update UseCaptcha Settings to use the Authentication Module instead of User Accounts */
/****************************************************************************************/

BEGIN
    CREATE TABLE #AuthModules
    (
        ModuleID int,
        PortalID int,
        AuthModuleID int
    )

    -- Insert into our temp table
    INSERT INTO #AuthModules (ModuleID, PortalID, AuthModuleID )
        SELECT    
            m.ModuleID,
            m.PortalID,
            (SELECT ModuleID
                FROM dbo.easycgi_dnn_Modules MI
                    INNER JOIN dbo.easycgi_dnn_ModuleDefinitions MDef ON MI.ModuleDefID = Mdef.ModuleDefID
                WHERE (MI.PortalID = m.PortalID) AND (MDef.FriendlyName = 'Authentication'))
            AS AuthModuleID
        FROM dbo.easycgi_dnn_Modules AS m
            INNER JOIN dbo.easycgi_dnn_ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefID
        WHERE (md.FriendlyName = N'User Accounts')
            AND PortalID IS NOT NULL

    UPDATE dbo.easycgi_dnn_ModuleSettings
        SET ModuleID = a.AuthModuleID,
            SettingName = 'DNN_UseCaptcha'
    FROM dbo.easycgi_dnn_ModuleSettings s
        LEFT JOIN #AuthModules a ON a.ModuleID = s.ModuleID
    WHERE SettingName = 'Security_CaptchaLogin'
        AND a.PortalID IS NOT NULL

    -- Drop temp table
    DROP TABLE #AuthModules

END

Hi,

Thanks for the reply.  I don't believe I have a module called easycgi.  easycgi is just the table prefix that my hosting provider (Easy CGI) attaches to each table.  My knowledge of SQL is sadly quite basic and I'm not sure exactly what this script is supposed to do.  Would you happen to know what it's trying to do?

Norman

Hi,

Thanks again for taking the time to help.  I executed the following to see what the true issue is:

SELECT ModuleID
FROM dbo.easycgi_dnn_Modules MI
INNER JOIN dbo.easycgi_dnn_ModuleDefinitions MDef ON MI.ModuleDefID = Mdef.ModuleDefID
WHERE (MDef.FriendlyName = 'Authentication'))

It returns null, which explains my problem.  Question is why.  It seems that it's looking for module definition in the Module Definition table whose friendly name is "Authentication".  It finds it, but then when it tries to find the corresponding Module Definition ID in the Modules table, it doesn't find it, and so the query returns null.  I noticed that the "Authentication" module wasn't present in my old 4.5.0 database; it was called "Windows Authentication" in that version, so it appears that the script added it.  Might this be a bug?

Norman