Database error do_action(admi_init)

Hi,

Using Query Monitor, we found a Database Error on admin. We found it after adding a new post (Custom Post). That Custom Post is ordered using this plugin (their taxonomy as well). So far on the front works fine.

The error is:

Query:
UPDATE wp_posts as pt JOIN (
SELECT ID, (@row_number:=@row_number + 1) AS rank
FROM wp_posts
WHERE post_type = ‘product’
AND post_status IN ( ‘publish’, ‘pending’, ‘draft’, ‘private’, ‘future’ )
ORDER BY menu_order ASC ) as pt2
ON pt.id = pt2.id
SET pt.menu_order = pt2.rank;

Caller:
do_action(‘admin_init’)

Component:
Core

Error message:
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 ‘rank FROM wp_posts WHERE post_type = ‘prod’ at line 2

Error code:
1064

Is it something you know about?

Our mysql installation:

### Database ###

Extension: mysqli
Server version: 8.0.13

Thank You!