"rank" in MySQL 8 is a reserved keyword and causes empty elements and blueprint sections if used.

[muzzwood]

Just moved a client's website to a new server with MySQL 8. Found that on the front end both elements and blueprint lists were not populating.

Turns out it's because rank is the value for these system settings:

• fred.blueprint_sort
• fred.element_sort
• fred.element_group_sort

Adding backticks around the value in the system setting fixes it. `rank` However it would be great if the queries themselves could account for this.