Problems getting Dev copy working with Visual Studio 2010

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
6/27/2011 10:11:14 AM
abavery
Gravatar
Total Posts 16
View Posts

Re: Problems getting Dev copy working with Visual Studio 2010

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

6/27/2011 10:16:59 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Problems getting Dev copy working with Visual Studio 2010

That one is also from the 2.3.6.0 script which has this:

 

UPDATE mp_Pages
SET IncludeInChildSiteMap = IncludeInSiteMap
 
from the same script my guess is you will also need this:
 
UPDATE mp_Modules
SET IsGlobal = 0
 
If you get others you can note the field and then look in the recent upgrade scripts to find where it should have been populated.
 
The scripts are at /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql
 
If you ran these scripts successfully then I have no idea why these fragments did not work the first time.
6/27/2011 10:21:21 AM
abavery
Gravatar
Total Posts 16
View Posts

Re: Problems getting Dev copy working with Visual Studio 2010

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

6/27/2011 10:44:06 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Problems getting Dev copy working with Visual Studio 2010

It is odd, especially because it actually did run the script since the same script is what added the columns, it just somehow didn't run the parts of the script that update the data. I know I've seen this at least once before here in the forums but on my machine the scripts work correctly and I think for most people it has worked fine otherwise we'd have a lot more reports of it. Wish I could pin down exactly why and how it happens.

Anyway, glad its working.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.