Error when updating to mojoportal 2.4.0.2 Firebird .NET 4.0

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
2/21/2014 3:24:35 PM
chrislorico
Gravatar
Total Posts 12
View Posts

Error when updating to mojoportal 2.4.0.2 Firebird .NET 4.0

Hey Everyone,

Tried to do an update from a 2.3.X.X version to the latest greatest and ran into the following issue.

Any help would be greatly appreciated!

Welcome to mojoPortal Setup

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 needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.3.9.8 - 00:00:01.0021002
Running script mojoportal-core - 2.3.9.9 - 00:00:01.0961096
An Error Occurred:C:\00WEBSITES\InternalKB\Setup\applications\mojoportal-core\SchemaUpgradeScripts\firebirdsql\2.3.9.9\a_tables.config
Source:mojoPortal.Data
Stack Trace at mojoPortal.Data.FBSqlHelper.ExecuteBatchScript(String connectionString, String pathToScriptFile) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Web.UI.Pages.SetupHome.RunUpgradeScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2/22/2014 7:19:58 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error when updating to mojoportal 2.4.0.2 Firebird .NET 4.0

There should be more error detail in the log /Data/currentlog.config

I tested with a clean install on a new db and all the scripts ran for me, possibly some difference in version of Firbird.

I suggest look at the script file

C:\00WEBSITES\InternalKB\Setup\applications\mojoportal-core\SchemaUpgradeScripts\firebirdsql\2.3.9.9\a_tables.config

maybe try to execute it manually with FlameRobin or whatever query tool you use, and modify it if needed to solve a syntax error, then remove it and visit setup again to continue

Hope that helps,

Joe

2/22/2014 10:10:52 AM
chrislorico
Gravatar
Total Posts 12
View Posts

Re: Error when updating to mojoportal 2.4.0.2 Firebird .NET 4.0

Hey Joe,

That did the trick. I ran the script (and each of the subsequent scripts that failed) in IBExpert and they all went through successfully without erroring out. I then blanked out each of the failed script.config files and ran the setup page until it completed (or showed me the next failing script).

For your notes:

  • I was upgrading from 2.3.9.6 I believe 
  • I am running Firebird 2.5.026074
  • .NET 4.0 on IIS7 (Windows 2008 server)

The following scripts failed through the setup.aspx page but worked in IBExpert:

  • ~\SchemaUpgradeScripts\Firebirdsql\2.3.9.9\a_tables.config
  • ~\SchemaUpgradeScripts\Firebirdsql\2.4.0.1\a_tables.config
  • ~\SchemaUpgradeScripts\Firebirdsql\2.4.0.1\c_procs.config
  • ~\SchemaUpgradeScripts\Firebirdsql\2.2.0.3\00002tables.config

Thanks a bunch!

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