View Issue Details

IDProjectCategoryView StatusLast Update
0015201mantisbtdb postgresqlpublic2014-09-23 18:05
ReporterMephysto Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.12 
Target Version1.2.13Fixed in Version1.2.13 
Summary0015201: Summary page fail
Description

Hello,
I just installed mantisbt 1.2.12 and if I clik on "Summary" link I retrieve this error:

APPLICATION ERROR 0000401
Database query failed. Error received from database was #-1: ERROR: column "b.category_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...OUNT(b.id) as bugcount, c.name AS category_name, category_i...
^ for the query: SELECT COUNT(b.id) as bugcount, c.name AS category_name, category_id, b.status
FROM mantis_bug_table b
JOIN mantis_category_table AS c ON b.category_id=c.id
WHERE b.project_id IN (2,1)
GROUP BY c.name, b.status
ORDER BY c.name.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Steps To Reproduce

Click on "Summary" link

Additional Information

I use PostgreSQL, ngix web server and php-fpm.

TagsNo tags attached.

Relationships

related to 0011928 closeddregad Categories duplicated on summary_page.php 
related to 0015721 closedgrangeway Functionality to consider porting to master-2.0.x 
has duplicate 0015441 closeddregad 点击 statistical statement is error 

Activities

dregad

dregad

2012-11-12 05:25

developer   ~0034296

Looks like a regression introduced by 0011928

grangeway

grangeway

2013-04-05 17:56

reporter   ~0036105

Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch

grangeway

grangeway

2014-05-16 15:02

reporter   ~0040515

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
Paul

Related Changesets

MantisBT: master-1.2.x b038f8c5

2012-11-12 05:46

dregad


Details Diff
Fix SQL error in summary page on PostgreSQL

This is a regression introduced by the fix for issue 0011928 (see commit
0c9dc2a877f21900a39931dbbc29661a5aee79bf) which was not detected before
as it was tested on MySQL which has more permissive SQL syntax.

Fixes 0015201
Affected Issues
0011928, 0015201
mod - core/summary_api.php Diff File

MantisBT: master 4143f30e

2012-11-12 05:46

dregad


Details Diff
Fix SQL error in summary page on PostgreSQL

This is a regression introduced by the fix for issue 0011928 (see commit
0c9dc2a877f21900a39931dbbc29661a5aee79bf) which was not detected before
as it was tested on MySQL which has more permissive SQL syntax.

Fixes 0015201
Affected Issues
0011928, 0015201
mod - core/summary_api.php Diff File