Support » Plugin: SendPress Newsletters » WordPress Database Error

  • Hello –
    I’m not using the latest version of MySQL. I’m using MySQL 5.0, so I don’t know if this is related, but today I get the error message below:

    [29-Apr-2013 17:30:08 UTC] WordPress database 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 ')) GROUP BY t1.subscriberID' at line 1 for query SELECT t1.subscriberID,, t3.status, t2.listid, count(*) FROM wp_sendpress_subscribers as t1,wp_sendpress_list_subscribers as t2,wp_sendpress_subscribers_status as t3 WHERE (t1.subscriberID = t2.subscriberID) AND ( t3.statusid = t2.status ) AND (t2.status = 2) AND (t2.listID in ( )) GROUP BY t1.subscriberID made by do_action('admin_init'), call_user_func_array, SendPress->admin_init, SendPress_View_Emails_Send_Confirm->save, SendPress_Data->get_active_subscribers_lists

Viewing 1 replies (of 1 total)
  • Plugin Author itdoug


    MySQL 5.0 is not officially supported. Some people have had some success but too much has changed in 5.1 & 5.5 for us to support 5.0. If you can upgrade to even 5.1 you should be in good shape on the database side.

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.