Error when user post a Question.
Hi!
First thanks for the last update, is awesome!!
But I’m still having the same issue (see: https://anspress.io/questions/question/error-error-you-have-an-error-in-your-sql-syntax/ )
When an user that is not the admin post a question, the server says:
[23-Nov-2015 18:58:34 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND m.apmeta_param IN ('category', 'tag') ) ) GROUP BY m.apmeta_userid' at line 1 de la base de datos de WordPress para la consulta SELECT u.user_email, u.ID, u.display_name, UNIX_TIMESTAMP(m.apmeta_date) as unix_date FROM wp_ap_meta m INNER JOIN wp_users as u ON u.ID = m.apmeta_userid where m.apmeta_type = 'subscriber' AND ( m.apmeta_actionid = 4484 OR (m.apmeta_actionid IN () AND m.apmeta_param IN ('category', 'tag') ) ) GROUP BY m.apmeta_userid realizada por do_action('wp_ajax_apf_addpost'), call_user_func_array, apf_addpost, wp_insert_post, do_action('save_post'), call_user_func_array, AnsPress_Process_Form->action_on_new_post, do_action('ap_processed_new_question'), call_user_func_array, AnsPress_Hooks->after_new_question, do_action('ap_after_new_question'), call_user_func_array, AnsPress_Ext_AnsPress_Email->ap_after_new_question, ap_get_question_subscribers_data
I’m using the last version of Anspress with AnsPress Email v1.2
Thanks again. I like too much this new version of Anspress.
El Tío Rufi commented
Is not different that wp_
I tested with other domain with a fresh installation and have the same issue. But only if I have Anspress Mail installed and active.
Please update anspress and email from Github.
El Tío Rufi commented
Pefect!! The error is gone!!
Thanks!
what is your db table prefix? is it different then wp_?