Support » Plugin: Simple Custom Post Order » Database error do_action(admi_init)

  • Resolved Sirvelia



    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:

    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 =
    SET pt.menu_order = pt2.rank;



    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:

    Is it something you know about?

    Our mysql installation:

    ### Database ###

    Extension: mysqli
    Server version: 8.0.13

    Thank You!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Database error do_action(admi_init)’ is closed to new replies.