New DNN 5.01.02 (51) Install - Can Not Update Admin Site Settings
Last Post 09/17/2009 1:19 AM by Azhar Rahi. 10 Replies.
Author Messages
Aggiedan97
Nuke Master
Nuke Master
Posts:162


--
09/05/2009 3:28 PM
    New Install; no install errors; working great. Attempted to update the Admin Site Settings and received an error. Went back and attempted to select 'Update' without changing anything and still received the error below: Error: Site Settings is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'DefaultLanguage', table '(actualdomainnameremoved).dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'DefaultLanguage', table '(actualdomainnameremoved).dbo.Portals'; 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory, Int32 lastModifiedByUserID) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory) at DotNetNuke.Modules.Admin.Portals.SiteSettings.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
    Rashid Kazi
    Nuke Pro
    Nuke Pro
    Posts:70


    --
    09/06/2009 12:01 AM
    Goto Admin > Site Settings > Advanced Settings > Other Settings, and Check the Default Language is NOT Null or Selected as English (United States).
    Aggiedan97
    Nuke Master
    Nuke Master
    Posts:162


    --
    09/06/2009 5:16 AM
    That did it!
    Thanks,
    Dan
    Jason
    Nuke Newbie
    Nuke Newbie
    Posts:1


    --
    09/12/2009 9:57 AM
    If there is no language option in the dropdown menu, you can follow this link and run the suggested script to resolve the Language null issue: http://support.dotnetnuke.com/issue...x?id=10707

    It worked for me on a new install of 5.1.2!
    Jason
    MikePixel
    Nuke Active Member
    Nuke Active Member
    Posts:26


    --
    09/14/2009 5:13 AM
    Workaround:

    1.Go to the Admin/Languages page
    2.Click on the Edit Languages link in the upper left corner of the module
    3.Select a language from the Dropdown list.
    4.Check the enabled checkbox
    5.Click the update button.


    Which is at the bottom of the http://support.dotnetnuke.com/issue...x?id=10707 page that Jason posted. I did this and it worked to get rid of my admin settings page error.
    MikePixel
    CornerPixel
    Azhar Rahi
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    09/14/2009 12:40 PM
    Unbelievably, when I go to Edit Languages in Admin/Languages, there is no dropdown of languages. Only Language label as well as Fallback Language label is shown. No dropdowns. Only Enabled checkbox is shown there. Whats the problem behind this ?
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    09/14/2009 7:22 PM
    Step 1:

    "go to Admin :: languages, and add "English (United States)". Make sure, it is enabled for your portal. you now may set it to be default language in site settings and in your user profile. subsequently, you are able to disable any other language."

    If that doesn't work ...

    Step 2:

    Follow the instructions in Peter Donker's blog here.

    Joe Craig, Patapsco Research Group
    Complete DNN Support
    Azhar Rahi
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    09/15/2009 2:15 AM
    Thanks Joe Craig. The query in step 2 ran fine. But the problem still exits.
    I wanted to say that no dropdown is VISIBLE in the Edit Language page. So how can I select "English (United States)" as default language? Empty dropdown is another thing, at least you can see DROPDOWN on the page either empty or filled. But there is no Dropdown visible on the page .... why is this happening ?
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    09/15/2009 7:51 AM
    OK.  Are you using a standard DotNetNuke skin, or are you using a custom or purchased skin?

    Joe Craig, Patapsco Research Group
    Complete DNN Support
    Azhar Rahi
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    09/15/2009 8:43 AM
    I am using Standard DotNetNuke skin.
    Azhar Rahi
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    09/17/2009 1:19 AM
    Well the problem has been resolved. Now "English(United States)" is visible in the dropdown.
    However I did nothing special to resolve it. After running the step 2, I closed the Explorer and hence removed all sessions. After getting logged in, When I visited the Admin -> Languages page, I found "English(United States)" there in the dropdown.
    Thanks for help ...


    ---