database error

  • Hello,
    Im getting this database error in back and frontend:
    Query:

    SELECT DISTINCT user_id FROM wp_pmpro_memberships_users WHERE membership_id IN () AND status = ‘active’ intext:”Plugin: Paid Memberships Pro – WooCommerce Add On”

    Error message:
    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 ‘) AND status = ‘active” at line 1

    Do you have any ideas what can cause this issue?
    PHP version 7.2.10

    Best regards,
    Sebastian

    • This topic was modified 5 years, 11 months ago by sebz001.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter sebz001

    (@sebz001)

    anyone?

    Hey there

    Did you try disabling and deleting the add-on, then cleaning the DB with a proper tool (I also run Plugins Garbage Collector just in case), then reinstalling the add-on? Sometimes this simple steps can help.

    I have this add-on (and many others) and no errors, so you may try a plugin conflict test (I know it’s annoying but it normally shows you the culprit).

    Hope it helps, cheers!

    • This reply was modified 5 years, 10 months ago by Fabio Fava.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database error’ is closed to new replies.