I created this pull request a few days ago that should fix the issue with MySQL 8 and the “rank” keyword.
(Unfortunately there are 8 files that need to be updated.)
There is also a discussion about this problem in this forum thread: