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
Fixed
partially fixed. Questions and Answers listing is fixed but tReputaion is empty and probably giving some fatal SQL syntax error.
Please show me error.
Here is a new one, after todays updates:
[13-Feb-2017 09:00:21 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 ‘)’ at line 1 for query SELECT * FROM wp_posts WHERE ID in () made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/justwrite/page.php’), get_template_part, locate_template, load_template, require(‘/themes/justwrite/page-templates/template-page.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, AnsPress_BasePage_Shortcode->anspress_sc, ap_page, AnsPress_Profile_Hooks::user_page, include(‘/plugins/anspress-question-answer/templates/addons/user/index.php’), AnsPress_Profile_Hooks::sub_page_template, AnsPress_Reputation_Hooks::reputation_page, AnsPress_Reputation_Query->__construct, AnsPress_Reputation_Query->query, AnsPress_Reputation_Query->prefetch, AnsPress_Reputation_Query->prefetch_posts
Just fixed it. Its look like this type is created in recent bug finding