If you're trying to add a new custom language in WPML and encounter the error message "Error adding a new language", and your debug log shows a database error related to an unknown 'country' column during an INSERT operation into the `wp_icl_languages` table, this summary is for you.
Solution:
First, ensure that all your plugins are up to date. If the issue persists, follow these steps:
1. Enable the WordPress debug log by setting
define('WP_DEBUG', true);
and
define('WP_DEBUG_LOG', true);
in your wp-config.php file, then reproduce the issue.
2. Check the debug.log file for errors.
3. If you see an error showing that the 'country' column is missing in the `wp_icl_languages` table in your database, run the following SQL query:
Please ensure you have a full backup of your website before making any changes to the database. If this solution does not seem relevant to your issue, please open a new support ticket with us.
Problem: The client is unable to display SVG images on the translated pages even after following the instructions from the WPML documentation. Solution: We have confirmed that the workaround provided has been added to the functions.php file of the client's theme. Here is the code that should be used:
// WPML Workaround for compsupp-6933<br />
add_filter('wp_get_attachment_metadata', 'wpml_compsupp6933_fix_attachment_metadata_file_path', 10, 2);
function wpml_compsupp6933_fix_attachment_metadata_file_path($data, $attachment_id) {
// Only apply the workaround if WPML Media and SVG Support plugins are active
if( class_exists('WPML_Media') && function_exists('bodhi_svgs_generate_svg_attachment_metadata') ) {
if (isset($data['file']) && !preg_match('/\d{4}\/\d{2}\//', $data['file'])) {
// Get the upload directory info
$upload_dir_info = wp_upload_dir();
// Extract the year and month from the basedir
$year_month = date('Y/m', strtotime(get_post_field('post_date', $attachment_id)));
// Prepend the year and month to the file
$data['file'] = $year_month . '/' . $data['file'];
}
}
return $data;
}
