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 2.0.0.11, if that's relevant.
Cheers!
---Fox

OOo 3.2.0 Portable, Windows 7 Home Premium 64-bit
User avatar
foxcole
Volunteer
 
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
DrewJensen
Volunteer
 
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 1 guest