SendPress Newsletters
WordPress Database Error (2 posts)

  1. boybawang
    Posted 2 years ago #

    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,t1.email, 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


  2. itdoug
    Plugin Author

    Posted 2 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • SendPress Newsletters
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic