Firebird database setup error

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.

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

1/1/2014 11:11:54 PM

savornicesei

Total Posts 3

View Posts

Firebird database setup error

Hi all,

I'm having issues setting up the latest deploy files of mojoPortal with embedded Firebird.

OS: Windows 7 32bit

DB: embedded Firebird x86, version 2.5.2.26540

mojoPortal: mojoportal-2-4-0-0-firebird-net40-deploymentfiles & latest source code from Hg

.NET 4.0

I've set it up as an application in local IIS.

/Setup/Default.aspx displays:

Probing system...
File system permissions ok.
FirebirdSql database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.1093750
Running script mojoportal-core - 2.2.7.9 - 00:00:02.2500000
Running script mojoportal-core - 2.2.8.0 - 00:00:02.2656250
Running script mojoportal-core - 2.2.8.1 - 00:00:02.2656250
Running script mojoportal-core - 2.2.8.2 - 00:00:02.2812500
Running script mojoportal-core - 2.2.8.3 - 00:00:02.2812500
Running script mojoportal-core - 2.2.8.4 - 00:00:02.2812500
Running script mojoportal-core - 2.2.8.5 - 00:00:02.3750000
Running script mojoportal-core - 2.2.8.6 - 00:00:02.3750000
Running script mojoportal-core - 2.2.8.7 - 00:00:02.3906250
Running script mojoportal-core - 2.2.8.8 - 00:00:02.3906250
Running script mojoportal-core - 2.2.8.9 - 00:00:02.4062500
Running script mojoportal-core - 2.2.9.0 - 00:00:02.4687500
Running script mojoportal-core - 2.2.9.1 - 00:00:02.5468750
Running script mojoportal-core - 2.2.9.2 - 00:00:02.5468750
Running script mojoportal-core - 2.2.9.3 - 00:00:02.6406250
Running script mojoportal-core - 2.2.9.4 - 00:00:02.6406250
Running script mojoportal-core - 2.2.9.5 - 00:00:02.8437500
Running script mojoportal-core - 2.2.9.6 - 00:00:02.8750000
Running script mojoportal-core - 2.2.9.7 - 00:00:02.8750000
Running script mojoportal-core - 2.2.9.8 - 00:00:02.8906250
Running script mojoportal-core - 2.2.9.9 - 00:00:02.9218750
Running script mojoportal-core - 2.3.0.0 - 00:00:02.9384765
Running script mojoportal-core - 2.3.0.1 - 00:00:02.9541015
Running script mojoportal-core - 2.3.0.2 - 00:00:02.9541015
Running script mojoportal-core - 2.3.0.3 - 00:00:02.9697265
Running script mojoportal-core - 2.3.0.4 - 00:00:02.9697265
Running script mojoportal-core - 2.3.0.5 - 00:00:02.9853515
Running script mojoportal-core - 2.3.0.6 - 00:00:03.0322265
Running script mojoportal-core - 2.3.0.7 - 00:00:03.0947265
Running script mojoportal-core - 2.3.0.8 - 00:00:03.1572265
Running script mojoportal-core - 2.3.0.9 - 00:00:03.1572265
Running script mojoportal-core - 2.3.1.0 - 00:00:03.2041015
Running script mojoportal-core - 2.3.1.1 - 00:00:03.2197265
Running script mojoportal-core - 2.3.1.2 - 00:00:03.4853515
Running script mojoportal-core - 2.3.1.3 - 00:00:03.4853515
Running script mojoportal-core - 2.3.1.4 - 00:00:03.4853515
Running script mojoportal-core - 2.3.1.5 - 00:00:03.5009765
Running script mojoportal-core - 2.3.1.6 - 00:00:03.5166015
Running script mojoportal-core - 2.3.1.7 - 00:00:03.5166015
Running script mojoportal-core - 2.3.1.8 - 00:00:03.5322265
Running script mojoportal-core - 2.3.1.9 - 00:00:03.5478515
Running script mojoportal-core - 2.3.2.0 - 00:00:03.5478515
Running script mojoportal-core - 2.3.2.1 - 00:00:03.7041015
Running script mojoportal-core - 2.3.2.2 - 00:00:03.7822265
Running script mojoportal-core - 2.3.2.3 - 00:00:03.7978515
Running script mojoportal-core - 2.3.2.4 - 00:00:03.8291015
Running script mojoportal-core - 2.3.2.5 - 00:00:03.8291015
Running script mojoportal-core - 2.3.2.6 - 00:00:03.9394531
Running script mojoportal-core - 2.3.2.7 - 00:00:03.9550781
Running script mojoportal-core - 2.3.2.8 - 00:00:03.9550781
Running script mojoportal-core - 2.3.2.9 - 00:00:03.9550781
Running script mojoportal-core - 2.3.3.0 - 00:00:03.9707031
Running script mojoportal-core - 2.3.3.1 - 00:00:03.9707031
Running script mojoportal-core - 2.3.3.2 - 00:00:04.0644531
Running script mojoportal-core - 2.3.3.3 - 00:00:04.2675781
Running script mojoportal-core - 2.3.3.4 - 00:00:04.3144531
Running script mojoportal-core - 2.3.3.5 - 00:00:04.3144531
Running script mojoportal-core - 2.3.3.6 - 00:00:04.3300781
Running script mojoportal-core - 2.3.3.7 - 00:00:04.3300781
Running script mojoportal-core - 2.3.3.8 - 00:00:04.3769531
Running script mojoportal-core - 2.3.3.9 - 00:00:04.3769531
Running script mojoportal-core - 2.3.4.0 - 00:00:04.3769531
Running script mojoportal-core - 2.3.4.1 - 00:00:04.4863281
Running script mojoportal-core - 2.3.4.2 - 00:00:04.5019531
Running script mojoportal-core - 2.3.4.3 - 00:00:04.5019531
Running script mojoportal-core - 2.3.4.4 - 00:00:04.5175781
Running script mojoportal-core - 2.3.4.5 - 00:00:04.5175781
Running script mojoportal-core - 2.3.4.6 - 00:00:04.5332031
Running script mojoportal-core - 2.3.4.7 - 00:00:04.5332031
Running script mojoportal-core - 2.3.4.8 - 00:00:04.5332031
Running script mojoportal-core - 2.3.4.9 - 00:00:04.5488281
Running script mojoportal-core - 2.3.5.0 - 00:00:04.8144531
Running script mojoportal-core - 2.3.5.1 - 00:00:04.8300781
Running script mojoportal-core - 2.3.5.2 - 00:00:04.8457031
Running script mojoportal-core - 2.3.5.3 - 00:00:04.8457031
Running script mojoportal-core - 2.3.5.4 - 00:00:04.8613281
Running script mojoportal-core - 2.3.5.5 - 00:00:04.8613281
Running script mojoportal-core - 2.3.5.6 - 00:00:04.8769531
Running script mojoportal-core - 2.3.5.7 - 00:00:04.8769531
Running script mojoportal-core - 2.3.5.8 - 00:00:04.8925781
Running script mojoportal-core - 2.3.5.9 - 00:00:04.8925781
Running script mojoportal-core - 2.3.6.0 - 00:00:05.0644531
Running script mojoportal-core - 2.3.6.1 - 00:00:05.1425781
Running script mojoportal-core - 2.3.6.2 - 00:00:05.1425781
Running script mojoportal-core - 2.3.6.3 - 00:00:05.1582031
Running script mojoportal-core - 2.3.6.4 - 00:00:05.2050781
Running script mojoportal-core - 2.3.6.5 - 00:00:05.2363281
Running script mojoportal-core - 2.3.6.6 - 00:00:05.3769531
Running script mojoportal-core - 2.3.6.7 - 00:00:05.3769531
Running script mojoportal-core - 2.3.6.8 - 00:00:05.5019531
Running script mojoportal-core - 2.3.6.9 - 00:00:05.5488281
Running script mojoportal-core - 2.3.7.0 - 00:00:05.5488281
Running script mojoportal-core - 2.3.7.1 - 00:00:05.5957031
Running script mojoportal-core - 2.3.7.2 - 00:00:05.6113281
Running script mojoportal-core - 2.3.7.3 - 00:00:05.8613281
Running script mojoportal-core - 2.3.7.4 - 00:00:05.8613281
Running script mojoportal-core - 2.3.7.5 - 00:00:05.8769531
Running script mojoportal-core - 2.3.7.6 - 00:00:05.8769531
Running script mojoportal-core - 2.3.7.7 - 00:00:05.8925781
Running script mojoportal-core - 2.3.7.8 - 00:00:06.0175781
Running script mojoportal-core - 2.3.7.9 - 00:00:06.0175781
Running script mojoportal-core - 2.3.8.0 - 00:00:06.1269531
Running script mojoportal-core - 2.3.8.1 - 00:00:06.1269531
Running script mojoportal-core - 2.3.8.2 - 00:00:06.1425781
Running script mojoportal-core - 2.3.8.3 - 00:00:06.1582031
Running script mojoportal-core - 2.3.8.4 - 00:00:06.1582031
Running script mojoportal-core - 2.3.8.5 - 00:00:06.1738281
Running script mojoportal-core - 2.3.8.6 - 00:00:06.1738281
Running script mojoportal-core - 2.3.8.7 - 00:00:06.2988281
Running script mojoportal-core - 2.3.8.8 - 00:00:06.2988281
Running script mojoportal-core - 2.3.8.9 - 00:00:06.3144531
Running script mojoportal-core - 2.3.9.0 - 00:00:06.3144531
Running script mojoportal-core - 2.3.9.1 - 00:00:06.3300781
Running script mojoportal-core - 2.3.9.2 - 00:00:06.4394531
Running script mojoportal-core - 2.3.9.3 - 00:00:06.4550781
Running script mojoportal-core - 2.3.9.4 - 00:00:06.5644531
Running script mojoportal-core - 2.3.9.5 - 00:00:06.5957031
Running script mojoportal-core - 2.3.9.6 - 00:00:06.7207031
Running script mojoportal-core - 2.3.9.7 - 00:00:06.7363281
Running script mojoportal-core - 2.3.9.8 - 00:00:06.9238281
Running script mojoportal-core - 2.3.9.9 - 00:00:06.9238281
Running script mojoportal-core - 2.4.0.0 - 00:00:06.9394531
Creating site with default settings... - 00:00:06.9707031
Creating roles and admin user... - 00:00:07.3925781
Configuring feature Html Content - 00:00:07.4707031
Configuring feature Site Statistics - 00:00:07.6435547
Configuring feature Child Page Site Map - 00:00:07.6748047
Configuring feature Newsletter Sign Up Form - 00:00:07.6748047
Configuring feature Recent Content - 00:00:07.7373047
An Error Occurred:arithmetic exception, numeric overflow, or string truncation
Source:FirebirdSql.Data.FirebirdClient
Stack Trace at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() at mojoPortal.Data.FBSqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) at mojoPortal.Data.DBModuleDefinition.UpdateModuleDefinitionSetting(Guid featureGuid, Int32 moduleDefId, String resourceFile, String groupName, String settingName, String settingValue, String controlType, String regexValidationExpression, String controlSrc, String helpKey, Int32 sortOrder) at mojoPortal.Business.ModuleDefinition.UpdateModuleDefinitionSetting(Guid featureGuid, Int32 moduleDefId, String resourceFile, String groupName, String settingName, String settingValue, String controlType, String regexValidationExpression, String controlSrc, String helpKey, Int32 sortOrder) at mojoPortal.Web.UI.Pages.SetupHome.SetupFeature(ContentFeature feature) at mojoPortal.Web.UI.Pages.SetupHome.SetupFeatures(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.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

In the log file the following entries exist:

2014-01-02 06:38:38,191 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2014-01-02 06:38:38,269 ERROR (null) - (null) - (null) - mojoPortal.Web.WebTaskManager - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_TASKQUEUE
At line 1, column 26 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_TASKQUEUE
At line 1, column 26
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
   at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters)
   at mojoPortal.Data.DBTaskQueue.DeleteCompleted()
   at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted)
