Skip Navigation

Home › Support › English Support › [Closed] the Media Library will not load or upload content until we disable WPML

[Closed] the Media Library will not load or upload content until we disable WPML

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 11:00 – 15:00 11:00 – 15:00 11:00 – 15:00 11:00 – 15:00 11:00 – 15:00 -
- 16:00 – 20:00 16:00 – 20:00 16:00 – 20:00 16:00 – 20:00 16:00 – 20:00 -

Supporter timezone: Europe/Rome (GMT+02:00)

This topic contains 7 replies, has 3 voices.

Last updated by Laura 1 year, 7 months ago.

Assisted by: Laura.

Author Posts
November 2, 2023 at 6:54 pm #14720539

dianeC-4

Tell us what you are trying to do?
Upload content - and use the Media Library

Is there any documentation that you are following?
No

Is there a similar example that we can see?

What is the link to your site?
hidden link

wpml-cwsds-2.png
wpml-cwsds-1.png
November 5, 2023 at 12:20 pm #14732895

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there,

Before this ticket is assigned to one of my colleagues I will add the first reply.

The screenshot you shared still has the top admin language switcher when you mentioned without WPML, which indicates that WPML was enabled when you took the screenshot.

I suggest that you follow the steps below to see if there is a conflict or not:

- IMPORTANT STEP! Create a backup of your website. Or better approach will be to test this on a copy/staging version of the website to avoid any disruption of a live website.
- Switch to the default theme such as "TwentyTwenty" by going to "WordPress Dashboard > Appearance > themes".
- Go to "WordPress Dashboard > Plugins" and deactivate all plugins except WPML and its add-ons.
- Check if you can still recreate the issue.
- If not, re-activate your plugins one by one and check the issue each time to find out the plugin that causes the problem.

Thanks.
November 6, 2023 at 6:51 pm #14741345

dianeC-4

Hi Christopher,

We just tried what you asked using WordPress' "Health Check & Troubleshooting" plugin, thereby activating the TwentyTwentyThree Theme and only having WPML and WPML String Translation activated. However, we still have the same issue with the Media Library just spinning.

What else can we do to try and resolve this?

Only WPML Active.png
Media Library still broken.png
November 6, 2023 at 7:55 pm #14741653

Laura
WPML Supporter since 05/2018

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hi,

I'll take care of your ticket from now on.

I would recommend not using Health Check and Troubleshooting and manually disable the plugin instead.

Also please try the troubleshooting option in WPML > Support > troubleshooting except the Reset one (the last one).

If you still have the issue, please enable the WordPress debug.log and check for any errors there https://wpml.org/documentation/support/debugging-wpml/
November 7, 2023 at 3:48 pm #14749429

dianeC-4

Hi Laura,

I tried what you asked, manually switched to TwentyTwentyThree and only had WPML and WPML String Translations activate and the Media Library still just spins. There is also errors when visiting many different parts of the admin. Here are the contents of the debug.log file:

--
"
text/x-log debug.log ( ASCII text, with very long lines )

