[2.10.0RC1] rank is still an issue with MySQL 8

[plegall]

As reported on topic 29518

[mysql error 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 '' at line 16

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    nb_categories,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc
    ON id = cat_id
    AND user_id = 1
  WHERE id_uppercat is NULL
     
  ORDER BY rank

#1    my_error include\dblayer\functions_mysqli.inc.php(132)
#2    pwg_query include\category_cats.inc.php(55)
#3    include index.php(301)

[plegall]

As opposed to 8e9cb6d I have added generic code in pwg_query to escape the rank word in any SQL query.

That's not perfect, but less impact on code.

[eallion]

i have this issues too

[VolkerBoedker]

I had an issue with the key word 'groups' and fixed is as described in my comment Piwigo/AMenuManager#5 (comment)