Error in plugin

[Ron]

Hey everyone, there’s a serious error in you last plugin update. It is flooding my server’s log with this:

[Wed Jan 24 14:39:23.053348 2018] [proxy_fcgi:error] [pid 22730:tid 139883821639424] [client 52.4.143.42:38334] AH01071: Got error ‘PHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_anon’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_all’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, pp_init_with_user, pp_supplement_user_allcaps, PP_Cap_Caster->get_user_typecast_caps, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_exceptions’ doesn’t exist for query SELECT e.operation, e.for_item_source, e.for_item_type, e.mod_type, e.via_item_source, e.via_item_type, e.for_item_status, i.item_id, i.assign_for FROM wp_2_ppc_exceptions AS e INNER JOIN wp_2_ppc_exception_items AS i ON e.exception_id = i.exception_id WHERE ( 1=1 AND e.operation IN (‘read’) AND i.assign_for = ‘item’ AND ( e.mod_type != ‘exclude’ OR e.agent_type = ‘user’ OR ( e.agent_type = ‘pp_group’ AND e.agent_id IN (SELECT ID FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’) ) ) AND ( ( e.for_item_source = ‘post’ AND e.for_item_type IN (”, ‘post’,’page’) ) OR ( e.for_item_source = ‘term’ AND e.for_item_type IN (”, ‘category’,’post_tag’,’post_format’,’nav_menu’) ) OR ( e.for_item_source = ‘pp_group’ ) ) AND e.for_item_status IN (”,’post_status:private’,’post_status:draft’,’post_status:{unpublished}’) ) AND ( e.agent_type = ‘user’ AND e.agent_id = ‘0’ ) made by require(‘wp-blog-header.p…\n’
[Wed Jan 24 14:39:25.456386 2018] [proxy_fcgi:error] [pid 22730:tid 139883821639424] [client 52.4.143.42:38334] AH01071: Got error ‘PHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_anon’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_all’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, pp_init_with_user, pp_supplement_user_allcaps, PP_Cap_Caster->get_user_typecast_caps, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_exceptions’ doesn’t exist for query SELECT e.operation, e.for_item_source, e.for_item_type, e.mod_type, e.via_item_source, e.via_item_type, e.for_item_status, i.item_id, i.assign_for FROM wp_2_ppc_exceptions AS e INNER JOIN wp_2_ppc_exception_items AS i ON e.exception_id = i.exception_id WHERE ( 1=1 AND e.operation IN (‘read’) AND i.assign_for = ‘item’ AND ( e.mod_type != ‘exclude’ OR e.agent_type = ‘user’ OR ( e.agent_type = ‘pp_group’ AND e.agent_id IN (SELECT ID FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’) ) ) AND ( ( e.for_item_source = ‘post’ AND e.for_item_type IN (”, ‘post’,’page’) ) OR ( e.for_item_source = ‘term’ AND e.for_item_type IN (”, ‘category’,’post_tag’,’post_format’,’nav_menu’) ) OR ( e.for_item_source = ‘pp_group’ ) ) AND e.for_item_status IN (”,’post_status:private’,’post_status:draft’,’post_status:{unpublished}’) ) AND ( e.agent_type = ‘user’ AND e.agent_id = ‘0’ ) made by require(‘wp-blog-header.p…\n’
[Wed Jan 24 14:39:25.710604 2018] [proxy_fcgi:error] [pid 22730:tid 139883821639424] [client 52.4.143.42:38334] AH01071: Got error ‘PHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_anon’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_pp_groups’ doesn’t exist for query SELECT * FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’ AND metagroup_id = ‘wp_all’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->_get_pp_groups, pp_get_metagroup\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Main->plugins_loaded, Tribe__Main::instance, Tribe__Main->__construct, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Main->load_assets, wp_create_nonce, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, _pp_act_set_current_user, pp_get_user, PP_User->__construct, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_roles’ doesn’t exist for query SELECT role_name FROM wp_2_ppc_roles AS uro WHERE 1=1 AND ( uro.agent_type = ‘user’ AND uro.agent_id = ‘0’ ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, pp_init_with_user, pp_supplement_user_allcaps, PP_Cap_Caster->get_user_typecast_caps, PP_User->get_site_roles\nPHP message: WordPress database error Table ‘pubsite_db.wp_2_ppc_exceptions’ doesn’t exist for query SELECT e.operation, e.for_item_source, e.for_item_type, e.mod_type, e.via_item_source, e.via_item_type, e.for_item_status, i.item_id, i.assign_for FROM wp_2_ppc_exceptions AS e INNER JOIN wp_2_ppc_exception_items AS i ON e.exception_id = i.exception_id WHERE ( 1=1 AND e.operation IN (‘read’) AND i.assign_for = ‘item’ AND ( e.mod_type != ‘exclude’ OR e.agent_type = ‘user’ OR ( e.agent_type = ‘pp_group’ AND e.agent_id IN (SELECT ID FROM wp_2_pp_groups WHERE metagroup_type = ‘wp_role’) ) ) AND ( ( e.for_item_source = ‘post’ AND e.for_item_type IN (”, ‘post’,’page’) ) OR ( e.for_item_source = ‘term’ AND e.for_item_type IN (”, ‘category’,’post_tag’,’post_format’,’nav_menu’) ) OR ( e.for_item_source = ‘pp_group’ ) ) AND e.for_item_status IN (”,’post_status:private’,’post_status:draft’,’post_status:{unpublished}’) ) AND ( e.agent_type = ‘user’ AND e.agent_id = ‘0’ ) made by require(‘wp-blog-header.p…\n’

[Andras]

Hi Ron,

Thanks for reaching out! Sorry about all those characters in your log. Let’s see what we can do.

What I understand from the log entries is that you have some errors in your database, and the following tables are named to be missing:

• pubsite_db.wp_2_ppc_groups
• pubsite_db.wp_2_ppc_roles
• pubsite_db.wp_2_ppc_exceptions

To start troubleshooting this this is what we would need:

• Please share your system information with us
• Please go through our conflict testing guide and let me know what you find

Once we have this we will be able to move forward.

Thanks and cheers,
Andras

[Ron]

I saw a lot of tables starting with “tribe_”, and that’s why I thought it was a calendar events issue. You are right, the two tables you mentioned are from another plugin (PressPermit). Fortunately, I was able to catch this error and they updated their plugin, so the problem is gone.
Thanks!

[Andras]

Hi Ron,

Stoked to hear that you found the source of the issue and got a solution for it! Great job there dude!

Since this is marked resolved I am going to close this ticket, but if you need anything else related to this topic or another please create a new ticket and we’ll be happy to help.

Cheers,
Andras

PS: If you like our plugins, and you didn’t yet do so 🙂 we would be happy to receive a review in the wordpress.org repository. Thanks!
https://wordpress.org/support/view/plugin-reviews/the-events-calendar/
https://wordpress.org/support/view/plugin-reviews/event-tickets/

PS2: We’d be also grateful if you would give us feedback on your satisfaction with support. Just click on one of the classy looking emojis below. 🙂 If you can spare a few words, that’s even better. Doublethanks!

 

[Author]

Posts