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 07: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:121

--
2009-09-05 09: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 06: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:121

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

    --
    2009-09-12 03: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 11: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 06: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 Offline
    DNN Creative Support
    Nuke Master VI
    Nuke Master VI
    Posts:8996
    Avatar

    --
    2009-09-15 01: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 08: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 Offline
    DNN Creative Support
    Nuke Master VI
    Nuke Master VI
    Posts:8996
    Avatar

    --
    2009-09-15 01: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 02:43 PM
    I am using Standard DotNetNuke skin.
    Azhar RahiUser is Offline
    Nuke Newbie
    Nuke Newbie
    Posts:5

    --
    2009-09-17 07: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: Module Security permissions by Bhushan Gholap
    Thanks for the reply!!! I would definitely contact sales engineer team of DNN.
    RE: There's a tutorial for this somewhere by Eric W
    The error I got was the Connection Error(s): Index #: 0 Source: .Net SqlClient Data Provider
    RE: DNN 6 Modules Not Showing by Joseph Craig
    Where can I see this? If you'd like to send me some login credentials so that I can look, use the c
    RE: DNN 6 Modules Not Showing by Mike DeBaise
    No, modules are set to all viewers/users. Just cant figure this out, it really doesnt make any sense
    RE: Searching in DNN by Alex Ritter
    Will do Joseph. I'll let you know my findings.
    RE: DNN Blog module syndication by Aggiedan97
    The reason I bring it up - Lee had originally provided a tutorial regarding podcast submission to iT
    RE: installing DNN locally - problems with relative path by Joseph Craig
    Recently I discovered this very useful blog post: http://www.dotnetnuke.com/Resources/Blogs/EntryId
    installing DNN locally - problems with relative path by Prakasam Srinivasan
    Instead of making tests on my live site, I recently seen various tutorials concerning installing DNN
    RE: Moved site to subdomain, now no links work by Joseph Craig
    PortalAlias is a table in the DotNetNuke database. Normally you would adjust this on the Site Set
    RE: DNN 6 Modules Not Showing by Joseph Craig
    Did you also check the module permissions? Are the modules permissions such that only logged in use
    RE: Add to the menu with a custom module by Joseph Craig
    I can't tell you how to do this, but ... I'd think you could start with a version of the Mega menu i
    RE: Where is the Manage Profile default Properties required error message found? by Joseph Craig
    You'll find it in one of those resource files you can get at with the Language Editor. I'm not sure
    RE: Facebook Like Button by Joseph Craig
    You can get the code you need from Facebook and then you can paste it into an HTML module in HTML mo
    RE: Module Security permissions by Joseph Craig
    Just a thought -- as you are evaluating the Professional version of DotNetNuke, you might want to as
    RE: Module Security permissions by Joseph Craig
    The module permissions that you mention are for the module: Edit the module's settings, Delete the
    RE: Module permission does not work! by Joseph Craig
    When you login are you a member of the Administrators security role? I don't believe that you can d
    DNN 6 Modules Not Showing by Mike DeBaise
    Hello all. I created a skin for DNN 6 and noticed that only while I am logged in can I see the modul
    RE: URL login bypass by Joseph Craig
    If you want the private page to be protected, you are going to have to have some way of "logging in.
    RE: DNN Blog module syndication by Joseph Craig
    Sorry. I'm not really familiar with feedburner and I haven't had a chance to research this. While
    RE: Friendly URLs Broken by Joseph Craig
    Are you using a third party module to rewrite the URLs? If so, you may need an upgrade. Did you do
    You are not logged in.
    You must log in to access all 
    650+ videos, tutorials, podcasts, and more.
    RSS Feeds