Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Settings Error
Last Post 11/02/2007 12:20 AM by Peter Donker. 4 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Greg
New Member
New Member
Posts:5


--
10/31/2007 6:40 PM

Hello,

When I try to access the module settings I get the following error:

Error: Module is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Conversion from type 'DBNull' to type 'String' is not valid. ---> System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid. at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) at Bring2mind.DNN.Modules.DMX.Business.EntriesController.a(DataTable& A_0, Int32 A_1, Int32 A_2, Int32 A_3, String A_4, Char A_5) at Bring2mind.DNN.Modules.DMX.Business.EntriesController.GetStructuredCollectionList(Int32 PortalId, String Locale, Char IndentString) at Bring2mind.DNN.Modules.DMX.Controls.Admin.Settings.LoadSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

 

I'm running DNN 4.05.03 and DMX 04.00.03. 

--Greg

 

 

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
10/31/2007 10:36 PM
Hi Greg,
I guess there must be folders without a name. I'm not sure how this can happen. Can you upgrade to 04.00.06 and see if this helps? I'll see about making the procedure more robust.
If upgrades don't help then please run the following statement in SQL and let me know what the results are:

SELECT e.EntryId, (SELECT COUNT(*) FROM dbo.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='') AS Titles
FROM DMX_Entries e
WHERE e.EntryType LIKE 'Collection%'

This shows a list of all folders with the number of titles. It should show '1' in the Titles column for each one. Is that so?

Peter
Greg
New Member
New Member
Posts:5


--
10/31/2007 11:26 PM

Hi Peter,

I just downloaded 4.00.06 and am installing it now. I ran the query you gave and the result was all zeros for the 'Titles' column.

--Greg

 

Greg
New Member
New Member
Posts:5


--
11/01/2007 12:55 AM

Just installed the new version and all seems OK. Thanks for your help Peter.

--Greg

 

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
11/02/2007 12:20 AM
Hi Greg,
Good. Note: If you did a DMX 3 to DMX 4 upgrade make sure you've run the upgrade scripts first!! These scripts reconstruct all the names in the new datamodel.
Peter
You are not authorized to post a reply.