See #1458564: date facet gives wrong counts

Setting the facet to unlimited gives an error: SQLSTATE[42000]:

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1 OFFSET 0' at line 2

Comments

cpliakas’s picture

cpliakas commented
Status: Active » Closed (won't fix)

This seems like an issue with the Database Search module.

egarias’s picture

egarias commented
Status: Closed (won't fix) » Needs review

Will it be ok to pass the issue to the Database search module??

I think it is not closed

Thanks

cpliakas’s picture

cpliakas commented
Project: Facet API » Search API Database Search
Status: Needs review » Active

Sure. Bumping to Database Search.

dixon_’s picture

dixon_
he/him
Primary language English
Location France
commented
Status: Active » Closed (duplicate)

Duplicate of #1550772: Facet hard limit set to "no limit" causes SQL error