Search crashes when exclusions entered

Let us know how we are doing -

Search crashes when exclusions entered

Postby foxcole » Fri Jan 11, 2008 5:25 pm

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   Expand viewCollapse view
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, if that's relevant.

OOo 3.2.0 Portable, Windows 7 Home Premium 64-bit
User avatar
Posts: 1507
Joined: Mon Oct 08, 2007 1:31 am
Location: Minneapolis, Minnesota

Re: Search crashes when exclusions entered

Postby DrewJensen » Fri Jan 11, 2008 5:50 pm

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 
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Return to Site Feedback

Who is online

Users browsing this forum: No registered users and 2 guests