WordPress database error Commands out of sync;

forget to mention i use LightSpeedCache Webserver and Redis cache

Hi,

Our developers will try to investigate and see what can be done regarding these errors.
I will let you know after will have more information.

• This reply was modified 2 years, 6 months ago by Alex.

thank you i am curious to find out what is the issue

seems the error is gone since i did changes to the theme:
before it used to call admin-ajax.php a lot and i throttled it now

excuse me the error is not gone. it still persists. debug.log is still flooded with a lot of similar messages like:
[14-Jul-2022 09:42:09 UTC] WordPress-Datenbank-Fehler Commands out of sync; you can't run this command now für Abfrage SELECT original, id, block_type, status FROMmb_trp_dictionary_en_us_de_de` WHERE block_type = 1 OR block_type = 2 von shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, TRP_Translation_Render->translate_page, TRP_Query->get_all_translation_blocks
[14-Jul-2022 09:42:09 UTC] WordPress-Datenbank-Fehler Commands out of sync; you can’t run this command now für Abfrage SELECT original,translated, status FROM mb_trp_dictionary_en_us_de_de WHERE status != 0 AND translated <>” AND original IN ( ‘Konto’, ‘Ausloggen’, ‘Find Sets’, ‘Sets’, ‘FAQ’, ‘suche’, ‘Teile dieses Set:’, ‘Kopiere URL’, ‘Noch mehr verwandte Sets’, ‘zeige Set-Details’, ‘zeige Set-Details’, ‘zeige Set-Details’, ‘zeige Set-Details’, ‘zeige Set-Details’, ‘zeige Set-Details’, ‘https://mybricks.net/wp-content/uploads/2020/02/mybricks-300×81.png&#8217;, ‘upload’, ‘Copy’ ) von shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, TRP_Translation_Render->translate_page, TRP_Translation_Render->process_strings, TRP_Query->get_existing_translations
[14-Jul-2022 09:42:09 UTC] WordPress-Datenbank-Fehler Commands out of sync; you can’t run this command now für Abfrage SHOW FULL COLUMNS FROM mb_options von shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, TRP_Translation_Render->translate_page, TRP_Translation_Render->process_strings, TRP_Query->get_existing_translations, TRP_Query->maybe_record_automatic_translation_error, TRP_Error_Manager->record_error, update_option`

when i google it in more general range i found this post: https://stackoverflow.com/questions/16339628/why-i-am-getting-the-error-commands-out-of-sync-you-cant-run-this-command-now

Solution: You need to use/store result before you can proceed with next query after: Since you look like you don’t really care about the first result set, do this after the multi query.

when looking into TRP Code i found the following code in trp-ajax.php line 108:
$this->connection = mysqli_connect( $credentials['db_host'], $credentials['db_user'], $credentials['db_password'], $credentials['db_name'] );
maybe its somehow related?!

Hi,

Please, let me know if you still have the issue. If so, be sure you are using the latest version of our plugin.

Hi Alex, yes error persists still!

[10-Sep-2022 08:16:40 UTC] WordPress-Datenbank-Fehler Commands out of sync; you can't run this command now für Abfrage SELECT original,translated, status FROMmb_trp_dictionary_en_us_de_deWHERE status != 0 AND translated <>'' AND original IN ( 'Konto', 'Ausloggen', 'Find Sets', 'Sets', 'FAQ', 'LEGO&reg;-Sets finden, sammeln und beobachten.', 'https://mybricks.net/wp-content/uploads/2020/02/mybricks-300x81.png' ) von shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, TRP_Translation_Render->translate_page, TRP_Translation_Render->process_strings, TRP_Query->get_existing_translations

Also trp says the table is missing which is not the case. everything seems to work fine.

last_error	
disable_automatic_translations	Yes
url	https://mybricks.net/de/set/88003/
details	Missing table mb_trp_dictionary_en_us_de_de . To regenerate tables, try going to Settings->TranslatePress->General tab and Save Settings.
date_time	2022-09-09 13:00:41
timestamp	1662728441

i already regenerated the table with save button.

• This reply was modified 2 years, 2 months ago by nicmare.

Hi,

Please, update to version 2.4.0 of TranslatePress.
Let me know if the issue persists after.

did that and will observe. thanks for the continues effort!

Still having problems with this but now the messages are slightly different. Hope this helps:

[14-Nov-2022 00:26:33 UTC] #!trpst#trp-gettext data-trpgettextoriginal=#!trpen#WordPress-Datenbank-Fehler Commands out of sync; you can't run this command now für Abfrage SELECT post_id, meta_key, meta_value FROM mb_postmeta WHERE post_id IN (48385) ORDER BY meta_id ASC von shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, LiteSpeed\Core->send_headers, LiteSpeed\Control->finalize, LiteSpeed\Metabox->setting, get_post_meta, get_metadata, get_metadata_raw, update_meta_cache#!trpst#/trp-gettext#!trpen#

Hi,

Except for the trp-ajax file, where we only do one query and then close the connection, TP always uses the wpdb functions. The solution you mentioned above in the stackoverflow link doesn’t apply to the TranslatePress code.

The last error from 14-Nov-2022, doesn’t refer to TranslatePress code. It does have the trpst wrappers which were simply inserted by TP to the final error message but have no effect whatsoever on the cause of the error.
Not sure what is causing this error but now it seems to happen in the queries of another plugin (the one with the Litespeed metabox), unrelated to TranslatePress.

• This reply was modified 1 year, 11 months ago by Alex.