• Resolved unapersona

    (@unapersona)


    Hello,
    I am getting this error on a multisite installation.

    It seems that user_registration_pending_users_notices is using the database prefix when it won’t.

    [Fri Mar 08 12:01:57.999957 2024] [proxy_fcgi:error] [pid 16730:tid 139827710170880] AH01071: Got error 'PHP message: WordPress database error Table 'db.wp_3_users' doesn't exist for query SELECT *\n\t\t\tFROM wp_3_users AS users\n\t\t\tJOIN wp_3_usermeta AS meta1 ON users.ID = meta1.user_id\n\t\t\tWHERE meta1.meta_key = 'ur_user_status' AND meta1.meta_value = '0'\n\t\t\tAND (\n\t\t\t\t((meta1.meta_key = 'ur_confirm_email' AND meta1.meta_value != '0')\n\t\t\t\tOR NOT EXISTS (\n\t\t\t\t\tSELECT 1 FROM wp_3_usermeta WHERE user_id = users.ID AND meta_key = 'ur_confirm_email'\n\t\t\t\t))\n\t\t\t\tOR\n\t\t\t\t(\n\t\t\t\t(meta1.meta_key = 'ur_admin_approval_after_email_confirmation' AND meta1.meta_value = 'false')\n\t\t\t\tOR NOT EXISTS (\n\t\t\t\t\tSELECT 1 FROM wp_3_usermeta WHERE user_id = users.ID AND meta_key = 'ur_admin_approval_after_email_confirmation'\n\t\t\t\t)\n\t\t\t)); made by require_once('wp-admin/admin-header.php'), do_action('admin_notices'), WP_Hook->do_action, WP_Hook->apply_filters, UR_Admin_User_List_Manager->user_registration_pending_users_notices, QM_DB->query'
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Query error on multisites’ is closed to new replies.