Home›Support›English Support›[Resolved] error message "target should be an object with map method or an array"
[Resolved] error message "target should be an object with map method or an array"
This thread is resolved. Here is a description of the problem and solution.
Problem: The client's website displayed a blank page and became unusable when WPML was activated alongside Elementor. An error message indicated: 'target should be an object with map method or an array'. Further investigation revealed issues with saving changes due to a database error stating 'Argument ID must be numeric and greater than 0'. Solution: We identified that the issue was related to the database's _posts table missing an auto increment setting for the ID column. We recommended the client to: 1. Perform a full site backup. 2. Run the following SQL query using a tool like PHPMyAdmin:
ALTER TABLE `wp_posts` CHANGE `ID` `ID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, add PRIMARY KEY (`ID`);
3. Check if the issue persists after applying the fix. Additionally, we suggested checking out these articles for further database repair:
If this solution does not resolve the issue or seems irrelevant due to updates or different circumstances, we recommend opening a new support ticket. We also highly suggest checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. For further assistance, please visit our support forum at https://wpml.org/forums/forum/english-support/.
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.
Background of the issue:
There was something wrong with my website recently. At first, it became blank content for no reason. After checking and reinstalling WordPress and Elementor, and after several stops and restarts, I found that as soon as I started WPML, Elementor would become unusable. The entire website will become abnormal.
Symptoms:
Error message: 'target should be an object with map method or an array'
Questions:
How can I troubleshoot the error message 'target should be an object with map method or an array'?
Welcome to the WPML support forum. I will do my best to help you to resolve the issue.
This may be a compatibility issue. Please share with us the WordPress debug.log(not WPML debug information) to collect more details on this. Refer to these pages for instructions
To enable the WordPress Debug log, open your wp-config.php file of site root and look for define('WP_DEBUG', false);. Change it to:
// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
// Disable display of errors and warnings
define( 'WP_DEBUG_DISPLAY', false );
@ini_set( 'display_errors', 0 );
Then the errors will be saved to a debug.log log file inside the */wp-content/* directory. Please do the steps to reproduce the bug and check if you are getting any errors or warnings related to WPML in the log file.
If you can paste your debug.log to http://pastebin.com/index.php and provide me that link it would be great! (This is the cleanest way because sometimes the logs are long and create a complete mess of discussion).
Thank you for the Debug log information. The log is showing the following error from Elementor.
PHP Fatal error: Uncaught Error: Call to a member function get_settings() on bool in /****/wp-content/plugins/elementor/core/base/document.php:1985
So this may be related to the following. Please enable the hidden link">safe mode option in Elementor settings and make sure you are getting the expected results or not.
Hi, After a few days of checking and reinstalling wordpress with Elementor and WPML, then when WPML is disabled, it is normal to edit web pages using Elementor, but after enabling WPML, editing web pages cannot be smooth.
The following is the information in the debug.log. Can you point me in the direction of where I should go to troubleshoot?
Thanks.
[18-Jul-2024 07:16:11 UTC] WordPress database error Column 'ID' in field list is ambiguous for query
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'any' AND p.post_name = 'header-2'
ORDER BY p.post_parent = 0 DESC
made by do_action('wp_ajax_elementor_ajax'), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Core\Common\Modules\Ajax\Module->handle_ajax_request, call_user_func, Elementor\Core\Documents_Manager->ajax_save, Elementor\Core\Base\Document->save, Elementor\Core\Base\Document->save_settings, Elementor\Core\Settings\Page\Manager->ajax_before_save_settings, Elementor\Core\Settings\Page\Manager->save_post_status, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[18-Jul-2024 07:16:12 UTC] PHP Fatal error: Uncaught Error: Call to a member function get_settings() on bool in /var/www/xthruster/html/wp-content/plugins/elementor/core/base/document.php:1993
Stack trace:
#0 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): Elementor\Core\Base\Document->handle_revisions_changed()
#1 /var/www/xthruster/html/wp-includes/plugin.php(205): WP_Hook->apply_filters()
#2 /var/www/xthruster/html/wp-includes/revision.php(208): apply_filters()
#3 /var/www/xthruster/html/wp-includes/revision.php(116): wp_save_post_revision()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(326): wp_save_post_revision_on_insert()
#5 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#6 /var/www/xthruster/html/wp-includes/plugin.php(517): WP_Hook->do_action()
#7 /var/www/xthruster/html/wp-includes/post.php(5612): do_action()
#8 /var/www/xthruster/html/wp-includes/post.php(4905): wp_after_insert_post()
#9 /var/www/xthruster/html/wp-includes/post.php(4993): wp_insert_post()
#10 /var/www/xthruster/htm in /var/www/xthruster/html/wp-content/plugins/elementor/core/base/document.php on line 1993
[18-Jul-2024 07:16:35 UTC] WordPress database error Column 'ID' in field list is ambiguous for query
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'sitemapnews772.xml'
ORDER BY p.post_parent = 0 DESC
made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[18-Jul-2024 07:16:36 UTC] WordPress database error Column 'ID' in field list is ambiguous for query
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'sitemapnews772.xml'
ORDER BY p.post_parent = 0 DESC
made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[18-Jul-2024 07:17:09 UTC] WordPress database error Column 'ID' in field list is ambiguous for query
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'any' AND p.post_name = '424-autosave-v1'
ORDER BY p.post_parent = 0 DESC
made by do_action('wp_ajax_elementor_ajax'), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Core\Common\Modules\Ajax\Module->handle_ajax_request, call_user_func, Elementor\Core\Documents_Manager->ajax_save, Elementor\Core\Base\Document->get_autosave, wp_create_post_autosave, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[18-Jul-2024 07:17:10 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/words-count/hooks/wpml-tm-word-count-refresh-hooks.php(49): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): WPML_TM_Word_Count_Refresh_Hooks->{closure}()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp-includes/plug in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
Thank you for the updates. I hope you have upgraded to the WordPress6.6 version and WPML to the 4.6.12 series.
Please try the following troubleshooting steps after a full site backup{mandatory} and check if there is any difference in the result.
1) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page)
2) On the Troubleshooting page, please click on the following options of the *Clean up* section. Wait for confirmation of processing after each one.
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Set language information
- Fix WPML tables collation
- Assign translation status to duplicated content
- Fix terms count
- Fix post type assignment
- Cleanup and optimize string tables
WordPress6.6 version and WPML to the 4.6.12 series have indeed been upgraded, and based on your suggestions, I made a backup of the website and database.
In WPML, I carried out the relevant procedures based on your suggestions. However, the problem that the web page cannot be updated still exists. The following is the relevant debugging record.
Please help me to check it.
Thank you very much.
Thomas
[20-Jul-2024 02:43:09 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/wpml-media-translation/classes/media-translation/class-wpml-media-post-images-translation.php(97): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(326): WPML_Media_Post_Images_Translation->translate_images()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp- in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:43:09 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/words-count/hooks/wpml-tm-word-count-refresh-hooks.php(49): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): WPML_TM_Word_Count_Refresh_Hooks->{closure}()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp-includes/plug in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:43:23 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/wpml-media-translation/classes/media-translation/class-wpml-media-post-images-translation.php(97): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(326): WPML_Media_Post_Images_Translation->translate_images()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp- in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:43:24 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/words-count/hooks/wpml-tm-word-count-refresh-hooks.php(49): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): WPML_TM_Word_Count_Refresh_Hooks->{closure}()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp-includes/plug in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:43:50 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/wpml-media-translation/classes/media-translation/class-wpml-media-post-images-translation.php(97): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(326): WPML_Media_Post_Images_Translation->translate_images()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp- in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:43:50 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Argument ID must be numeric and greater than 0. in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:29
Stack trace:
#0 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(41): WPML_Translation_Element->__construct()
#1 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element-factory.php(33): WPML_Translation_Element_Factory->create_post()
#2 /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/words-count/hooks/wpml-tm-word-count-refresh-hooks.php(49): WPML_Translation_Element_Factory->create()
#3 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): WPML_TM_Word_Count_Refresh_Hooks->{closure}()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#5 /var/www/xthruster/html/wp-includes/plug in /var/www/xthruster/html/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php on line 29
[20-Jul-2024 02:44:27 UTC] WordPress database error Column 'ID' in field list is ambiguous for query
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations wpml_translations
ON p.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'any' AND p.post_name = 'header-2'
ORDER BY p.post_parent = 0 DESC
made by do_action('wp_ajax_elementor_ajax'), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Core\Common\Modules\Ajax\Module->handle_ajax_request, call_user_func, Elementor\Core\Documents_Manager->ajax_save, Elementor\Core\Base\Document->save, Elementor\Core\Base\Document->save_settings, Elementor\Core\Settings\Page\Manager->ajax_before_save_settings, Elementor\Core\Settings\Page\Manager->save_post_status, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[20-Jul-2024 02:44:28 UTC] PHP Fatal error: Uncaught Error: Call to a member function get_settings() on bool in /var/www/xthruster/html/wp-content/plugins/elementor/core/base/document.php:1993
Stack trace:
#0 /var/www/xthruster/html/wp-includes/class-wp-hook.php(324): Elementor\Core\Base\Document->handle_revisions_changed()
#1 /var/www/xthruster/html/wp-includes/plugin.php(205): WP_Hook->apply_filters()
#2 /var/www/xthruster/html/wp-includes/revision.php(208): apply_filters()
#3 /var/www/xthruster/html/wp-includes/revision.php(116): wp_save_post_revision()
#4 /var/www/xthruster/html/wp-includes/class-wp-hook.php(326): wp_save_post_revision_on_insert()
#5 /var/www/xthruster/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#6 /var/www/xthruster/html/wp-includes/plugin.php(517): WP_Hook->do_action()
#7 /var/www/xthruster/html/wp-includes/post.php(5612): do_action()
#8 /var/www/xthruster/html/wp-includes/post.php(4905): wp_after_insert_post()
#9 /var/www/xthruster/html/wp-includes/post.php(4993): wp_insert_post()
#10 /var/www/xthruster/htm in /var/www/xthruster/html/wp-content/plugins/elementor/core/base/document.php on line 1993
Thank you for the details. Please fill the private details fields after a full site backup. I would like to access the admin area of your site for further checking. Refer to the following links for more details about our private information sharing policies.
Also, please allow me to make a duplicator copy of your site using the Duplicator plugin(https://wordpress.org/plugins/duplicator/) for debugging the issue on my local server. So we can troubleshoot the issue without affecting your live site.
Sorry for the late response because of the weekend and holidays.
Thank you for the updates. Now it is possible to access the site backend. I can open the page for edit also. But it is showing an warning (the following one) while saving the changes. So hope you are mentioning the same. Please check the attached images for more details and let us know your feedback.
Argument ID must be numeric and greater than 0.
Also, duplicator plugin is showing is not writable warning for *Required Paths* for creating the packages. Please check.
My problem is that when I turn off WPML, Elementor seems to operate normally, but when I turn on WPML, error messages easily appear. Moreover, the translation work in WPML seems to be unable to be added normally, so I suspect that there may be abnormalities in the data content of the database, causing these plug-ins to not run smoothly.
I now need to confirm whether the problem is caused by an error in that link? Then, how do I troubleshoot?
Because, at present, the website cannot update content normally.
Thank you for the details. This requires further debugging. But unable to created a Duplicator package due to the file permissions. The Duplicator will help us to troubleshoot the issue without affecting your live site. Please check the following image for more details and change the permission of suggested folder temporary to create the package. It will be very helpful.
The bug exists on our local copy after the initial troubleshooting steps. So consulting with our team for an expert opinion now. We will get back to you as soon as possible. Please wait.
