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

  • Resolved Sirvelia

    (@sirvelia)


    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!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.