View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006895 | mantisbt | db oracle | public | 2006-03-29 05:06 | 2014-12-08 00:34 |
Reporter | mechantflou | Assigned To | dregad | ||
Priority | normal | Severity | feature | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.0.1 | ||||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0006895: install mantis with oracle (driver oci8) | ||||
Description | list of file you have to modify config-inc.php ****config-inc.php keep $g_hostname blank $g_hostname=''; ****install.php add in line 211 in switch($f_db_type) case 'oci8: add in the driver list this line <option value="oci8">Oracle(oci8)</option> ****custom_field-api.php replace the query in line 629 with
**database-api.php add in function db_helper_compare_days case 'oci8' : return "(($p_date1 - $p_date2)".$p_limitstring.")"; Really, with all issues, mantis run with database oracle | ||||
Tags | No tags attached. | ||||
You need also modify prefix and suffix db table in config-inc.php because table name can be too long and generate much errors with oracle ****line 1199 |
|
What was wrong with the original custom fields query? I've noticed that the only difference is that in the original version there was "name as alias" rather than "name alias". I also didn't apply the change for shortening the table prefix and suffix, is this really required? If so, then we need to change the install the use such short prefixes for Oracle when config_inc.php doesn't exist. |
|
The database_api.php and install.php changes are now committe in CVS and will be included in Mantis v1.1. |
|
this is the message The following error has occurred: ORA-00972: identifier is too long |
|