View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0003873mantisbtfilterspublic2004-05-25 14:062004-07-07 18:39
Reportergrangeway Assigned ToNarcissus  
PriorityurgentSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Versiongit trunk 
Summary0003873: Cvs filters - invalid query
Description

C:\Program Files\Apache Group\Apache2\htdocs\mantisbt\core\filter_api.php 429 db_query ( 'SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_table, mantis_project_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='1') AND () AND () AND () AND () AND () AND () AND ()' )

C:\Program Files\Apache Group\Apache2\htdocs\mantisbt\view_all_bug_page.php 37 filter_get_bug_rows ( 1, null, null, null )

AND() should be ignored and removed from the query string.
(P.S currently this will break mssql/pgsql)

TagsNo tags attached.

Activities

vboctor

vboctor

2004-05-25 17:36

manager   ~0005584

I already reported this problem to Narcissus but I didn't have the errors with me at the time. Grangeway, can you please send him the saved filters you have so that he can reproduce the problem.

In my opinion, the problem is that old filters save fields like "Reported By" as string, while the new filters expected it as an array. I think not all code paths handle the upgrading of old filters correctly.

I upgraded the priority to urgent and severity to crash.
grangeway

grangeway

2004-05-29 18:04

reporter   ~0005637

It also appears that this breaks mysql 3 servers too.

When's narcissus due back to look at this ?
Narcissus

Narcissus

2004-06-08 00:53

reporter   ~0005668

The fix I put in for this should be right. However of the few different ways this was happening, I could only replicate one. Please let me know if it still appears broken.

Related Changesets

MantisBT: master 81cd141a

2004-06-08 01:52

narcissus


Details Diff		 Fix 0003873: Invalid queries being generated from old filters.

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@2596 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9		 Affected Issues
0003873
mod - view_all_set.php Diff File
mod - doc/ChangeLog Diff File
mod - core/current_user_api.php Diff File
mod - core/filter_api.php Diff File