WPML

WPML Media Translation – Pagination in Media Translation Is Not Working with WordPress 6.0

Published Updated

Overview of the Issue

If you update to WordPress 6.0, when you go to WPMLMedia Translation, the pagination does not work and it displays only the first 20 images. The only way to access to the additional images is by using the filtering option.

Workaround

This issue is fixed. Updating to the latest version solves it on your site, so you only need this workaround if you can’t update yet.

  1. Make sure you have full back of the site.
  2. Edit the file /wpml-media-translation/classes/menus/wpml-media-translations-ui.php.
  3. Look for line 310 and replace: 
    $query_count = preg_replace(
	'/^SELECT /',
	'SELECT SQL_CALC_FOUND_ROWS ',
	$query
);
  4. With 
    $query_count = preg_replace(
	'/^SELECT /',
	'SELECT SQL_CALC_FOUND_ROWS ',
	trim($query)
);

Alternatively, you can also try this:

  1. Go to WPMLMedia Translation.
  2. Click on the Screen options tab at the top of the page.
  3. Increase the number of images you need to display.

Please, keep in mind that it can impact your site’s performance if this value is set too high.

Still Seeing This Issue?

If updating doesn’t fix it, ask a support question and we’ll look into it with you.

Ask a support question

All known issues