Home Forums Theme Support Dokan regen_sync_order_table bug with wp_posts

This topic is: not resolved

This topic contains 2 replies, has 2 voices, and was last updated by  towhid 3 years, 9 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #70254

    Brent
    Member
    Post count: 6

    There's a bug with the regen_sync_order_table that reset all of my client's balances to 0. Please see:

    $sql = “SELECT ID FROM wp_posts
    WHERE post_type LIKE ‘shop_order'
    AND ID NOT IN(
    SELECT post_parent FROM wp_posts
    WHERE post_type LIKE ‘shop_order'
    GROUP BY post_parent
    )
    LIMIT %d,%d”;

    It's not properly $wpdb->prefix, and since my install uses a different prefix, rebuilding the table deleted all balances.

    #70341

    towhid
    Participant
    Post count: 4505

    Hello Brent,

    I will disscuss about this issue with our developer team. Please allow me some time.

    Thanks

    #70737

    towhid
    Participant
    Post count: 4505

    Hello Brent,

    We have fixed the bug in our latest version. Please update the latest version to 2.4.4.

    After updating to the latest version, hope it will solve the problem.

    Please let me know the result when done.

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘regen_sync_order_table bug with wp_posts’ is closed to new replies.