SOLVED: Debug Log, Issue Old Data Tables

Bugs
1

Browser: Chrome 110
OS: Windows /

So I had prevously some CPT created with Metabox. Those ones I deleted.

Howevery, sometimes if i try to save a bricks template im getting following Debug Error Log, and I don’t know how to fix the issue.
Sorry that i putting so many erros logs inside

[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.wp_mb_mixed_drinks’ doesn’t exist for query DELETE FROM wp_mb_mixed_drinks WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row

[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.wp_mixing_instructions’ doesn’t exist for query DELETE FROM wp_mixing_instructions WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row

[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.wp_mb_RecipeIngredient’ doesn’t exist for query DELETE FROM wp_mb_RecipeIngredient WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row

[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.wp_ProducerGeneral’ doesn’t exist for query DELETE FROM wp_ProducerGeneral WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row

[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.mb_references’ doesn’t exist for query DELETE FROM mb_references WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row
[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.mb_changelog’ doesn’t exist for query DELETE FROM mb_changelog WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row
[01-Feb-2024 20:30:43 UTC] WordPress database error Table ‘wordpress.wp_mb_SAndFPublication’ doesn’t exist for query DELETE FROM wp_mb_SAndFPublication WHERE ID = 24314 made by do_action(‘wp_ajax_bricks_save_post’), WP_Hook->do_action, WP_Hook->apply_filters, Bricks\Ajax->save_post, wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘delete_post’), WP_Hook->do_action, WP_Hook->apply_filters, MetaBox\CustomTable\Loader->delete_object_data, MetaBox\CustomTable\Storage->delete_row

2

Hi @timowessels ,

This seems related to Metabox.io and it looks like a custom table.
May I know what version you are using for Metabox and Metabox AIO?
If you changed some field structures in Metabox UI, suggest you to review and remove any dynamic tags that are irrelevant in your page.

Regards,
Jenn

3

Version
Metabox 5.9.3
AIO 1.24.2

ID not it Tables 25027, 24377

tables try to save:
wp_mb_mixed_drinks
wp_mixing_instructions
wp_mb_RecipeIngredient
wp_ProducerGeneral
,mb_references
mb_changelog
wp_mb_SAndFPublication

So I check my entire SQL Tables, and those ID are not there, I also recently delete those Custom Tables from the Database. And also I delete around 30 Taxonomies.

So I better check trough my Templates that’s causing an error log for oprhaned Taxonomies? And replace them with existing one? Or should I pass this case also to the MetaBox Team?

4

I had deleted Custom Tables in SQL
But I had still some Custom Fields in MetaBox that were trying to save on a custom table.

Took me over 10 Hours to figure it out.

At least I know now how to use Query Monitor, and I’m not scared anymore of DebugLogs as well I know now more about FilleZilla and the Structure of WordPress, Bricks and MetaBox :sweat_smile::+1::+1::+1: