DotNetNuke Tutorials and Articles

I have discovered this error to only occur on fresh installs of DNN 5.1.2. If you have upgraded to DNN 5.1.2 from a previous version of DotNetNuke 5+ you should not receive the error.

Below is a truncated version of the error I received:

Error: Site Settings is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'DefaultLanguage', table 'dnndev.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 'dnndev.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated....

I discovered that the error was caused  by no default value had been set on the Admin tab >> Other Settings >> Default Language dropdown.

To correct the error:

Step 1

While logged in as Host account, I went t   Admin Tab >> Languages.

Step 2.

I selected my choice of default language.

Step 3.

I edited the language and enabled it.

Step 4.

I returned to Admin Settings and the default language dropdown was now propagated.

Step 5.

I updated the Admin Settings and the error is corrected.

Enjoy,
Buck