Many issues with 4.0.x

Hello, I am having a huge amount of issues after updating the plugin from 3.x to 4.0.x.

First issue, I have downloaded AnsPress “4.0.6” from GitHub, I put 4.0.6 in quotes because either I’m blind or nobody is reporting this. But GitHub says its release 4.0.6, but the code and WordPress say it’s 4.0.5 but there are differences from the 4.0.5 I originally had, to make things more confusing, the AnsPress home page says to download 4.0.5. Need to get this straightened out.

Second the recalculate tools are not working, I have run the WP CLI upgrade command and it was successful, but when I go to recalculate all the things, Votes and Flagged Posts never finish, Answers Subscribers, Views do finish, Reputation says it “finished” but I get a list of SQL errors in the error logs.

From my testing, the votes and Flagged Posts both have 450 posts, the others have 246, Looking at the network votes and flagged are sending 6 ajax calls with increment “current” Parameters from 0 to 5, each group is doing 50 so that’s only 300 “being done”, there is no error logs when running them.

As for the reputation errors/warnings, the first one seems to just be a function deceleration issue

PHP Warning: Missing argument 2 for AnsPress_Admin_Ajax::recount_answer_reputation(), called in /var/www/#########/public_html/articles/wp-content/plugins/anspress-question-answer/admin/ajax.php on line 461 and defined in /var/www/#########/public_html/articles/wp-content/plugins/anspress-question-answer/admin/ajax.php on line 488

The function is “recount_answer_reputation( $user_id, $event )” $event is not passed and not used in the function

the SQL error is

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE post_author = 0 AND post_type = ‘answer’ AND post_status IN (‘publish’, ‘p’ at line 1 for query SELECT ID FROM WHERE post_author = 0 AND post_type = ‘answer’ AND post_status IN (‘publish’, ‘private_post’) made by do_action(‘wp_ajax_anspress_recount’), WP_Hook->do_action, WP_Hook->apply_filters, AnsPress_Admin_Ajax::anspress_recount, AnsPress_Admin_Ajax::recount_reputation, AnsPress_Admin_Ajax::recount_answer_reputation

looking at the code seems to be a typo again, {$wpdb->ap_reputation} should be {$wpdb->ap_reputations} Missing s on this line
$wpdb->prepare( “SELECT ID FROM {$wpdb->ap_reputation} WHERE post_author = %d AND post_type = ‘answer’ AND post_status IN (‘publish’, ‘private_post’)”, $user_id )

But after fixing the typo it give the error
WordPress database error Unknown column ‘ID’ in ‘field list’ for query SELECT ID FROM wp_ap_reputations WHERE post_author = 0 AND post_type = ‘answer’ AND post_status IN (‘publish’, ‘private_post’) made by do_action(‘wp_ajax_anspress_recount’), WP_Hook->do_action, WP_Hook->apply_filters, AnsPress_Admin_Ajax::anspress_recount, AnsPress_Admin_Ajax::recount_reputation, AnsPress_Admin_Ajax::recount_answer_reputation

assuming that should be rep_id rather then ID but also the post_author column is not in there so I stopped going any further

Thank you for taking a look into these issues.