Can’t complete the optimization via TranslatePress Database Updater
-
Hi everyone, really LOVE the plugin but I had a huge database due to some entries created by TranslatePress. I’ve ran the optimization a couple times but it’s forever stuck with dots on the el string (Greek). I’ve enabled WP debug via wp-config, ran it again and now I’m getting the following log on the backend:
Updating TranslatePress tables
Removing cdata dictionary strings for language en_US... done.
Removing cdata dictionary strings for language el... done.
Removing untranslated dictionary links for language en_US... done.
Removing untranslated dictionary links for language el... done.
Removing duplicated gettext strings for language en_US... done.
Removing duplicated gettext strings for language el... done.
Removing untranslated gettext strings where translation is available for language en_US... done.
Removing untranslated gettext strings where translation is available for language el... done.
Removing duplicated dictionary strings for language en_US... done.
Removing duplicated dictionary strings for language el............................................. done.
Removing untranslated dictionary strings where translation is available for language en_US... done.
Removing untranslated dictionary strings where translation is available for language el... done.
Updating database to version 1.6.6+
Inserting original strings for language en_US... done.
Inserting original strings for language el... done.
Cleaning original strings table for language en_US... done.
Cleaning original strings table for language el... done.
Updating original string ids for language en_US... done.
Updating original string ids for language el... done.
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 0 AND trp_meta.meta_id <= 200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 200 AND trp_meta.meta_id <= 400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 400 AND trp_meta.meta_id <= 600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 600 AND trp_meta.meta_id <= 800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 800 AND trp_meta.meta_id <= 1000 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 1000 AND trp_meta.meta_id <= 1200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 1200 AND trp_meta.meta_id <= 1400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 1400 AND trp_meta.meta_id <= 1600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 1600 AND trp_meta.meta_id <= 1800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 1800 AND trp_meta.meta_id <= 2000 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 2000 AND trp_meta.meta_id <= 2200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 2200 AND trp_meta.meta_id <= 2400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 2400 AND trp_meta.meta_id <= 2600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 2600 AND trp_meta.meta_id <= 2800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 2800 AND trp_meta.meta_id <= 3000 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 3000 AND trp_meta.meta_id <= 3200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 3200 AND trp_meta.meta_id <= 3400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 3400 AND trp_meta.meta_id <= 3600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 3600 AND trp_meta.meta_id <= 3800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 3800 AND trp_meta.meta_id <= 4000 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 4000 AND trp_meta.meta_id <= 4200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 4200 AND trp_meta.meta_id <= 4400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 4400 AND trp_meta.meta_id <= 4600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 4600 AND trp_meta.meta_id <= 4800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 4800 AND trp_meta.meta_id <= 5000 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 5000 AND trp_meta.meta_id <= 5200 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 5200 AND trp_meta.meta_id <= 5400 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 5400 AND trp_meta.meta_id <= 5600 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 5600 AND trp_meta.meta_id <= 5800 AND trp_new.id != trp_old.id
WordPress database error: [Table 'jamespet116666_eufraimi_wo4531.wp_pcub_trp_original_strings1729070563' doesn't exist]
UPDATEwp_pcub_trp_original_meta
trp_meta INNER JOINwp_pcub_trp_original_strings1729070563
trp_old ON trp_meta.original_id = trp_old.id LEFT JOINwp_pcub_trp_original_strings
trp_new ON trp_new.original = trp_old.original set trp_meta.original_id = IF(trp_new.id IS NULL, 0, trp_new.id) WHERE trp_meta.meta_id > 5800 AND trp_meta.meta_id <= 6000 AND trp_new.id != trp_old.id
{"action":"trp_update_database","trp_updb_action":"regenerate_original_meta","trp_updb_lang":"el","trp_updb_batch":0,"trp_updb_nonce":"81fbdf50ec","trp_update_completed":"no","progress_message":"
Regenerating original meta table for language en_US... done.<\/br><\/br>Regenerating original meta table for language el..."}Can someone from the team help me what’s going on with the log? Did I successfully complete the optimization process? Thanks in advance!
FYI I still see the ”Database optimization did not complete successfully. We recommend restoring the original database or trying again” message on the backend.
Edit: Properly pasted the log
- You must be logged in to reply to this topic.