| Author |
Messages |
|
Aggiedan97
Nuke Pro
Posts:74
 |
| 05 Sep 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
Posts:74
|
|
Aggiedan97
Nuke Pro
Posts:74
|
| 06 Sep 2009 5:16 AM |
|
That did it!
Thanks,
Dan |
|
|
|
|
Jason
Nuke Newbie
Posts:1
|
| 12 Sep 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/ViewIssue.aspx?id=10707
It worked for me on a new install of 5.1.2!
Jason |
|
|
|
|
MikePixel
DNN Creative Magazine Subscriber
Nuker
Posts:13
|
| 14 Sep 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/ViewIssue.aspx?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
Posts:5
|
| 14 Sep 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 Creative Staff
Nuke Master VI
Posts:6139
|
| 14 Sep 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
DNN Creative Support
Subscribe to the website |
|
|
Azhar Rahi
Nuke Newbie
Posts:5
|
| 15 Sep 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 Creative Staff
Nuke Master VI
Posts:6139
|
| 15 Sep 2009 7:51 AM |
|
OK. Are you using a standard DotNetNuke skin, or are you using a custom or purchased skin?
|
|
Joe Craig
DNN Creative Support
Subscribe to the website |
|
|
Azhar Rahi
Nuke Newbie
Posts:5
|
| 15 Sep 2009 8:43 AM |
|
| I am using Standard DotNetNuke skin. |
|
|
|
|
Azhar Rahi
Nuke Newbie
Posts:5
|
| 17 Sep 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 ... |
|
|
|
|
|