Charitable Conflict With WPThree Broadcast?

Resolved SooBahkDo
(@soobahkdo)

9 years, 7 months ago

Hello,

Can you advise what is happening here?

It looks like some kind of conflict between Charitable plugin and the ThreeWP Broadcast plugin.

Both appear to still be working after these (and several more) appeared in the logs.

[04-Oct-2016 02:15:04 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 2564; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query
[04-Oct-2016 02:15:04 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query DELETE FROM wp_114_charitable_campaign_donations WHERE donation_id = 2564 made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_DB->delete_by, QM_DB->query
[04-Oct-2016 02:15:11 UTC] 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 UPDATE wp_125_posts SET post_name = ‘trick-or-treaters-welcome-v2-federation-v3-med-3300×2550’ WHERE ID = made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, threewp_broadcast\ThreeWP_Broadcast->copy_attachments_to_child, threewp_broadcast\ThreeWP_Broadcast->maybe_copy_attachment, threewp_broadcast\actions\action->execute, do_action(‘threewp_broadcast_copy_attachment’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_copy_attachment, plainview\sdk_broadcast\wordpress\base->query, QM_DB->query
[04-Oct-2016 02:15:20 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 2653; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query
[04-Oct-2016 02:15:20 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query DELETE FROM wp_114_charitable_campaign_donations WHERE donation_id = 2653 made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_DB->delete_by, QM_DB->query
[04-Oct-2016 02:15:26 UTC] 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 UPDATE wp_107_posts SET post_name = ‘trick-or-treaters-welcome-v2-federation-v3-med-3300×2550’ WHERE ID = made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, threewp_broadcast\ThreeWP_Broadcast->copy_attachments_to_child, threewp_broadcast\ThreeWP_Broadcast->maybe_copy_attachment, threewp_broadcast\actions\action->execute, do_action(‘threewp_broadcast_copy_attachment’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_copy_attachment, plainview\sdk_broadcast\wordpress\base->query, QM_DB->query
[04-Oct-2016 02:15:36 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 5892; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query
[04-Oct-2016 02:15:36 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query DELETE FROM wp_114_charitable_campaign_donations WHERE donation_id = 5892 made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_DB->delete_by, QM_DB->query
[04-Oct-2016 02:15:41 UTC] 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 UPDATE wp_115_posts SET post_name = ‘trick-or-treaters-welcome-v2-federation-v3-med-3300×2550’ WHERE ID = made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, threewp_broadcast\ThreeWP_Broadcast->copy_attachments_to_child, threewp_broadcast\ThreeWP_Broadcast->maybe_copy_attachment, threewp_broadcast\actions\action->execute, do_action(‘threewp_broadcast_copy_attachment’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_copy_attachment, plainview\sdk_broadcast\wordpress\base->query, QM_DB->query
[04-Oct-2016 02:15:49 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 3817; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query
[04-Oct-2016 02:15:49 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query DELETE FROM wp_114_charitable_campaign_donations WHERE donation_id = 3817 made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_DB->delete_by, QM_DB->query
[04-Oct-2016 02:15:56 UTC] 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 UPDATE wp_136_posts SET post_name = ‘trick-or-treaters-welcome-v2-federation-v3-med-3300×2550’ WHERE ID = made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, threewp_broadcast\ThreeWP_Broadcast->copy_attachments_to_child, threewp_broadcast\ThreeWP_Broadcast->maybe_copy_attachment, threewp_broadcast\actions\action->execute, do_action(‘threewp_broadcast_copy_attachment’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_copy_attachment, plainview\sdk_broadcast\wordpress\base->query, QM_DB->query
[04-Oct-2016 02:17:05 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 1359; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query
[04-Oct-2016 02:17:05 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query DELETE FROM wp_114_charitable_campaign_donations WHERE donation_id = 1359 made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_DB->delete_by, QM_DB->query
[04-Oct-2016 02:17:11 UTC] 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 UPDATE wp_137_posts SET post_name = ‘trick-or-treaters-welcome-v2-federation-v3-med-3300×2550’ WHERE ID = made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, threewp_broadcast\ThreeWP_Broadcast->copy_attachments_to_child, threewp_broadcast\ThreeWP_Broadcast->maybe_copy_attachment, threewp_broadcast\actions\action->execute, do_action(‘threewp_broadcast_copy_attachment’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_copy_attachment, plainview\sdk_broadcast\wordpress\base->query, QM_DB->query
[04-Oct-2016 02:17:25 UTC] WordPress database error Table ‘soobabiz_soo1035702463884.wp_114_charitable_campaign_donations’ doesn’t exist for query SELECT DISTINCT campaign_id
FROM wp_114_charitable_campaign_donations
WHERE donation_id = 1301; made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), threewp_broadcast\ThreeWP_Broadcast->save_post, plainview\sdk_broadcast\wordpress\base::filters, call_user_func_array, apply_filters(‘threewp_broadcast_broadcast_post’), threewp_broadcast\ThreeWP_Broadcast->threewp_broadcast_broadcast_post, threewp_broadcast\ThreeWP_Broadcast->broadcast_post, wp_update_post, wp_insert_post, do_action(‘post_updated’), wp_save_post_revision, wp_delete_post_revision, wp_delete_post, do_action(‘deleted_post’), Charitable_Campaign_Donations_DB::delete_donation_records, Charitable_Campaign_Donations_DB->get_campaigns_for_donation, QM_DB->query

Thanks!

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

Eric Daams
(@ericdaams)

9 years, 7 months ago

It looks like the issue is that the Charitable database tables have not been created. Are you using Charitable on a multi-site installation?

Cheers,
Eric
Thread Starter SooBahkDo
(@soobahkdo)

9 years, 7 months ago
Hi Eric,

Charitable is only active on a single site on our WP 4.6.1 multisite network.

Would the SELECT DISTINCT complaint likely be triggered if a page containing a Charitible shortcode is broadcast to other sites where the Charitable plugin is not active?

Before a broadcast with WPThree Broadcast, I usually try to assure the same plugin functionality is available on target sites as on the source site, but occasionally I discover it is not after a Broadcast and then a feature on a broadcast post or page does not work on the site it was broadcast too. Generally activating the missing plugin on the target site(s) and configuring it restores the missing feature on the broadcasted posts or pages.

I did not think that I broadcast the single page on the source site where Charitable is active.

Does Charitable code run on every post type or page of a site regardless of whether or not a Charitable shortcode is in use on the page?

If so, might the check step looking for a Charitable shortcode on a post type or page be enough to trigger the SELECT DISTINCT complaint?
- This reply was modified 9 years, 7 months ago by SooBahkDo.
- This reply was modified 9 years, 7 months ago by SooBahkDo.
- This reply was modified 9 years, 7 months ago by SooBahkDo.
- This reply was modified 9 years, 7 months ago by SooBahkDo.
Eric Daams
(@ericdaams)

9 years, 7 months ago

I don’t think this is specifically related to WPThree. Instead, the problem is that the campaigns donations table is missing. Normally, this should be created when the plugin is activated.

If you’re still having this problem, try deactivating and then reactivating Charitable. Before doing that, go to Charitable > Settings > Advanced and make sure that the Force Delete option is <b>not</b> enabled. You might also want to create a database backup just in case there are any problems.

If the problem persists after doing that, please get in touch via https://www.wpcharitable.com/support/ and we’ll follow up through email.

Cheers,
Eric

Thread Starter SooBahkDo
(@soobahkdo)

9 years, 6 months ago

Hi Eric,

What I discovered is:

When using WPThree Broadcast to broadcast a post from a site where Charitable is active to other sites where Charitable is not active and has not been previously activated to create its tables on the target site(s), then this error occurs.

However, when using WPThree Broadcast to broadcast a post from a site where Charitable is active to other sites where Charitable IS ACTIVE OR HAS BEEN PREVIOUSLY ACTIVATED and thus its tables have been created, then this error does not occur.

Issued resolved with this understanding

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

The topic ‘Charitable Conflict With WPThree Broadcast?’ is closed to new replies.

Tags