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, 6 months ago. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts September 3, 2015 at 9:52 am #70254 BrentMember 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. September 3, 2015 at 6:39 pm #70341 towhidParticipant Post count: 4505 Hello Brent, I will disscuss about this issue with our developer team. Please allow me some time. Thanks September 7, 2015 at 10:37 am #70737 towhidParticipant 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 Author Posts Viewing 3 posts - 1 through 3 (of 3 total) The topic ‘regen_sync_order_table bug with wp_posts’ is closed to new replies.