Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

function update_icl_strings_charset_and_collations() {

[2] Fix | Delete

global $wpdb;

[3] Fix | Delete

[4] Fix | Delete

$charset = 'CHARACTER SET ' . $wpdb->charset;

[5] Fix | Delete

$collate = '';

[6] Fix | Delete

[7] Fix | Delete

if ( method_exists( $wpdb, 'has_cap' ) && $wpdb->has_cap( 'collation' ) && ! empty( $wpdb->collate ) ) {

[8] Fix | Delete

$collate .= 'COLLATE ' . $wpdb->collate;

[9] Fix | Delete

}

[10] Fix | Delete

[11] Fix | Delete

$sql_template = "ALTER TABLE `{$wpdb->prefix}icl_strings` MODIFY `%s` VARCHAR(%d) {$charset} {$collate}";

[12] Fix | Delete

[13] Fix | Delete

$fields = array(

[14] Fix | Delete

'name' => WPML_STRING_TABLE_NAME_CONTEXT_LENGTH,

[15] Fix | Delete

'context' => WPML_STRING_TABLE_NAME_CONTEXT_LENGTH,

[16] Fix | Delete

'domain_name_context_md5' => 32,

[17] Fix | Delete

);

[18] Fix | Delete

[19] Fix | Delete

foreach ( $fields as $field => $size ) {

[20] Fix | Delete

$sql = sprintf( $sql_template, $field, $size );

[21] Fix | Delete

[22] Fix | Delete

if ( $wpdb->query( $sql ) === false ) {

[23] Fix | Delete

throw new Exception( $wpdb->last_error );

[24] Fix | Delete

}

[25] Fix | Delete

}

[26] Fix | Delete

[27] Fix | Delete

}

[28] Fix | Delete

[29] Fix | Delete

update_icl_strings_charset_and_collations();

[30] Fix | Delete

[31] Fix | Delete