View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0014070 | mantisbt | db postgresql | public | 2012-03-23 06:01 | 2015-03-25 17:50 |
Reporter | fhoffmann | Assigned To | dregad | ||
Priority | normal | Severity | crash | Reproducibility | always |
Status | closed | Resolution | no change required | ||
OS | centos | ||||
Product Version | 1.2.9 | ||||
Summary | 0014070: Error while order by userdefinied fields on "Show Issues" with pg sql | ||||
Description | Order by user definied fields will produce errors like: APPLICATION ERROR 0000401 Error can be solved by adding an "as" before col-alias file filter_api.php line 922 $t_cf_select = "$t_cf_table_alias.value $c_cf_alias"; | ||||
Tags | No tags attached. | ||||
According to PostgreSQL documentation [1], this can happen when the column alias matches a keyword, and is due to them not fully adhering to SQL standard. However, in your case the alias 'custom_field_4' is actually a valid identifier which is not a PostgreSQL keyword, so I'm a bit surprised by the error you're getting. I tested here, but do not get any syntax error: <pre> mantis_12x=# select value custom_field_4 from mantis_custom_field_string_table;
|
|
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 |
|
Reminder sent to: dregad, grangeway Not sure, maybe this issue should be moved back to project mantis. |
|
Resolving this since fhoffmann never provided feedback on my 2012 notes in 0014070:0031514. I'm pretty confident this would not be a problem on Mantis >= 1.2.9 |
|