SQL Error when filtering and advanced search combined

Status
Not open for further replies.

VOI

Member
Hi,

I get an SQL error when I use advanced search on a list where a filter has been applied previously. The relevant part of the SQL statement looks like this:

Code:
WHERE ( `projects`.`id` = 62 `projects`.`suppl_dev_support_required` = 'yes' )

I seems that there is an 'AND' missing. The first part of the WHERE statement comes from the filter, the second one from the advanced search.

Maybe this bug is related the following thread:

http://fabrikar.com/forums/showthread.php?t=28786

Chris
 
Hi Chris

For me I had to filter first via the advanced search and then by the standard list filter to produce the error, but not the other way round as you described.

So I've fixed this issue that can see, which may or may not fix the one you were seeing. Try updating from github to test if possible

Cheers
Rob
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top