View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0008220 | mantisbt | db mssql | public | 2007-08-01 09:48 | 2014-05-16 15:00 |
Reporter | rzg | Assigned To | giallu | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Fixed in Version | 1.1.0a4 | ||||
Summary | 0008220: New summary item contains invalid sql | ||||
Description | The new code in core/summary_api.php summary_print_by_activity() Line 290 contains SQL errors: SELECT COUNT(h.id) as count, b.id, b.summary Msg 8120, Level 16, State 1, Line 1 | ||||
Tags | No tags attached. | ||||
GROUP BY h.bug_id, b.id, b.summary, b.last_updated is one way to fix... |
|
great... because I have zero experience with MSSQL. I'm trying the fix with MySQL and will commit the changed query if it works |
|
Ok. FYI http://dev.mysql.com/doc/refman/5.1/en/group-by-hidden-fields.html explains this MySQL extension. You can set a specific SQL mode to disable it if you want to emulate the behavior of other DBMSs. |
|
I verified MySQL is not affected and applied the full GROUP BY clause. Thanks for your testing and report |
|
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 |
|
MantisBT: master c7ac83dd 2007-08-01 11:20 Details Diff |
Fix 8220: New summary item contains invalid (MS)sql git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@4522 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0008220 |
|
mod - core/summary_api.php | Diff File |