View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0009792 | mantisbt | db mssql | public | 2008-11-09 14:24 | 2014-05-16 15:00 |
| Reporter | corny | Assigned To | thraxisp | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.1.4 | ||||
| Fixed in Version | 1.2.0a3 | ||||
| Summary | 0009792: SQL function DESCRIBE does not exist for MSSQL 2000 | ||||
| Description | In admin/upgrade_inc.php function admin_check_applied() on line 35
the command DESCRIBED is used. This command does not exist in MSSQL 2000. I'm not sure about the purpose of admin_check_applied(). If it only check the existence of a table and a cell then line 35 could be replaced with this fragment which looks into INFORMATION_SCHEMA.COLUMNS to gather the info:
Would someone check this please. | ||||
| Steps To Reproduce | Delete table mantis_upgrade_table and do a upgrade on MSSQL 2000. The missing table should be created then. | ||||
| Tags | No tags attached. | ||||
|
This function is no longer used in the 1.1 stream. It is part of a legacy updater used to go from old releases to 1.0.0. It has been removed completely from the 1.2 stream. You should not be using the admin/upgrade.php page at all, instead, use admin/install.php for both new installs and upgrades. |
|
|
Won't backport the changes from 1.2.x to 1.1.5 |
|
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|