Space
Forum Replies Created
-
Forum: Plugins
In reply to: [WP Swiper] Slider no longer working after updateThis is the test page with a newly added sldier blocking using all of the default settings.
There are 3 slides, each with a paragraph:
Working perfectly. ????
That is fantastic news, many thanks. I look forward to using this when released.
Thanks, appreciate the reply.
Can confirm I’m using Ajax to load the calendars. That was a great feature to help keep the page load fast.
Thank you @vasyltech. Good to know.
Forum: Plugins
In reply to: [Open Graph and Twitter Card Tags] Way to disable the metabox for all users?Many thanks Mirza. That’s perfect.
Forum: Plugins
In reply to: [Leaflet Map] Empty paragraph tags appearing before/afterForum: Plugins
In reply to: [WP Last Login] Incompatible with Two Factor pluginExcellent, thank you Konstantin!
Forum: Plugins
In reply to: [Easy Username Updater] I’m getting errorsI see this too. It’s definitely related to this plugin.
Thansk for reply @rilwis. We’re not using Redis/Memcached.
I’m not sure how Litespeed handles changes to wp_options. In settings the auto purge rules seem concerned with just publish/update changes on posts (inc page or cpt) and terms.
Amazing, thank you.
Love the plugin keep up the great work.
- This reply was modified 1 year ago by Space.
@amimulihsanmahdi this ticket is marked as resolved but I just tested and the error remains.
There is an open issue on Github from May.The test email is listed as ‘sent’ in FluentSMTP but when checking the log in Sparkpost it states the above error and the email is not actually delivered.
This is the Sparkpost (API) sending method so can be replicated by choosing Sparkpost, pasting in the API key and sending a test.Same issue here.
field 'content.headers' is of type 'json_array', but needs to be of type 'json_object'
Forum: Plugins
In reply to: [WP Job Manager] Slow SQL Queries – Site suspendedWe are also seeing a major issue with database becoming overloaded by what seems to be a search query related to WP Job Manager. The query is incredibly heavy and has brought down a site with 4 CPU and 4GB RAM multiple times now. We don’t even have the job search visible on the front-end but it seems a bot has managed to find it. Noting that we also have LearnDash and ACF installed on this site, which seems to be making the query worse as it is searching on all statuses. Since disabling WP Job Manager the site hasn’t gone down. Example error message in the logs.
[25-May-2023 21:40:42 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = '_filled' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = '_job_expires' ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) LEFT JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id AND mt5.meta_key = '_filled' ) LEFT JOIN wp_postmeta AS mt6 ON ( wp_posts.ID = mt6.post_id ) LEFT JOIN wp_postmeta AS mt7 ON ( wp_posts.ID = mt7.post_id AND mt7.meta_key = '_job_expires' ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%grossing%') OR (wp_posts.post_excerpt LIKE '%grossing%') OR (wp_posts.post_content LIKE '%grossing%')) AND ((wp_posts.post_title LIKE '%up%') OR (wp_posts.post_excerpt LIKE '%up%') OR (wp_posts.post_content LIKE '%up%'))) AND (wp_posts.post_password = '') AND ( ( ( wp_postmeta.meta_key = '_filled' AND wp_postmeta.meta_value = '0' ) OR mt1.post_id IS NULL ) AND ( ( mt2.meta_key = '_job_expires' AND CAST(mt2.meta_value AS DATE) >= '2023-05-25' ) OR mt3.post_id IS NULL ) AND ( ( mt4.meta_key = '_filled' AND mt4.meta_value = '0' ) OR mt5.post_id IS NULL ) AND ( ( mt6.meta_key = '_job_expires' AND CAST(mt6.meta_value AS DATE) >= '2023-05-25' ) OR mt7.post_id IS NULL ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'partner' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'project' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded'))) GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%grossing up%' THEN 1 WHEN wp_posts.post_title LIKE '%grossing%' AND wp_posts.post_title LIKE '%up%' THEN 2 WHEN wp_posts.post_title LIKE '%grossing%' OR wp_posts.post_title LIKE '%up%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%grossing up%' THEN 4 WHEN wp_posts.post_content LIKE '%grossing up%' THEN 5 ELSE 6 END), wp_posts.post_date DESC made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, FacetWP_Request->update_query_vars, FacetWP_Renderer->render, FacetWP_Renderer->get_filtered_post_ids, WP_Query->__construct, WP_Query->query, WP_Query->get_posts [25-May-2023 21:40:49 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = '_filled' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = '_job_expires' ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) LEFT JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id AND mt5.meta_key = '_filled' ) LEFT JOIN wp_postmeta AS mt6 ON ( wp_posts.ID = mt6.post_id ) LEFT JOIN wp_postmeta AS mt7 ON ( wp_posts.ID = mt7.post_id AND mt7.meta_key = '_job_expires' ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%grossing%') OR (wp_posts.post_excerpt LIKE '%grossing%') OR (wp_posts.post_content LIKE '%grossing%')) AND ((wp_posts.post_title LIKE '%up%') OR (wp_posts.post_excerpt LIKE '%up%') OR (wp_posts.post_content LIKE '%up%'))) AND (wp_posts.post_password = '') AND ( ( ( wp_postmeta.meta_key = '_filled' AND wp_postmeta.meta_value = '0' ) OR mt1.post_id IS NULL ) AND ( ( mt2.meta_key = '_job_expires' AND CAST(mt2.meta_value AS DATE) >= '2023-05-25' ) OR mt3.post_id IS NULL ) AND ( ( mt4.meta_key = '_filled' AND mt4.meta_value = '0' ) OR mt5.post_id IS NULL ) AND ( ( mt6.meta_key = '_job_expires' AND CAST(mt6.meta_value AS DATE) >= '2023-05-25' ) OR mt7.post_id IS NULL ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'partner' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'project' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded')) OR (wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'graded' OR wp_posts.post_status = 'not_graded'))) GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%grossing up%' THEN 1 WHEN wp_posts.post_title LIKE '%grossing%' AND wp_posts.post_title LIKE '%up%' THEN 2 WHEN wp_posts.post_title LIKE '%grossing%' OR wp_posts.post_title LIKE '%up%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%grossing up%' THEN 4 WHEN wp_posts.post_content LIKE '%grossing up%' THEN 5 ELSE 6 END), wp_posts.post_date DESC made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, FacetWP_Request->update_query_vars, FacetWP_Renderer->render, FacetWP_Renderer->get_filtered_post_ids, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
This has the potential to take down any website running this plugin and could easily be exploited.