Database error Unknown column ‘meta_id’

Resolved

(@zetoun17)

found this error in debug.log:

WordPress database error Unknown column 'meta_id' in

'SELECT' for query SELECT meta_id, meta_value FROM wp_usermeta WHERE post_id = 1 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

i hope this can be fixed soon

Rank Math SEO Version 1.0.265

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

Plugin Support Jaideep Asrani
(@jaideeprm)

2 weeks, 3 days ago
Hello @zetoun17,

Thank you for contacting Rank Math support.

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 Jaideep Asrani
(@jaideeprm)

2 weeks ago

Hello @zetoun17,

Since we didn’t hear back from you we are going to mark this topic as resolved. If you have any additional questions don’t hesitate to get in touch.

Thank you.

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

You must be logged in to reply to this topic.

Tags