Upgrade to Anspress 4
Upgraded one live site and got:
[11-Feb-2017 16:41:59 UTC] 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 ‘post_type IN (‘question’, ‘answer’) LIMIT 0,50′ at line 1 for query SELECT SQL_CALC_FOUND_ROWS ID, post_type, post_parent, post_status FROM wp_posts LEFT JOIN wp_ap_qameta ON post_id = ID WHERE ptype IS NULL post_type IN (‘question’, ‘answer’) LIMIT 0,50 made by do_action(‘wp_ajax_ap_migrator_4x’), WP_Hook->do_action, WP_Hook->apply_filters, AnsPress_Admin_Ajax::ap_migrator_4x, AP_Update_Helper->__construct, AP_Update_Helper->migrate_post_data
Also the reputation seems off (but fixed after i posted a new Question) :
Have you turned on reputation add-on
Yes of cource, Still maybe that user had no reputation because after he added some question, the reputation increased.
Ok I will fix it. Thanks
Thinking about my previous comment: can’t be that the user had no reputation, since he had posted 4-5 questions and answers.
Maybe the reputation has not been updated/ugraded since now i see him with a reputation of 2 (he posted one new question=2).
Reputation migration issue got fixed. Please check and lemme know if there are any further issues.
Rahul how can i fix this to an already upgraded Anspress 4 ?
go to PhpMyAdmin -> wp_options and find anspress_updates and delete it. And now go to this link https://yourdomain.com/wp-admin/admin.php?page=anspress_upgrade and start upgrade.
Did that, and it doesn’t work for some reason. Nothing happens. i mean upgrade page shows and nothing.
Oh its because your old rows are already deleted in first migration. Please restore DB and and then try.
Just fixed it. Its look like this type is created in recent bug finding