Search crashes when exclusions entered

[foxcole]

When I try to enter a search term with an exclusion (in the format -word) into any of the available search fields (the easy-search boxes and the advanced search) it crashes with the following error:

Code: Select all

General Error
SQL ERROR [ postgres ]

ERROR: invalid reference to FROM-clause entry for table "m0" at character 241 HINT: There is an entry for table "m0", but it cannot be referenced from this part of the query. []

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

I'm using Portable Firefox 2.0.0.11, if that's relevant.

[DrewJensen]

It is the server side - I just duplicated it...

Well - OK, make a note for now and I'll see how quick I can get that fixed

Edit: FYI - While we try to fix it ourselves I also opened a Bug Ticket at phpBB #19195

Edit: - OK, I think I have the query corrected as to how it should be gong to the database - no ideas as I sit where to make the changes in the phpBB code, but I updated the Bug Ticket with my example query - so hopefully they can give me the patch back...I'll let you know