2014-01-02 06:38:38,300 ERROR (null) - (null) - (null) - mojoPortal.Web.Global - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SYSTEMLOG
At line 1, column 26 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SYSTEMLOG
At line 1, column 26
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
   at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters)
   at mojoPortal.Data.DBSystemLog.DeleteOlderThan(DateTime cutoffDate)
   at mojoPortal.Web.Global.PurgeOldLogEvents()
2014-01-02 06:38:38,316 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_BANNEDIPADDRESSES
At line 1, column 44 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_BANNEDIPADDRESSES
At line 1, column 44
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar()
   at mojoPortal.Data.FBSqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters)
   at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2014-01-02 06:38:38,331 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SITEFOLDERS
At line 1, column 151 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SITEFOLDERS
At line 1, column 151
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
   at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters)
   at mojoPortal.Data.DBSiteSettings.GetSiteIdByFolder(String folderName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
2014-01-02 06:38:45,442 INFO 127.0.0.1 - en-US - /mojoportal_official/Setup/Default.aspx - mojoPortal.Business.SiteSettings - SiteSettings expandoProperties was null so nothing was saved

As a side note, to make firebird embedded work, i've created a new assembly that initializes itself (see http://haacked.com/archive/2010/05/16/three-hidden-extensibility-gems-in-asp-net-4.aspx/) and in the Initialize method I've added the website /bin path to the process environment PATH variable:

String path = System.Environment.GetEnvironmentVariable("PATH");
path = String.Concat(path, ";", System.Web.HttpRuntime.BinDirectory);
System.Environment.SetEnvironmentVariable("PATH", path, EnvironmentVariableTarget.Process);

Thank you!

1/2/2014 2:37:37 PM

Joe Audette

Total Posts 18439

View Posts

Re: Firebird database setup error

Hi,

Those tables that it is complaining are missing should have been created by the install scripts so I don't really know why you get those errors unless it is some difference with embedded version of firebird or something prevented those tables from being created.

you could look through the upgrade scripts under /Setup/applications/mojoportal-core/SchemaUpgradeScripts/firebird and find the ones that create those tables and then create them manually, maybe you could fix it that way.

The latest version of mojoportal from our source code repository works for me on my local machine using Firebird 2.5.0.26074 x64. When I tested just now I found an error in script version 2.4.0.1 for Firebird but I fixed that and pushed the fix to the repository. However it was not the same error as what you posted and not relevant to the 2.4.0.0 release package since it was in a newer script.

All I can guess is some problems with using the embedded version of Firebird which I cannot say is supported, it would be better to use the server version of Firebird for a web application.

Best,

Joe

1/2/2014 6:42:17 PM

savornicesei

Total Posts 3

View Posts

Re: Firebird database setup error

Hi Joe,

So you tested with the embedded 64-bit Firebird version and it worked?

I've had time today to test the 4.0 version of the FirebirdSql.Data.FirebirdClient.dll and it still barked at (looks like) the same tables but with different message:

Probing system...
File system permissions ok.
FirebirdSql database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.2031250
An Error Occurred:The type of the SQL statement could not be determinated.
Source:FirebirdSql.Data.FirebirdClient
Stack Trace at FirebirdSql.Data.Isql.FbBatchExecution.GetStatementType(String sqlStatement) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\Isql\FbBatchExecution.cs:line 1073 at FirebirdSql.Data.Isql.FbBatchExecution.Execute(Boolean autoCommit) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\Isql\FbBatchExecution.cs:line 178 at mojoPortal.Data.FBSqlHelper.ExecuteBatchScript(String connectionString, String pathToScriptFile) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 101 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\dbPortal.cs:line 705 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Business\DatabaseHelper.cs:line 327 at mojoPortal.Web.UI.Pages.SetupHome.RunSetupScript(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) in p:\avornicesei.com\avornicesei.com\Web\Setup\Default.aspx.cs:line 365 at mojoPortal.Web.UI.Pages.SetupHome.CreateInitialSchema(String applicationName) in p:\avornicesei.com\avornicesei.com\Web\Setup\Default.aspx.cs:line 292 at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() in p:\avornicesei.com\avornicesei.com\Web\Setup\Default.aspx.cs:line 127 at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) in p:\avornicesei.com\avornicesei.com\Web\Setup\Default.aspx.cs:line 88 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2014-01-03 02:25:19,164 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Global.asax.cs Application_End
2014-01-03 02:25:29,883 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2014-01-03 02:25:30,023 ERROR (null) - (null) - (null) - mojoPortal.Web.WebTaskManager - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_TASKQUEUE
At line 1, column 26 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_TASKQUEUE
At line 1, column 26
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 520
at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 141
at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 126
at mojoPortal.Data.DBTaskQueue.DeleteCompleted() in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\DBTaskQueue.cs:line 439
at mojoPortal.Business.TaskQueue.DeleteCompleted() in p:\avornicesei.com\mojoPortal_src\mojoPortal.Business\TaskFramework\TaskQueue.cs:line 375
at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted) in p:\avornicesei.com\avornicesei.com\Web\Components\WebTaskManager.cs:line 453
2014-01-03 02:25:30,039 ERROR (null) - (null) - (null) - mojoPortal.Web.Global - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SYSTEMLOG
At line 1, column 26 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SYSTEMLOG
At line 1, column 26
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 520
at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 141
at mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 126
at mojoPortal.Data.DBSystemLog.DeleteOlderThan(DateTime cutoffDate) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\DBSystemLog.cs:line 188
at mojoPortal.Business.SystemLog.DeleteOlderThan(DateTime cutoffDate) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Business\SystemLog.cs:line 72
at mojoPortal.Web.Global.PurgeOldLogEvents() in p:\avornicesei.com\avornicesei.com\Web\Global.asax.cs:line 206
2014-01-03 02:25:30,039 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_BANNEDIPADDRESSES
At line 1, column 44 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_BANNEDIPADDRESSES
At line 1, column 44
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 633
at mojoPortal.Data.FBSqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 212
at mojoPortal.Data.FBSqlHelper.ExecuteScalar(String connectionString, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 195
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\dbBannedIP.cs:line 230
at mojoPortal.Business.BannedIPAddress.IsBanned(String ipAddress) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Business\BannedIPAddress.cs:line 177
at mojoPortal.Web.BannedIPBlockingHttpModule.IsBanned(String ip) in p:\avornicesei.com\avornicesei.com\Web\Components\BannedIPBlockingHttpModule.cs:line 241
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e) in p:\avornicesei.com\avornicesei.com\Web\Components\BannedIPBlockingHttpModule.cs:line 79
2014-01-03 02:25:30,054 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SITEFOLDERS
At line 1, column 151 ---> Dynamic SQL Error
SQL error code = -204
Table unknown
MP_SITEFOLDERS
At line 1, column 151
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 560
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 189
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\FBSqlHelper.cs:line 161
at mojoPortal.Data.DBSiteSettings.GetSiteIdByFolder(String folderName) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Data.FirebirdSql\dbSiteSettings.cs:line 2238
at mojoPortal.Business.SiteSettings.GetSiteIdByFolder(String folderName) in p:\avornicesei.com\mojoPortal_src\mojoPortal.Business\SiteSettings.cs:line 2702
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache() in p:\avornicesei.com\avornicesei.com\Web\Components\CacheHelper.cs:line 425
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext() in p:\avornicesei.com\avornicesei.com\Web\Components\CacheHelper.cs:line 406
at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentSiteSettings() in p:\avornicesei.com\avornicesei.com\Web\Components\CacheHelper.cs:line 396
at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl) in p:\avornicesei.com\avornicesei.com\Web\Components\UrlRewriter.cs:line 401
at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app) in p:\avornicesei.com\avornicesei.com\Web\Components\UrlRewriter.cs:line 177
at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e) in p:\avornicesei.com\avornicesei.com\Web\Components\UrlRewriter.cs:line 69

