You need to Register for free and Login to post a message in the forum.

Forum

New DNN 5.01.02 (51) Install - Can Not Update Admin Site Settings
Last Post 2009-09-17 06:19 AM by Azhar Rahi. 10 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Aggiedan97User is Offline
Nuke Master
Nuke Master
Posts:136

--
2009-09-05 08: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 KaziUser is Offline
    Nuke Pro
    Nuke Pro
    Posts:70
    Avatar

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

    --
    2009-09-06 10:16 AM
    That did it!
    Thanks,
    Dan
    JasonUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:1

    --
    2009-09-12 02:57 PM
    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
    MikePixelUser is Offline
    Nuke Active Member
    Nuke Active Member
    Posts:26
    Avatar

    --
    2009-09-14 10: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 RahiUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:5

    --
    2009-09-14 05: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 CraigUser is Online
    DNN Creative Support
    Nuke Master VI
    Nuke Master VI
    Posts:9309
    Avatar

    --
    2009-09-15 12:22 AM
    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, DNN Creative Support

    Subscribe to DNNCreative
    I recommend PowerDNN for DotNetNuke Hosting.
    Azhar RahiUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:5

    --
    2009-09-15 07: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 CraigUser is Online
    DNN Creative Support
    Nuke Master VI
    Nuke Master VI
    Posts:9309
    Avatar

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

    Joe Craig, DNN Creative Support

    Subscribe to DNNCreative
    I recommend PowerDNN for DotNetNuke Hosting.
    Azhar RahiUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:5

    --
    2009-09-15 01:43 PM
    I am using Standard DotNetNuke skin.
    Azhar RahiUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:5

    --
    2009-09-17 06: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 ...
    You are not authorized to post a reply.


    Active Forums 4.3

    Latest Forum Posts

    RE: Unable to Create Skin Package by schilders
    Joe, When I click the Edit icon next to the skin package on the Host Extensions page, I receive t
    horizontal main and submenu items by Dan Glanton
    I found a very good tutorial on horizontal main and subitems in DNN Creative, but what about if you
    RE: Skin creation - Menu questoni by Joseph Craig
    This has to do with the structure of the elements that make up the skin and the CSS. Most likely, y
    Skin creation - Menu questoni by CDMeyer
    I have a skin and when I add more menu items to the nav bar than can fit in one row of nav, the seco
    RE: FCK Editor in DNN 6 by Pingle2009
    Just to follow on from Joe's reply, the 'official' line seems to be that not only that the old FCK E
    RE: Slice a Site by Dan Glanton
    Thanks, I'll look into that when I get a chance.
    RE: Creating structured page content by Stephen Bugden
    Thankyou very much Joe, I will take a look at your suggestions.
    RE: Subpages or dropdowns navigation is going behind this flash by Joseph Craig
    I googled a bit and found that this is a messy problem. Possibly the best solution will be to giv
    RE: Subpages or dropdowns navigation is going behind this flash by vijendra
    Pls check the attachment. That Iframe code we are using and subnavigations are goind behind that.
    RE: Rename or move site from domain name to subdomain name by Bill Quinn
    Hi Joseph, Thank you so much for your reply. I will be able to implement this later in the we
    RE: Creating structured page content by Joseph Craig
    Take a look at the DotNetNuke Reports Module, the DotNetNuke Form & List Module, SGSV from Tresslewo
    RE: Subpages or dropdowns navigation is going behind this flash by Joseph Craig
    It looks like your iframed content may have a z-index that puts it on top of the menu. I can't id
    Subpages or dropdowns navigation is going behind this flash by vijendra
    Hi, Subpages or dropdowns navigation is going behind this flash. Pls check the url below http://www.
    RE: user adding images by rod lloyd
    That worked, thank you. I did not expect those permissions to be in File Manager. I note a
    RE: Unable to Create Skin Package by Joseph Craig
    To be quite honest, I've never used this functionality to create a skin. What I usually do is cre
    RE: Unable to Create Skin Package by Joseph Craig
    I'm confused by this, too.
    RE: Unable to Create Skin Package by schilders
    We are running DNN 6.x
    RE: Unable to Create Skin Package by Joseph Craig
    Which version of DotNetNuke are you using?
    RE: Deploying dnn by Joseph Craig
    You should be able to use CE even if you have a high traffic site. To develop your site without p
    RE: Rename or move site from domain name to subdomain name by Joseph Craig
    It is easy. 1. Go to Admin, Site settings and add a Portal Alias for new.websitename.com 2.
    You are not logged in.
    You must log in to access all 
    650+ videos, tutorials, podcasts, and more.
    RSS Feeds