Ph222 casino real money.REGISTER NOW GET FREE 888 PESOS REWARDS!

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 464 total)

Forum: Plugins
In reply to: [Jetpack - WP Security, Backup, Speed, & Growth] How to completely disable Jetpack’s Newsletter?

Thread Starter Rafael Fischmann

(@rfischmann)

1 week ago

Thank you, @lastsplash! I’ll follow the issue over there.

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

1 week, 3 days ago

Just a new heads-up, @epsiloncool, these errors are still all over the place in our logs. Just a few examples:

[14-Nov-2024 21:47:22 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = '2024-11-15 18:46:32' WHERE option_name = 'wpfts_detector2_message_expdt' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/fulltext-search/fulltext-search.php'), WPFTS_Core->Init, WPFTS_Core->FeatureDetector, WPFTS_Core->set_option, update_option
[14-Nov-2024 21:47:38 UTC] WordPress database error Duplicate entry '1047382-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1047382", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query

[15-Nov-2024 09:34:48 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "273594")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "273594"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[15-Nov-2024 09:35:15 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "273596")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "273596"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[15-Nov-2024 09:35:22 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "273599")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "273599"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query

Cheers!

Forum: Plugins
In reply to: [Imagify – Optimize Images & Convert WebP & AVIF | Compress Images Easily] Imagify Causing Slow Down Across All wp-admin – Slow Query

Rafael Fischmann

(@rfischmann)

1 week, 5 days ago

This topic shouldn’t have been marked as “Resolved” just yet.

Forum: Plugins
In reply to: [Imagify – Optimize Images & Convert WebP & AVIF | Compress Images Easily] Imagify Causing Slow Down Across All wp-admin – Slow Query

Rafael Fischmann

(@rfischmann)

1 week, 5 days ago

Same exact issue for me, reverting back to version 2.2.2 until a new version with a fix is released.

Forum: Plugins
In reply to: [Jetpack - WP Security, Backup, Speed, & Growth] Database error about table that doesn’t exist

Thread Starter Rafael Fischmann

(@rfischmann)

1 month, 2 weeks ago

Thanks, @jeherve. That was the only error that day and we have no logs of an outage. But maybe it did happen very quickly, I don’t know.

I’ll keep my eyes open!

Forum: Plugins
In reply to: [Jetpack - WP Security, Backup, Speed, & Growth] Database error about table that doesn’t exist

Thread Starter Rafael Fischmann

(@rfischmann)

1 month, 2 weeks ago

The table wp_jetpack_sync_queue does exist, I believe “wordpress.” refers to the database’s name.

It seems those errors only happened on October 3rd, don’t know why. But I haven’t seen them anymore in my logs.

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

1 month, 3 weeks ago

@epsiloncool You’re welcome! Thanks.

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

1 month, 3 weeks ago

Here’s another one I just caught in another debug file:

[05-Oct-2024 12:13:47 UTC] PHP Deprecated:  uksort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /home/macmagazine/public_html/wp-content/plugins/fulltext-search/includes/wpfts_tokencollector.php on line 173

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

1 month, 3 weeks ago

Just a heads-up, @epsiloncool: those errors are still spamming my PHP error log. A few recent entries:

[01-Oct-2024 17:24:08 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241773")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241773"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 17:24:10 UTC] WordPress database error Duplicate entry '1038201-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038201", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00"), ("1038200", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->update_item, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 18:15:35 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241835")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241835"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 18:27:16 UTC] WordPress database error Duplicate entry '1038219-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038219", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 18:34:52 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query update wpftsi_index wi
				left join wp_posts p
					on p.ID = wi.tid and wi.tsrc = "wp_posts"
				set wi.force_rebuild = 1
				where
					(wi.force_rebuild = 0) and 
					((p.ID is null) or (wi.tdt != p.post_modified))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, WP_REST_Autosaves_Controller->create_post_autosave, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 18:35:06 UTC] WordPress database error Duplicate entry '1038223-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038223", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 18:36:09 UTC] WordPress database error Duplicate entry '1038225-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038225", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 18:36:16 UTC] WordPress database error Duplicate entry '1038226-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038226", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Autosaves_Controller->create_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 19:27:05 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241896")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241896"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query

[01-Oct-2024 20:11:08 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241911")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241911"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 20:19:16 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241917")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241917"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 20:21:51 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241920")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241920"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 20:21:52 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						t1.pow,
						if(t1.n > 0, t1.res *  (case tbase2.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) * (-1) / LOG(t1.n + 1), 0),
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
							trel.pow,
							trel.res,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token,
							tbase.n
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "241921")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "241921"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[01-Oct-2024 20:28:05 UTC] WordPress database error Duplicate entry '1038288-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1038288", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query
[01-Oct-2024 20:33:51 UTC] OneSignal iOS Notification Error: cURL error 28: Operation timed out after 5000 milliseconds with 0 bytes received

I hope that’s helpful.

Forum: Fixing WordPress
In reply to: Big uploads failing only on Firefox?

Thread Starter Rafael Fischmann

(@rfischmann)

2 months ago

Yeah, I “like” the fact about the exact 30 seconds too, @threadi. That’s why I looked and tried playing with many settings in Firefox’s about:config that had 30s (or 30000ms) set in them, but nothing worked.

If it was a timeout set in the server, it would for sure show up in logs and it would also timeout when uploading images via Safari — which does not happen…

Unfortunately I don’t have another server to move everything just to test this, so haven’t tried that.

Forum: Fixing WordPress
In reply to: Big uploads failing only on Firefox?

Thread Starter Rafael Fischmann

(@rfischmann)

2 months ago

@threadi We’ve been looking into those for the past couple of months, trying to figure out the cause of the issue, but although there were a few ModSecurity logs especially, in the end they weren’t related at all. We even completely disabled ModSecurity and Cloudflare for testing once, and the behavior didn’t change.

I really think it’s not a server-side issue, otherwise it wouldn’t work fine via Safari.

Forum: Fixing WordPress
In reply to: Big uploads failing only on Firefox?

Thread Starter Rafael Fischmann

(@rfischmann)

2 months ago

Yes, I’ve tried disabling all add-ons/extensions, clearing caches/cookies and also hoping into Firefox’s Safe Mode, and have asked a friend to also try from his computer and the same thing happened to him on Firefox.

I’ll open a ticket on Mozilla’s support forum as well, thanks. That one you’ve linked to is very old and doesn’t seem to have anything to do with my issue.

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

3 months, 2 weeks ago

Just pasting new logs from today that might maybe help identify the issue:

[09-Aug-2024 11:17:32 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "149114")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "149114"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[09-Aug-2024 11:17:35 UTC] WordPress database error Duplicate entry '1028694-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1028694", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by bulk_edit_posts, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

3 months, 3 weeks ago

No worries, thanks, just keeping you posted on this. ??

And nope, I’m not seeing actual problems with the plugin’s functions.

Forum: Plugins
In reply to: [WP Fast Total Search - The Power of Indexed Search] WordPress database error Duplicate entry

Thread Starter Rafael Fischmann

(@rfischmann)

3 months, 3 weeks ago

Just so you know, @epsiloncool, these are still showing up after the latest update:

[03-Aug-2024 15:47:36 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = '2024-08-04 12:46:46' WHERE option_name = 'wpfts_detector2_message_expdt' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/fulltext-search/fulltext-search.php'), WPFTS_Core->Init, WPFTS_Core->FeatureDetector, WPFTS_Core->set_option, update_option

[04-Aug-2024 09:12:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "140810")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "140810"))
				 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, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query

Viewing 15 replies - 1 through 15 (of 464 total)

1 2 3 … 29 30 31 →