I still have to try running the init script from isql and to create the db from code in hope that one of these will work.

1/3/2014 6:45:23 AM

Joe Audette

Total Posts 18439

View Posts

Re: Firebird database setup error

I did not say I tested embedded version of Firebird, I have the normal server version. I do not think the embedded version is appropriate for web applications and am not concerned about supporting it.

If you want a database platform that requires no installation of database software then consider using the SQL CE version of mojoPortal. SQL CE uses a single file for the database and there is no database software to install other than some dlls included in the bin folder.

But for any important site that expects a lot of traffic I would not use SQL CE, it is ok for low to moderate traffic sites.

1/5/2014 4:24:16 PM

savornicesei

Total Posts 3

View Posts

Re: Firebird database setup error

Hi Joe,

Thanks for your valuable input.

I narrowed down the issue to 2 inserts into MP_MODULEDEFINITIONSETTINGS table:

1. EXECUTE PROCEDURE MP_MODULEDEFINITIONSETTINGS_INS (?,?,?,?,?,?,?,?,?,?,?)
name: :ModuleDefID, type: Int32, size: 0, value: 5
name: :SettingName, type: String, size: 50, value: SearchableFeature
name: :SettingValue, type: String, size: 255, value: 881e4e00-93e4-444c-b7b0-6672fb55de10,026cbead-2b80-4491-906d-b83e37179ccf,38aa5a84-9f5c-42eb-8f4c-105983d419fb,74bdbcc2-0e79-47ff-bcd4-a159270bf36e,dc873d76-5bf2-4ac5-bff7-434a87a3fc8e,d572f6b4-d0ed-465d-ad60-60433893b401,5a343d88-bce1-43d1-98ae-b42d77893e7b,0cefbf18-56de-11dc-8f36-bac755d89593
name: :ControlType, type: String, size: 50, value: ISettingControl
name: :RegexValidationExpression, type: String, size: 0, value:
name: :FeatureGuid, type: String, size: 36, value: f889c7c8-78e1-4cd2-a4cd-a0723f9a7cf0
name: :ResourceFile, type: String, size: 255, value: Resource
name: :ControlSrc, type: String, size: 255, value: ~/Controls/SearchableFeatureFilterSetting.ascx
name: :HelpKey, type: String, size: 255, value:
name: :SortOrder, type: Int32, size: 0, value: 2000
name: :GroupName, type: String, size: 255, value:

