View Issue Details Jump to Notes ] Wiki ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0012478mantisbtdb oraclepublic2010-10-25 04:362014-05-16 15:01
Assigned Todregad 
PlatformOSOS Version
Product Version1.2.3 
Target Version1.3.xFixed in Version1.3.x 
Summary0012478: Installation with Oracle fails
DescriptionWhen installing Mantis with Oracle, the automated installation fails, with Fatal error: 401.
So I asked Mantis to generate SQL script which I runned manually. This failed again. I had to do 3 modifications on the script for installation runs to the end:

1. Replace “;;” (on lines “CREATE OR REPLACE TRIGGER … END;;” with “;\n/\nshow errors;” (not sure the show errors is needed). So the lines now look like:
show errors;

2. Replace the index name “idx_project_hierarchy_parent_id” with “idx_project_hierarchy_parnt_id”. I removed the last “e” because the identifier was initially too long for Oracle (limit: 30 characters).

3. Change the table name for the last “INSERT INTO mantis_config_table”. The table name is hard-coded. For Oracle, we need to change default table names because mantis prefix and table sufix creates identifiers too long.

Hope this will help doing a clean Oracle installation process…
TagsNo tags attached.
Attached Files

- Relationships
related to 0013713resolveddregad mantisbt Upgrade ADOdb library to latest version 
parent of 0013227resolveddregad mantisbt Oracle DB support multiple issues 
parent of 0017218assignedgrangeway Track DBAL replacement Oracle DB support multiple issues 
Not all the children of this issue are yet resolved or closed.

-  Notes
User avatar (0028860)
rombert (developer)
2011-05-27 11:08

Thank you for the report and suggested fix. Would you consider supplying a git patch, for proper attribution? If so, please see the instructions at [^] to get started.
User avatar (0028871)
sveyret (reporter)
2011-05-30 05:34

Sorry, I will not have time to make a patch for this issue, as my company finally abandoned the idea of using Mantis with Oracle.
User avatar (0028872)
rombert (developer)
2011-05-30 06:07

Thanks. Out of curiosity, have you abandoned the idea of using Mantis or just switched to another DB?
User avatar (0028873)
sveyret (reporter)
2011-05-30 07:08

We are actively using Mantis, but with MySQL…
I made some tests about Oracle, and based on those, we considered that there were too many risks switching to this it.
User avatar (0028875)
rombert (developer)
2011-05-30 07:44

OK, got it.
User avatar (0028885)
rombert (developer)
2011-06-01 06:36

I've reported the ';;' issue on the adodb forum at [^] .
User avatar (0031570)
dregad (developer)
2012-03-30 04:14

The adodb bug has been fixed upstream (in version 5.16)

- Related Changesets
MantisBT: master 2ce60e47
Timestamp: 2011-08-10 12:34:07
Author: dregad
Details ] Diff ]
Fix 0013227: Oracle database support (oci8)

Mantis 1.2.6 currently does not work with Oracle DB:
1. Installation:
1.1. Oracle DB autocreates PK, so index creation for same field forbidden
1.2. Oracle DB uses datetime literal format timestamp'YYYY-MM-DD HH-MI:SS'
1.3. Oracle DB don't allows altering field property NOT NULL into NOT NULL
1.4. Oracle DB max object length is 30 chars, so some index names must be reduced
1.5. Oracle DB means empty string as NULLs, so NOT NULL restriction must be disabled for some field
1.6. Oracle DB can resolve database server name through TNS, so database name cannot be required
2. General:
2.2. Direct DB query execution result accessing instead of db_fetch_array() 1.3. usage didn't works with Oracle DB
2.4. Oracle DB binds variable by name, so bind names in statement must be sorted to address them.
2.5. Oracle DB handles NULL/DEFAULT values with specific way.
2.6. Oracle DB returns NULL value as true PHP null
2.7. Oracle DB handles sequence access with specific syntax
2.8. Nothing returned by db_prepare_string() in case of oci8
2.9. Oracle DB max object length is 30 chars, so table names must be reduced
2.10. Oracle DB uses LOB literal format similar to mssql
2.11. GetRowAssoc returns empty field values with oci8, it's need to enable returning both associative and indexed arrays.

The original patch was provided by DKuranov. He reckons that this also resolves
issues 0006853, 0007644, 0010437, 0010996, 0011265, 0011270, 0011276, 0012152, 0012478

Porting to 1.3 - Conflicts:
mod - admin/install.php Diff ] File ]
mod - admin/schema.php Diff ] File ]
mod - core/database_api.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2010-10-25 04:36 sveyret New Issue
2011-05-27 11:05 rombert Assigned To => rombert
2011-05-27 11:05 rombert Status new => assigned
2011-05-27 11:08 rombert Note Added: 0028860
2011-05-27 11:08 rombert Status assigned => feedback
2011-05-27 11:08 rombert Target Version => 1.2.6
2011-05-28 04:00 rombert Description Updated View Revisions
2011-05-30 05:34 sveyret Note Added: 0028871
2011-05-30 05:34 sveyret Status feedback => assigned
2011-05-30 06:07 rombert Note Added: 0028872
2011-05-30 07:08 sveyret Note Added: 0028873
2011-05-30 07:44 rombert Note Added: 0028875
2011-06-01 06:36 rombert Note Added: 0028885
2011-06-28 10:46 rombert Target Version 1.2.6 => 1.3.x
2011-08-09 11:55 dregad Relationship added parent of 0013227
2012-03-30 04:14 dregad Note Added: 0031570
2012-03-30 04:14 dregad Relationship added related to 0013713
2013-10-17 12:08 dregad Changeset attached => MantisBT master 2ce60e47
2013-10-17 12:52 dregad Status assigned => resolved
2013-10-17 12:52 dregad Fixed in Version => 1.3.x
2013-10-17 12:52 dregad Resolution open => fixed
2013-10-17 12:58 dregad Assigned To rombert => dregad
2013-10-17 12:58 dregad Description Updated View Revisions
2014-04-12 19:39 grangeway Issue cloned: 0017191
2014-05-16 15:01 grangeway Note Added: 0040464
2014-05-27 17:57 atrol Note Deleted: 0040464

MantisBT 1.2.17 [^]
Copyright © 2000 - 2014 MantisBT Team
Time: 0.1125 seconds.
memory usage: 3,137 KB
Powered by Mantis Bugtracker