Hello,

I'm having huge problems with an internal company knowledge base that I've been using Mojoportal for.

Specifically, I upgraded from 2.3.9.4 for .NET 4.0 and Firebird to 2.3.9.5 and now our forums don't work. I've checked and found the data in the database.

When I try to click on an existing forum I get the following error:

Could not find specified column in results

[IndexOutOfRangeException: Could not find specified column in results.] FirebirdSql.Data.FirebirdClient.FbDataReader.GetOrdinal(String name) +342 FirebirdSql.Data.FirebirdClient.FbDataReader.get_Item(String name) +25 mojoPortal.Business.Forum.GetForum(Int32 forumId) +1534 mojoPortal.Business.Forum..ctor(Int32 forumId) +282 mojoPortal.Web.ForumUI.ForumParameterParser.Parse() +383 mojoPortal.Web.ForumUI.ForumView.LoadParams() +99 mojoPortal.Web.ForumUI.ForumView.Page_Load(Object sender, EventArgs e) +205 mojoPortal.Web.mojoBasePage.OnLoad(EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
 

When I try to create a new forum, I get the following error:

Dynamic SQL Error
Input parameter mismatch for procedure MP_FORUMS_INSERT

[IscException: Dynamic SQL Error Input parameter mismatch for procedure MP_FORUMS_INSERT] FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) +185 FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() +52 FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() +14 FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) +233 FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) +640 FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) +23 FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() +76 [FbException (0x140000f9): Dynamic SQL Error Input parameter mismatch for procedure MP_FORUMS_INSERT] FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() +323 mojoPortal.Data.FBSqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) +326 mojoPortal.Data.DBForums.Create(Guid forumGuid, Int32 moduleId, Int32 userId, String title, String description, Boolean isModerated, Boolean isActive, Int32 sortOrder, Int32 postsPerPage, Int32 threadsPerPage, Boolean allowAnonymousPosts) +2227 mojoPortal.Business.Forum.Create() +521 mojoPortal.Web.ForumUI.ForumEdit.btnUpdate_Click(Object sender, EventArgs e) +396 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707
 

The upgrade to 2.3.9.5 went through smoothly without any issues. I've upgraded before (from 2.3.9.0 to 2.3.9.4) and it was fine.

I'm currently running mojoportal on a Windows 2008 server with Firebird 2.5, mojoportal 2.3.9.5, and .NET 4.0.

Any help would be greatly appreciated!

Hey Joe,

Schema version is 2.2.0.1.

I went back into the setup page and got the following:

Probing system...
File system permissions ok.
FirebirdSql database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema is up to date.
1 site(s) found.
Configuring feature Html Content - 00:00:00.1040059
Configuring feature Site Statistics - 00:00:00.2920167
Configuring feature Child Page Site Map - 00:00:00.3380193
Configuring feature Newsletter Sign Up Form - 00:00:00.3440196
Configuring feature Recent Content - 00:00:00.6510372
Configuring feature Sign In Module - 00:00:00.7110406
Configuring feature Site Search - 00:00:00.7170410
Configuring feature Bing Map - 00:00:00.7370421
Configuring feature Blog - 00:00:00.8580490
Configuring feature Comments - 00:00:01.3370764
Configuring feature Contact Form - 00:00:01.4080805
Configuring feature Event Calendar - 00:00:01.4950855
Configuring feature Feed Manager - 00:00:01.5730899
Configuring feature Flickr Slide Show - 00:00:01.7661010
Configuring feature Flickr Gallery - 00:00:01.8101035
Configuring feature Image Gallery (Simple Folder Version) - 00:00:01.8691069
Configuring feature Forums - 00:00:01.9491114
Configuring feature Google Map - 00:00:02.0561176
Configuring feature Google Translate - 00:00:02.1671239
Configuring feature Html Fragment Include - 00:00:02.2061261
Configuring feature IFrame - 00:00:02.2381280
Configuring feature Image Gallery - 00:00:02.3691355
Configuring feature Audio Player - 00:00:02.5941483
Configuring feature Video Player - 00:00:02.6381509
Configuring feature List/Links - 00:00:02.7011545
Configuring feature Poll - 00:00:02.7961599
Configuring feature Shared Files - 00:00:02.8561633
Configuring feature Survey - 00:00:02.9651696
Configuring feature Twitter Profile Widget - 00:00:02.9811705
Configuring feature Twitter Search Widget - 00:00:03.0591749
Configuring feature Xml/Xsl - 00:00:03.1651810
Ensuring all features are installed in server admin sites... - 00:00:03.2141838
Setup is complete, click the link below to go to the home page.
Site Home Page

Database PlatformFirebirdSql
Version2.3.9.5
StatusYour installation is up to date.
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

Hey Joe,

I can get to the firebirdsql directory but there is no 2.2.0.2 directory (only a 0.0.0.8 directory). There is a 2.2.0.1.config file (but no 2.2.0.2.config file).

