Hi, I am getting these errors constantly in our error log. This is a multisite. I am unsure if related, but we are often getting 500 errors when customers try to order on our site:
[Mon Sep 27 19:32:02.876532 2021] [proxy_fcgi:error] [pid 7686:tid 140633687398144] [client 162.158.63.241:15354] AH01071: Got error 'anslations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 96551 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 96607 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 94022 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 96524 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 94586 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 94562 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...PHP message: WordPress database error Unknown column 'wpml_translations.translation_id' in 'field list' for query SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type\n\t\t\t\t FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t JOIN wp_10_icl_translations tridt\n\t\t\t\t ON tridt.element_type = wpml_translations.element_type\n\t\t\t\t AND tridt.trid = wpml_translations.trid\n\t\t\t\t WHERE tridt.trid = (SELECT trid FROM wp_10_icl_translations wpml_translations\n\t\t\t\tJOIN wp_10_posts p\n\t\t\t\t\tON wpml_translations.element_id = p.ID\n\t\t\t\t\t\tAND wpml_translations.element_type = CONCAT('post_', p.post_type) WHERE element_id = 96525 LIMIT 1) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_arr...', referer: hidden link
I am also getting this error:
[Mon Sep 27 17:44:33.828718 2021] [proxy_fcgi:error] [pid 11523:tid 140633754539776] [client 162.158.63.241:27200] AH01071: Got error 'PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 259PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 271PHP message: PHP Warning: Illegal offset type in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 272PHP message: PHP Warning: Illegal offset type in isset or empty in /home/547570.cloudwaysapps.com/qzyjazjrvj/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 276', referer: hidden link
so yesterday I semi fixed it myself, basically the wp_10 subsite doesn't have wpml activated on it, so I went in the WPML multisite settings and reset all the sites that don't have WPML activated. The log was clean until today and the errors came back for all the databases of subsites that don't have WPML active.
I can confirm that the table wp_10_icl_translations does not exist, and that is normal since WPML is not active on that site and I reset it.
Are the errors randomly generated or is there a specific action that reproduces them? Also do they only showcase in the error log or there is a fatal error in the front end as well.
I would like to request temporary access (wp-admin and FTP) to your site to test the issue.
(preferably to a test site where the problem has been replicated if possible)
**Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken **
I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/
You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you enter is private which means only you and I have access to it.
NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin.
From the log, it seems it is happening pretty much everywhere, either on the backend or front-end when people are purchasing. I am not seeing the error elsewhere than the log, but the site is getting a lot of 500 errors so i'm assuming this is the culprit.
Regarding the backup, this is a huge multisite, is it ok if I backup without the images?
The backup is for your own protection, while no major changes/tests are done on your live site it is always good to have a backup before providing access to any 3rd party
First of all, can you edit the url of my website from your message?
Thanks for looking into it. I knew about the /AU/ not having WPML, indeed I only have WPML on the 2 first sites, which is why I don't understand why it's looking for anything in wp_10_options.
I don't understand your request, I can't do this on the australian website since it doesn't have WPML active on it. On which site should I do this?
i activated that feature yesterday and the log keeps showing the same errors. Feel free to play around with the settings yourself as well as this is a staging site.
I have emptied the debug.log and at the moment cannot reproduce the error.
If possible, please let me know if there are any specific steps that cause it.
So far I have tested:
1. Create a translation
2. Update a translation
3. Make a minor change to a translation
4. Update WPML settings
5. Switch between languages in the front end and backend
I recommend keeping an eye on the log to see which action tends to trigger the errors if possible.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
