• Resolved nabtron

    (@nabtron)


    The plugin gives this error in error log:
    =========================

    PHP message: WordPress database error Table 'oc_vps1.wp_ap_subscribers' doesn't exist for query SELECT * FROM wp_ap_subscribers  where subs_item_id=2032 AND  subs_activity = "q_all" LIMIT 0 , 10 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Weekly/template-fullwidth.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, AnsPress_BasePage_Shortcode->anspress_sc, ap_page, call_user_func, AnsPress_Common_Pages->question_page, include('/plugins/anspress-question-answer/theme/default/question.php'), the_widget, AnsPress_Subscribe_Widget->widget, ap_question_subscribers, ap_get_subscribers, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    PHP message: PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean
    
    2016/04/17 04:36:52 [error] 433#0: *21163 FastCGI sent in stderr: "PHP message: WordPress database error Table 'oc_vps1.wp_ap_notifications' doesn't exist for query  SELECT count(*) FROM wp_ap_notifications WHERE noti_status = 0 AND noti_user_id = 0 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Weekly/template-fullwidth.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, AnsPress_BasePage_Shortcode->anspress_sc, ap_page, call_user_func, AnsPress_User->user_page, include('/plugins/anspress-question-answer/theme/default/user/user.php'), ap_user_menu, ap_get_user_menu, ap_get_the_total_unread_notification, ap_get_total_unread_notification, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    
    PHP message: PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /wp-includes/wp-db.php on line 3013
    PHP message: WordPress database error Table 'oc_vps1.wp_ap_activity' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT * from wp_ap_activity activity JOIN wp_ap_subscribers subscriber ON subscriber.subs_item_id = activity.question_id AND subscriber.subs_activity = 'q_all' AND subscriber.subs_user_id=1257 union all SELECT * from wp_ap_activity activity JOIN wp_ap_subscribers subscriber1 ON subscriber1.subs_item_id = activity.answer_id AND subscriber1.subs_activity = 'a_all' AND subscriber1.subs_user_id=1257  union all SELECT * from wp_ap_activity activity JOIN wp_ap_subscribers subscriber2 ON subscriber2.subs_item_id = activity.user_id AND subscriber2.subs_activity = 'u_all' AND subscriber2.subs_user_id=1257 union all SELECT * from wp_ap_activity activity JOIN wp_ap_subscribers subscriber3 ON FIND_IN_SET(subscriber3.subs_item_id, activity.term_ids) AND subscriber3.subs_activity = 'tax_new_q' AND subscriber3.subs_user_id=1257
    
    2016/04/17 04:41:25 [error] 433#0: *21241 FastCGI sent in stderr: "PHP message: WordPress database error Table 'oc_vps1.wp_ap_subscribers' doesn't exist for query SELECT count(*) FROM wp_ap_subscribers WHERE subs_item_id=2393 AND subs_activity='q_all' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Weekly/template-fullwidth.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, AnsPress_BasePage_Shortcode->anspress_sc, ap_page, call_user_func, AnsPress_Common_Pages->question_page, include('/plugins/anspress-question-answer/theme/default/question.php'), the_widget, AnsPress_Subscribe_Widget->widget, ap_subscribe_btn_html, ap_subscribers_count, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    PHP message: PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /wp-includes/wp-db.php on line 3013

    Can you please explain why?

    https://ww.wp.xz.cn/plugins/anspress-question-answer/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Rahul Aryan

    (@nerdaryan)

    Hello @nabtron,
    This happens when you update AnsPress by replacing files manually. To fix this simply deactiave and activate AnsPress.
    This bug has been reported already in our support site and already fixed in 3.0.0-alpha1 (You have to wait for stable release).

    Thread Starter nabtron

    (@nabtron)

    no i didn’t update ur plugin manually, ever.

    anyway, solved it already by deactivating and reactivating.

    Thanks.

    Also, i would like to contribute to your plugin as it has many bugs, how is this possible? I don’t want to fork it and create a new plugin out of it as such.

    Plugin Author Rahul Aryan

    (@nerdaryan)

    You are most welcome.
    Please join our forum https://anspress.io/questions/.
    Feel free to send pull request to https://github.com/anspress/anspress. Master branch is used for development. Current version is 3.0.0-alpha1.

    Thanks.

    Thread Starter nabtron

    (@nabtron)

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘database error – doesn't exist for query select’ is closed to new replies.