• 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]
    UPDATE
    wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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]
    UPDATE wp_pcub_trp_original_meta trp_meta INNER JOIN wp_pcub_trp_original_strings1729070563 trp_old ON trp_meta.original_id = trp_old.id LEFT JOIN wp_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

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.