Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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.

This topic contains 2 replies, has 2 voices.

Last updated by Lauren 8 months, 1 week ago.

Assigned support staff: Lauren.

Author Posts
June 12, 2019 at 9:58 am #4002751


I am trying to: have the page running normallt

Link to a page where the issue can be seen: hidden link

JOIN wp_posts p
ON wpml_translations.element_id = p.ID
AND wpml_translations.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = wpml_translations.element_type
AND tridt.trid = wpml_translations.trid
WHERE fra require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/lemenagement/single-model.php'), get_template_part, locate_template, load_template, require('/themes/lemenagement/template-parts/model/content.php'), ModelData->getFromFields, get_field, acf_get_value, apply_filters('acf/load_value'), WP_Hook->apply_filters, _acf_apply_hook_variations, apply_filters_ref_array('acf/load_value/type=gallery'), WP_Hook->apply_filters, WPML_ACF_Attachments->load_translated_attachment, apply_filters('wpml_object_id'), WP_Hook->apply_filters, wpml_object_id_filter, SitePress->get_object_id, WPML_Element_Translation->element_id_in, WPML_Element_Translation->maybe_populate_cache
[12-Jun-2019 07:51:33 UTC] PHP Warning: Illegal offset type in isset or empty in /home/lemanagement/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 257
[12-Jun-2019 07:51:33 UTC] PHP Warning: Illegal offset type in /home/lemanagement/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 258
[12-Jun-2019 07:51:33 UTC] PHP Warning: Illegal offset type in isset or empty in /home/lemanagement/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 262
[12-Jun-2019 07:51:34 UTC] PHP Warning: Illegal offset type in isset or empty in /home/lemanagement/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/core-abstract-classes/class-wpml-element-translation.php on line 247
[12-Jun-2019 07:51:34 UTC] WordPress-databasefejl You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 9 for forespørgslen 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
FROM wp_icl_translations wpml_translations

June 13, 2019 at 11:06 am #4012219


mirgate seems to have stopped

June 13, 2019 at 1:54 pm #4013453


Languages: English (English )

Timezone: America/New_York (GMT-05:00)

Hi Simon, do you know if the migrate stopped or was it completed?

Also, I'd like to have you try one other thing, which I have seen sometimes resolve this deadlock error in the past.

Please try to to do a manual update by following these steps:

1. Ensure that you have a full backup for the site.

2. Log in to your account and go to the Downloads section. Download the WPML components that you need. You will receive a ZIP file for each one of WPML’s components.

3. Deactivate the current WPML version that you are using. Be sure to deactivate WPML and all its components. Otherwise, the installation files may be locked and not writeable. Don’t worry, your translations are not going to be modified.

4. Delete the plugin, so that you can install the new version. Note: if you cannot delete from inside WordPress, use an FTP program to delete the folders of WPML and its components from wp-content/plugins.

5. In the WordPress admin, go to Plugins -> Add New -> Upload and upload the ZIP files that you downloaded. Alternatively, if you cannot upload plugins directly to WordPress, unzip each file. A directory will be created. Then upload the unzipped directories to your site’s ‘wp-contents/plugins’ directory and overwrite the existing folders for WPML and its components.

6. Log in to your site, go to Plugins and activate WPML core first and then its components.

After that, delete your error log and then lets see if those error messages return. Please let me know the results.