[07-Nov-2023 15:41:17 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:17 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rewrite->flush_rules, WP_Rewrite->wp_rewrite_rules, WP_Rewrite->rewrite_rules, WP_Rewrite->generate_rewrite_rules, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:18 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:18 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF->init, do_action('acf/init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF_Taxonomy->register_taxonomies, ACF_Internal_Post_Type->get_posts, ACF_Internal_Post_Type->get_raw_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:22 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:22 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF->init, do_action('acf/init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF_Taxonomy->register_taxonomies, ACF_Internal_Post_Type->get_posts, ACF_Internal_Post_Type->get_raw_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:30 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:30 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF->init, do_action('acf/init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF_Taxonomy->register_taxonomies, ACF_Internal_Post_Type->get_posts, ACF_Internal_Post_Type->get_raw_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:34 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:34 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, flush_rewrite_rules, WP_Rewrite->flush_rules, WP_Rewrite->wp_rewrite_rules, WP_Rewrite->rewrite_rules, WP_Rewrite->generate_rewrite_rules, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:41 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:41:41 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows_hierarchical, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->_column_title, WP_Posts_List_Table->column_title, _post_states, get_post_states, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:41:42 UTC] PHP Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:4:"6402";i:1;s:5:"post%";} in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193
Stack trace:
#0 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(59): WPML_TM_ICL_Translations->select_translation_id(' element_id = %...', Array)
#1 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(41): WPML_TM_ICL_Translations->build_from_element_id(Array)
#2 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-records.php(139): WPML_TM_ICL_Translations->__construct(Object(WPML_TM_Records), Array, 'id_type_prefix')
#3 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/filters/class-wpml-tm-translation-status.p in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php on line 193
[07-Nov-2023 15:41:51 UTC] Cron reschedule event error for hook: action_scheduler_run_queue, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {"schedule":"every_minute","args":["WP Cron"],"interval":60}
[07-Nov-2023 15:41:59 UTC] PHP Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:4:"6558";i:1;s:5:"post%";} in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193
Stack trace:
#0 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(59): WPML_TM_ICL_Translations->select_translation_id(' element_id = %...', Array)
#1 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(41): WPML_TM_ICL_Translations->build_from_element_id(Array)
#2 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-records.php(139): WPML_TM_ICL_Translations->__construct(Object(WPML_TM_Records), Array, 'id_type_prefix')
#3 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/filters/class-wpml-tm-translation-status.p in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php on line 193
[07-Nov-2023 15:42:09 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:42:09 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, redirect_canonical, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:42:17 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:42:17 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:42:23 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:42:23 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, redirect_canonical, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:42:23 UTC] PHP Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:4:"6561";i:1;s:5:"post%";} in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193
Stack trace:
#0 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(59): WPML_TM_ICL_Translations->select_translation_id(' element_id = %...', Array)
#1 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(41): WPML_TM_ICL_Translations->build_from_element_id(Array)
#2 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-records.php(139): WPML_TM_ICL_Translations->__construct(Object(WPML_TM_Records), Array, 'id_type_prefix')
#3 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/filters/class-wpml-tm-translation-status.p in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php on line 193
[07-Nov-2023 15:42:25 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:42:25 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require_once('wp-admin/admin-header.php'), do_action('admin_print_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Admin_Scripts_Setup->wpml_js_scripts_setup, WPML_Admin_Scripts_Setup->print_reading_options_js, WPML_Admin_Scripts_Setup->verify_home_and_blog_pages_translations, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[07-Nov-2023 15:42:25 UTC] PHP Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:4:"6561";i:1;s:5:"post%";} in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193
Stack trace:
#0 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(59): WPML_TM_ICL_Translations->select_translation_id(' element_id = %...', Array)
#1 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php(41): WPML_TM_ICL_Translations->build_from_element_id(Array)
#2 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-records.php(139): WPML_TM_ICL_Translations->__construct(Object(WPML_TM_Records), Array, 'id_type_prefix')
#3 /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/filters/class-wpml-tm-translation-status.p in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php on line 193
[07-Nov-2023 15:43:01 UTC] PHP Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/cwsds/public_html/wp-includes/class-wpdb.php on line 2459
[07-Nov-2023 15:43:01 UTC] WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code
FROM wpstg0_icl_translations
WHERE trid =
(SELECT trid
FROM wpstg0_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wpstg0_options
WHERE option_name='page_on_front'
LIMIT 1))
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, redirect_canonical, redirect_guess_404_permalink, get_permalink, get_page_link, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get"
--

Please let me know what we can do to fix things, thanks.

Screenshot 2023-11-07 at 10.35.23 AM.png
Screenshot 2023-11-07 at 10.34.04 AM.png
Screenshot 2023-11-07 at 10.33.49 AM.png
Screenshot 2023-11-07 at 10.33.10 AM.png
Screenshot 2023-11-07 at 10.32.55 AM.png
November 7, 2023 at 5:28 pm #14750615

Laura
WPML Supporter since 05/2018

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

There are a couple of errors here, so that's likely the reason you can't load the Media Library.

This one 

Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:4:"6402";i:1;s:5:"post%";} in /home/cwsds/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193

is usually related to database table missing auto_increment.

Please check that all tables have it. For WPML tables, you can use the query from this post (always do a backup before touching the database). Remember you may need to change the tables' prefix https://wpml.org/forums/topic/critical-error-when-not-even-doing-anything-on-the-site/#post-8117663

Solving this might solve also 

WordPress database error Subquery returns more than 1 row for query SELECT element_id, language_code

so please check the auto_increment first.
November 7, 2023 at 6:52 pm #14751103

dianeC-4

Hi Laura,

Thanks but that post seems to be archived; are you able to unarchive it for me (I just submitted a request to have it unarchived)?
November 8, 2023 at 11:35 am #14755859

Laura
WPML Supporter since 05/2018

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Sorry, I didn't realize it was archived, I unarchived it for you. Let me know how it goes.

The topic ‘[Closed] the Media Library will not load or upload content until we disable WPML’ is closed to new replies.