Hi,

I am attempting to get a working copy of MojoPortal working in a development environment, but every time I click to run it I get the error: Object cannot be cast from DBNull to other types.  

This error is on line 877 of CacheHelper.cs. I am using Visual Studio Professional and the version of MojoPortal is whatever the newest version is as I just got the source code via TortoiseHg. My connection strings should be correct, and I am using MSSQL.

Thanks for any help you can provide

Andrew

I tried the steps you suggested, but I get the same exact error when right clicking the Default.aspx and clicking View In Browser. The only thing I can think that could contribute to this would be that the server in the connection string being used is to connect to a database that was already set up and used successfully on a development server. If worse comes to worst I will just create a local copy of the database, but it should connect just fine.

Thanks

That seems to have gotten me slightly farther. When I go to the Setup all processes run successfully, but then I get the same error when navigating to the home page.

Line 877:     pageDetails.ExpandOnSiteMap = Convert.ToBoolean(reader["ExpandOnSiteMap"]);

That is the line throwing the error. When I attempt to just continue through with debugger it just throws that error again, then does nothing. From there I can navigate to Setup, but then when going back to the home page it is the same thing.

That got a bit farther. Now I got a new error: Unrecognized Guid format.

Line 969:        pageDetails.PubTeamId = new Guid(reader["PubTeamId"].ToString());

And another error: Object cannot be cast from DBNull to other types.

Line 970:    pageDetails.IncludeInChildSiteMap = Convert.ToBoolean(reader["IncludeInChildSiteMap"]);

When I run the Setup it says that my db is up to date at version 2.3.6.6. Is there anywhere I can obtain the scripts to just update the database to wherever it needs to be? Who knows how many more of these errors I will get and I would hate to bother you with each individual one.

Thanks

Well after running those last two updates it appears to work. I need to copy my skin over to the correct folder, but beyond that it is displaying the page correctly. Odd that just that specific update script didn't work. Either way.

Thanks