WordPress database error Table ‘MYDATABASE.the’ doesn’t exist

  • Resolved philraymond

    (@philraymond)


    5 years, 4 months ago

    This is occasionally showing up in my error_log file:

    WordPress database error Table ‘MYDATABASE.the’ doesn’t exist for query SHOW FULL COLUMNS FROM the made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/bb-theme/tpl-full-width.php’), get_template_part, locate_template, load_template, require(‘/themes/bb-theme-child/content-page.php’), dynamic_sidebar, WP_Widget->display_callback, CRP_Widget->widget, get_crp, get_crp_posts, CRP_Query->__construct, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    Do you think it’s your plugin?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ajay

    (@ajay)

    5 years, 4 months ago

    @philraymond

    Is this on a specific post?

    I’ve noticed this issue once in my testing which was extremely rare when an inbuilt function in WPDB which had the regex to detect the table fail.

    I was able to trace this, quite painfully, to this function:
    https://developer.ww.wp.xz.cn/reference/classes/wpdb/get_table_from_query/

    The workaround was reducing the amount of words compared as whatever that combination of text was caused the preg_replace to fail.

    There are two options to fix this
    – define CRP_MAX_WORDS in your wp-config to a number smaller than 100 – 100 is default no. of words.

    – If it is only a single post, use the keyword function in the metabox to use that to search for the relevant posts.

    Hope this helps.

    Thread Starter philraymond

    (@philraymond)

    5 years, 4 months ago

    This showed up a few times a month ago but hasn’t shown up since, so I guess we’re good. Thanks, Ajay!

    Plugin Author Ajay

    (@ajay)

    5 years, 4 months ago

    @philraymond

    I was able to find the fix. Another user also reported this. I’ll be pushing through a new version today.

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

The topic ‘WordPress database error Table ‘MYDATABASE.the’ doesn’t exist’ is closed to new replies.