Unquoted `rank` breaks ca_places hierarchy display (and possibly others)

Description

The places hierarchical display/selector gets stuck (see image).

It seems the front-end and controller code generate an unquoted `rank` that recent versions of mysql reject with an error, which in turn causes js indigestion.

In case it helps, injecting
if ($vs_field == 'rank') { $vs_field = '`rank`'; }
as line 336 of app/lib/BaseFindEngine.php (right before the SQL gets generated) "solves" the issue...

Environment

mysql 8

Activity

Show:
yelto
January 30, 2021, 11:23 AM

Thank you

Seth
January 29, 2021, 8:25 PM

Thanks. This is fixed.

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Seth

Reporter

yelto