Checked with my backup of 2.3.9.4 and I didn't have that directory then either. I then checked the deployment files and that directory doesn't exist.

Can you point me in the right direction for where I can get the correct scripts?

Morning Joe,

Unfortunately, I spoke to soon. Although I see the list of forum posts, I can't post anything new or add to any existing threads. When I try, I get the following:

Object reference not set to an instance of an object.

[NullReferenceException: Object reference not set to an instance of an object.]
   mojoPortal.Web.ForumUI.PostList.PopulateLabels() +854
   mojoPortal.Web.ForumUI.PostList.Page_Load(Object sender, EventArgs e) +43
   System.Web.UI.Control.LoadRecursive() +70
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Control.LoadRecursive() +189
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3063
 

With regards to running scripts, I downloaded the 2.2.0.2 directory and the 2.2.0.2.config file under schemaupgradescripts/firebirdsql and then ran the setup/default.aspx page. Was there anything else that I needed to do to ensure that it worked?

As well (and I can start a new post if you would like), I'm getting another reported issue where when a person creates a new webpage, and then immediately hits save after creating the page, they get the following error:

Must declare the variable '@MenuDesc'

[FbException (0x80004005): Must declare the variable '@MenuDesc']
   FirebirdSql.Data.FirebirdClient.FbCommand.UpdateParameterValues() +2051
   FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) +251
   FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() +287
   mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) +227
   mojoPortal.Data.DBPageSettings.UpdatePage(Int32 siteId, Int32 pageId, Int32 parentId, String pageName, String pageTitle, String skin, Int32 pageOrder, String authorizedRoles, String editRoles, String draftEditRoles, String createChildPageRoles, String createChildDraftRoles, Boolean requireSsl, Boolean allowBrowserCache, Boolean showBreadcrumbs, Boolean showChildPageBreadcrumbs, String pageKeyWords, String pageDescription, String pageEncoding, String additionalMetaTags, Boolean useUrl, String url, Boolean openInNewWindow, Boolean showChildPageMenu, Boolean hideMainMenu, Boolean includeInMenu, String menuImage, String changeFrequency, String siteMapPriority, Guid parentGuid, Boolean hideAfterLogin, String compiledMeta, DateTime compiledMetaUtc, Boolean includeInSiteMap, Boolean isClickable, Boolean showHomeCrumb, Boolean isPending, String canonicalOverride, Boolean includeInSearchMap, Boolean enableComments, Boolean includeInChildSiteMap, Boolean expandOnSiteMap, Guid pubTeamId, String bodyCssClass, String menuCssClass, Int32 publishMode, DateTime createdUtc, Guid createdBy, Guid lastModBy, String lastModFromIp, String menuDescription) +9282
   mojoPortal.Business.PageSettings.Update() +1630
   mojoPortal.Web.AdminUI.PageProperties.SavePageData() +5229
   mojoPortal.Web.AdminUI.PageProperties.Apply_Click(Object sender, EventArgs e) +38
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707
 

At this point, I think there are several scripting problems that must have failed so I'm adding the details of my system info found in my mojoportal site:

Administration Menu > System Information

System Information

mojoPortal Version 2.3.9.5 FirebirdSql
Operating System Microsoft Windows NT 6.1.7601 Service Pack 1
ASP.NET Info v4.0.30319 Running in Full Trust
Server Time Zone Eastern Standard Time
Server Local Time (GMT -5) 3/1/2013 9:55:03 AM
Greenwich Mean Time (GMT/UTC) 3/1/2013 2:55:03 PM

Feature Versions [Help]

Feature Schema Version
blog 2.6.0.7
contactform 0.0.0.6
eventcalendar 0.0.0.6
feed-manager 0.0.1.0
forums 2.2.0.2
imagegallery 0.0.0.8
kdmediaplayer 1.0.0.1
linksmodule 0.0.0.9
mojoportal-core 2.3.9.5
pollfeature-byChristianFredh 0.0.0.5
sharedfiles 0.0.1.0
surveyfeature 1.8.0.0

Hey Joe,

We can now edit the posts but after creating a new thread, I can no longer edit the thread. This is the error I'm getting:

Object reference not set to an instance of an object.

[NullReferenceException: Object reference not set to an instance of an object.]
   mojoPortal.Web.ForumUI.ForumThreadEdit.PopulateControls() +207
   mojoPortal.Web.ForumUI.ForumThreadEdit.Page_Load(Object sender, EventArgs e) +488
   mojoPortal.Web.mojoBasePage.OnLoad(EventArgs e) +24
   System.Web.UI.Control.LoadRecursive() +70
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3063
 

I'm really sorry for being a pain. I'm just going through each function now so that we're in the clear.

Thanks Joe, looks like this last file took care of it.

No worries about the Firebird package, we're doing an internal knowledge base to get the kinks out before we make an attempt at doing a client facing portal. So we'll always test the latest package internally before we try it with a client.

I'll give you as much feedback as much as I can!