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:
Which version of PostgreSQL are you on ? I don't think adding "as" to the SQL would be a major issue, but before doing it I'd like to understand why you're getting this error and I don't. EDIT: It would also be interesting to know if you were getting this error prior to upgrading to 1.2.9, in which case it might have been caused by the fix for 0012404 [1] http://www.postgresql.org/docs/current/static/sql-select.html section "Omitting the AS Key Word". |
|
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 |
|