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:
Seth
January 29, 2021, 8:25 PM

Thanks. This is fixed.

yelto
January 30, 2021, 11:23 AM

Thank you

Fixed

Assignee

Seth

Reporter

yelto

Labels

None

Components

Fix versions

Affects versions

Priority

Critical