Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

$keys = $wpdb->get_results("SHOW KEYS FROM `{$wpdb->prefix}icl_translations` WHERE `Column_name`='trid' AND `Key_name`<>'trid_lang'");

[2] Fix | Delete

if(empty($keys)){

[3] Fix | Delete

$sql = "ALTER TABLE `{$wpdb->prefix}icl_translations` ADD KEY `trid` (`trid`)";

[4] Fix | Delete

$wpdb->query($sql);

[5] Fix | Delete

}

[6] Fix | Delete

[7] Fix | Delete

$sql = "ALTER TABLE `{$wpdb->prefix}icl_languages` ADD tag VARCHAR(8)";

[8] Fix | Delete

$wpdb->query($sql);

[9] Fix | Delete

$sql = "UPDATE `{$wpdb->prefix}icl_languages` SET tag = REPLACE(default_locale, '_', '-')";

[10] Fix | Delete

$wpdb->query($sql);

[11] Fix | Delete

icl_cache_clear();

[12] Fix | Delete

[13] Fix | Delete

[14] Fix | Delete

[15] Fix | Delete