Can’t optimize database after plugin upgrade

Hi,

If the process is hanging, it’s probably due to the big tables you have in the database. Please, try and delete from your database the trp_originals tables. It may be possible to have some digits at the end (ex trp_originals1245554). This should streamline the removal of duplicate tables process, so you should try that feature again from the Advanced tab after you delete the _originals tables.

I don’t have tables like that exactly. These are the tables I have:

wp_trp_original_strings
wp_trp_original_meta
wp_trp_gettext_original_strings
wp_trp_gettext_original_meta
wp_trp_gettext_fr_ca
wp_trp_gettext_en_us
wp_trp_gettext_en_ca
wp_trp_dictionary_en_us_fr_ca
wp_trp_dictionary_en_ca_fr_ca

Were you referring to deleting the first four on my list? First two? Thanks.

Hi Alex, any thoughts?

This error occurs probably during the regeneration of the meta data used for users searching in translated pages.
The search meta data is automatically updated when users visit your page it will be regenerated organically. Therefore it’s not critical information.

The error happens because a database optimization in the past has failed to complete.
Since then, the table has been deleted, most likely manually.

To get rid of that error for future runs of the optimization process, go to your database table wp_options and delete entry with option_name trp_original_strings_table_for_recovery

There is no row named trp_original_strings_table_for_recovery.

Here are the rows in wp_options:

trp_updated_database_original_id_insert_166
trp_updated_database_original_id_cleanup_166
trp_updated_database_gettext_original_id_update
trp_updated_database_gettext_original_id_insert
trp_updated_database_gettext_original_id_cleanup
trp_show_error_db_message
trp_settings
trp_plugin_version
trp_plugin_optin
trp_machine_translation_settings
trp_db_stored_data
trp_advanced_settings

Hi, can you please respond to my last message? Thanks!

Hi,

Can you tell me exactly (maybe you can send me a screenshot) the error you encounter while running the DB optimization process? You need to keep the optimization process running enough to the progress messages to appear. Errors should be displayed there. Also, you can tell me at what message the optimization process stops

If no error there, you will have to look at error log and let me know which errors you receive there. Here is a step-by-step tutorial of how to activate the error logs: https://www.wpbeginner.com/wp-tutorials/how-to-find-and-access-wordpress-error-logs-step-by-step/.

Hi! I’ve tried so many things, but couldn’t find any error. There were no fatal errors, and the only thing I found in the PHP logs were a bunch of lines like these. Does this mean that mean there wasn’t enough PHP power to handle it?

translatepress-multilingual/includes/trp-ajax.php 107446816 3145264 17.147 2048 116.64%

Also, on the actual progress screen, I get a bunch of dots as the updator progresses, but eventually it just stops adding more dots (it goes right off the screen.

Screenshot: https://snipboard.io/pokQKU.jpg

Hi, did you get my response?