Error updating user profile – invalid SQL

  • Resolved bluesix

    (@bluesix)


    2 weeks, 5 days ago

    [30-Mar-2026 03:37:50 UTC] WordPress database error Unknown column 'meta_id' in 'SELECT' for query SELECT meta_id, meta_value FROM wp_usermeta WHERE post_id = 1363 AND meta_key LIKE 'rank_math_schema%' made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Shared->update_metadata, RankMath\Schema\DB::get_schemas, RankMath\Admin\Database\Query_Builder->get, RankMath\Admin\Database\Query_Builder->get_results, RankMath\Admin\Database\Query_Builder->run

    There is no post_id in the usermeta table.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Jeremy

    (@jeremrm)

    2 weeks, 4 days ago

    Hello @bluesix,

    Thank you for your query and we are so sorry about the trouble this must have caused.

    The error occurs because Rank Math is trying to query post_id in the wp_usermeta table, which doesn’t exist there. Sometimes this can be caused by schema data for a post that is corrupted or in an invalid format.

    As an initial step, you can back up your database and then manually delete the schema associated with the affected post in the database. If the issue persists after that, please let us know and we’ll investigate further.

    Let us know how that goes.

    Thread Starter bluesix

    (@bluesix)

    2 weeks, 4 days ago

    Where is the schema data stored for users (this doesn’t affect posts)? I’m not seeing it in wp_usermeta.

    Plugin Support Jaideep Asrani

    (@jaideeprm)

    2 weeks, 3 days ago

    Hello @bluesix,

    The issue is related to some corrupted database entries for our plugin’s options. Please follow these steps:

    1. Add the following filter to your active theme’s functions.php file:
      add_filter( "pre_update_option_rank-math-options-sitemap", function( $value, $old_value, $option ){ unset($value['exclude_roles']); return $value; }, 10, 3 );
    2. Navigate to WP Dashboard > Rank Math SEO > Sitemap Settings > Author Sitemap and make any small change to the Exclude Roles option and save the settings.
    3. Remove the filter from the functions.php file.

    That should fix the issue. Let us know if it doesn’t.

    We are here to assist.

    Plugin Support Rakibuzzaman Siam

    (@rakibuzzamansiam1)

    1 week, 5 days ago

    Hello @bluesix,
     
    Since we have not heard back from you, we are going to close this thread for now. If you still need any assistance, please feel free to reopen this thread or create a new one, and we will be happy to help.
     
    Thank you.

    manos2000

    (@manos2000)

    1 week, 3 days ago

    Can confirm that happens at all wp sites i have with 1.0.266.1 and 267. I think your query is wrong , at usermeta table there is no meta_id column, it is umeta_id.

    Please fix asap

    PS Can roll back to 265 but can not find the correspondent premium version, should also have a way to downlaod older premium versions

    manos2000

    (@manos2000)

    1 week, 3 days ago

    There is no  Author Sitemap  option at these versions at least for me and i checked many sites

    Temporary solution:

    Rnk Math > Titles & Meta > Authors > disable Add SEO Controls and user profile saved ok without error at logs

    As i wrote there is problematic query, should use umeta_id not meta_id

    Thread Starter bluesix

    (@bluesix)

    1 week, 3 days ago

    Also not seeing any reference to Author sitemaps on my end.

    mariland01

    (@mariland01)

    1 week, 1 day ago

    Same issue here https://wordpress.org/support/topic/user-profile-can-be-edited-after-latest-free-version-update/

    also not fixed in the newest version.

    Plugin Support Jeremy

    (@jeremrm)

    6 days, 4 hours ago

    Hello @manos2000, @bluesix, @mariland01,

    We will need to check this further on your site. Please email our support team at support@rankmath.com so we can assist you further.

    Looking forward to helping you.

Viewing 9 replies - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.