2. EXECUTE PROCEDURE MP_MODULEDEFINITIONSETTINGS_INS (?,?,?,?,?,?,?,?,?,?,?)
name: :ModuleDefID, type: Int32, size: 0, value: 7
name: :SettingName, type: String, size: 50, value: SearchableFeature
name: :SettingValue, type: String, size: 255, value: 881e4e00-93e4-444c-b7b0-6672fb55de10,026cbead-2b80-4491-906d-b83e37179ccf,38aa5a84-9f5c-42eb-8f4c-105983d419fb,74bdbcc2-0e79-47ff-bcd4-a159270bf36e,dc873d76-5bf2-4ac5-bff7-434a87a3fc8e,d572f6b4-d0ed-465d-ad60-60433893b401,5a343d88-bce1-43d1-98ae-b42d77893e7b,0cefbf18-56de-11dc-8f36-bac755d89593
name: :ControlType, type: String, size: 50, value: ISettingControl
name: :RegexValidationExpression, type: String, size: 0, value:
name: :FeatureGuid, type: String, size: 36, value: 09c0b1fc-a92d-4f3c-9f9b-b167c82d6089
name: :ResourceFile, type: String, size: 255, value: Resource
name: :ControlSrc, type: String, size: 255, value: ~/Controls/SearchableFeatureFilterSetting.ascx
name: :HelpKey, type: String, size: 255, value:
name: :SortOrder, type: Int32, size: 0, value: 2000
name: :GroupName, type: String, size: 255, value:

The embedded version does not like the SettingValue but the superserver version on FB is ok with them all.

I believe it's an issue either with the .NET provider or with the Firebird Core so this topic can be closed.

Thank you and all the best.

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