search

HongPong / broken-link-checker

This plugin will check your posts, comments and other content for broken links and missing images, and notify you if any are found. (non-commercial community fork of broken-link-checker)
10 stars 4 forks source link

wp__blc_instances doesn't exist #36

Closed grzegorz-janoszka closed 4 years ago

grzegorz-janoszka commented 5 years ago

Hi, I am using the latest version from github. Recently I have received a following email from cron:

Error Table 'mysite.wpblc_instances' doesn't exist bazy danych WordPressa podczas wykonywania zapytania SELECT instance_id FROM `wpblc_instances` WHERE container_id = 18154 AND container_type = 'post' wysłanego przez do_action_ref_array('wp_scheduled_auto_draft_delete'), WP_Hook->do_action, WP_Hook->apply_filters, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted

It hasn't appear even once with the "old" version.

HongPong commented 5 years ago

That's unusual since there were no changes to the configuration of database tables.

My guess is that it could be an encoding issue if there are any special characters on the table names (I'm not fluent enough to interpret the message better). Obviously if the table is present then something is seriously mixed up.

On Mon, Mar 25, 2019, 4:44 AM grzegorz-janoszka notifications@github.com wrote:

Hi, I am using the latest version from github. Recently I have received a following email from cron:

Error Table 'mysite.wpblc_instances' doesn't exist bazy danych WordPressa podczas wykonywania zapytania SELECT instance_id FROM wpblc_instances WHERE container_id = 18154 AND container_type = 'post' wysłanego przez do_action_ref_array('wp_scheduled_auto_draft_delete'), WP_Hook->do_action, WP_Hook->apply_filters, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted

It hasn't appear even once with the "old" version.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/HongPong/broken-link-checker/issues/36, or mute the thread https://github.com/notifications/unsubscribe-auth/AAG9a6tsh5Ea8oc4K_jcb5NF3gaiqWB5ks5vaIx5gaJpZM4cGV8L .

HongPong commented 5 years ago

If someone writes a cookie support on this and it can be suitably tested automatically I would definitely include it as a PR. I don't have the latitude to come up with that myself (heck I don't have a situation where I could apply it successfully, on hand).

grzegorz-janoszka commented 5 years ago

Actually the problem I reported initially has been reported by someone else as well: https://wordpress.org/support/topic/wrong-table-name-_blc_instances/ :) This URL contains a fix.

HongPong commented 5 years ago

excellent catch i would roll in a PR for sure

looks like this one too

https://wordpress.org/support/topic/extra-underscore-in-select-statement/