Why Is Snapshot Looking for Non-Existent Table?

Why is Snapshot looking for table wp_2_options when our network does not even have a blog 2 on it? The table does not exist because blog 2 does not exist. If an artificat of a previously deleted blog is causing Snapshot to look for this table, where would that info be located so it can be deleted?

Sidebar (Again) I still do not understand why the drop down list of plugins above is not sorted alphabetically instead of presented in random order.

[03-Jan-2013 20:00:32] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option
[03-Jan-2013 20:00:32] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option
[03-Jan-2013 20:00:32] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option
[03-Jan-2013 20:00:32] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option
[03-Jan-2013 20:00:32] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

  • Paul

    @SooBahkDo, Not sure. After looking at the actual SQL query from your posted errors theses are not Snapshot.

    SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1

    When Snapshot goes to do a backup it doesn't do a SELECT on a value. It dumps the entire table. 'SELECT * FROM <table>'. In your posted error looking after the SQL query it mentions 'made by do_action_ref_array, call_user_func_array' which might indicate there is some filtering going on. From the meta_key value in the SQL 'translation_ops' this look like it might be some translation plugin.

    and this is getting funny. I did a quick google on WordPress and translation_ops. Looks like you or someone using the same handle posted something similar on the WordPress forums.
    https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-database-errors-upon-activation Might not be the issue but I noticed the SQL is almost the same.

  • Paul

    @SooBahkDo, Also wanted to be clear on the numbering. Apologies if this is obvious but many members are non-technical.

    When you first install WordPress, prior to creating the network, the tables will have the prefix 'wp_'. Once you create the Network then create the first sub-site the table prefix for that sub-site will be 'wp_2_'. Second sub-site will have prefix 'wp_3_' etc.

    So what I'm getting at is the table named in your errors 'soobabiz_soo1035702463884.wp_2_options' is actually the first sub-site not the second.

    Also, I see you posted a similar thread on this issue but for a different plugin we offer. https://premium.wpmudev.org/forums/topic/packet-bigger-than-max_allowed_packet This should probably indicate these is something systemic going on with your site.

  • SooBahkDo

    Hi Paul,

    I do understand the table numbering scheme and that is why I am curious where Snapshot would even be able to find a reference to a deleted table and why it would look for it?

    Our root site (1) tables are still "wp_XXXX"

    I understand Snapshot may not be the cause of the issue, but knowing where it is looking and finding deleted data could help solve the mystery.

    ***********************************

    Seemingly unrelated to the current issue was my report about YARP above 3 months ago.

    As for the other posts mentioned above, yes, SooBahkDo is me and what we discovered was that several plugins (including one WPMUDEV plugin PopOver that I reported) do not seem to create some tables or save some options until the user activating the plugin actually configures and SAVES the settings. Before a user does this a flood or errors appear in the logs. Once the user performs a SAVE, then the errors stop.

    Not a programmer and unsure what the commonality about this behavior is, but I have reported this phenomenon to at 3 different plugin developers without resolution so far. That leads me to believe it must be a tricky matter.

    Thanks for chiming in.

    Phil D

  • SooBahkDo

    Hi Paul,

    I have assured that no translation plugin is active on the site so I am not sure where the "translation_ops" reference is coming from.

    I disabled many plugins down to a rather minimum set and overnight the errors shown below appeared in the public directory error log.

    All the errors reference WPMUDEV items, (and we have domain mapping and multi domains active if that is relevant.)

    Something still appears to be searching for deleted blog tables and Snapshot is referenced in the code, so the original post question remains unanswered. WHY is the query looking for deleted blog tables AND where would the query stumble across a reference to the deleted blog tables?

    "wp_2_options" is a deleted blog table and
    "wp_116_options" is another deleted blog table

    Solving that mystery would seem to lead toward elimination of a majority of errors that include references to Snapshot.

    There also seems to be a cycling pattern to the recurrence of the errors.
    Perhaps when a snapshot runs?
    We now have snapshots scheduled to run daily at different times on 8 sites where before we only had it running on 3 sites at different times.

    Only site 1 runs twice daily.

    The Blogs MU error is puzzling and we only have BLogs MU theme active on one site, so I'll post that issue on another thread.

    Any ideas on the Snapshot references in these errors?

    Phil D

    *****************************

    [10-Jan-2013 08:01:23] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option

    [10-Jan-2013 08:01:23] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 08:01:23] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 08:01:23] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 08:01:23] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 10:00:35] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option

    [10-Jan-2013 10:00:35] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 10:00:35] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 10:00:35] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 10:00:35] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 11:14:45] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [10-Jan-2013 13:19:59] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [10-Jan-2013 20:09:27] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [10-Jan-2013 22:00:40] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option

    [10-Jan-2013 22:00:40] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 22:00:40] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 22:00:40] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [10-Jan-2013 22:00:40] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 02:56:34] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/droplets/droplets/index.php'), sf_pagenavi

    [11-Jan-2013 04:02:48] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 04:27:47] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 04:34:12] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 04:37:05] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 04:43:30] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 05:13:27] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 05:14:10] WordPress database error Column 'ID' in field list is ambiguous for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blogs-mu/index.php'), locate_template, load_template, require_once('/themes/blogs-mu/index-post.php'), locate_template, load_template, require_once('/themes/blogs-mu/lib/templates/wp-template/paginate.php'), custom_wp_pagenavi

    [11-Jan-2013 08:00:57] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option

    [11-Jan-2013 08:00:57] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 08:00:57] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 08:00:57] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 08:00:57] WordPress database error Table 'soobabiz_soo1035702463884.wp_116_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 10:00:28] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, switch_to_blog, WP_Roles->reinit, get_option

    [11-Jan-2013 10:00:28] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 10:00:28] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 10:00:28] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

    [11-Jan-2013 10:00:28] WordPress database error Table 'soobabiz_soo1035702463884.wp_2_options' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'translation_ops' AND site_id = 1 made by do_action_ref_array, call_user_func_array, WPMUDEVSnapshot->snapshot_backup_cron_proc, WPMUDEVSnapshot->snapshot_ajax_backup_init, WPMUDEVSnapshot->snapshot_gather_item_files, snapshot_utility_get_blog_upload_path, wp_upload_dir, get_option

  • Paul

    Any ideas on the Snapshot references in these errors?

    Take a look at the last entry from your error log output you posted in the previous reply. you will see the text ' call_user_func_array' then the series of items. This is what is known as the call stack from PHP.

    Basically, if you follow the output it shows the various functions being called in sequesce:
    During the backup processing Snapshot calls the main AJAX function WPMUDEVSnapshot->snapshot_backup_cron_proc, which then calls
    WPMUDEVSnapshot->snapshot_ajax_backup_init, which then calls
    WPMUDEVSnapshot->snapshot_gather_item_files which then calls snapshot_utility_get_blog_upload_path which call the WP function wp_upload_dir, which calls get_option. It is at this point the process stops.

    In WordPress plugins and themes can register to be called for certain events within WordPress. So for example there is the 'init' event which is commonly called with WordPress goes through it's startup processing during a page request. So a plugin or theme can register to be called during the 'init' processing. Something is adding itself to your processing logic. Again, this is just being revealed by Snapshot. The Snapshot plugin itself does not query any table for specific keys. The only queries are full dumps of the tables. So the SQL looks more like 'SELECT * FROM wp_sitemeta'.

    Have you tried switching themes?

  • SooBahkDo

    Hello,

    Paul thanks for the excellent explanation of whats going on.

    I did try deactivating plugins and changing themes, but could never discover the problem combination.

    This issue persisted and the only way I would stop the error in the logs is deactivation of Snapshot, so we abandoned it for now pending further troubleshooting if/when time permits.

    I have observed that sometimes, just abandoning a problem issue (if doing so is feasible) and implementing all plugin and theme updates for a month or two and then revisiting the problem may reveal it MAGICALLY got fixed by one one of the other updates during that time period. Of course, that does not provide definitive identification of the culprit, but it may cure the problem so who cares. :slight_smile:

    I'll report back in when we reactivate Snapshot to try it again at a later date.

    Thanks for the followup.

    Phil D

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.