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

Hi, Amit here, I am the WPML Support Manager, our current ticket queue is high, update your WPML plugins and make sure you meet the minimal requirements for running WPML before reporting an issue please - many tickets are resolved doing that

Please look at our updated list of Known Issues and you can also use our support search to find helpful information and of course review our documentation before opening a ticket.

If you do need to open a ticket please make sure to provide us with all the needed information as described in this page

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 7 replies, has 2 voices.

Last updated by Ian 6 years, 11 months ago.

Assigned support staff: sarah.n.

Author Posts
December 11, 2012 at 11:16 am #89688


I am getting the following database errors in my log. Can you let me know the resolution please:

[10-Dec-2012 19:00:48 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND taxonomy='post_tag'' at line 1 for query SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id= AND taxonomy='post_tag' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/canvas/archive.php'), get_footer, locate_template, load_template, require_once('/themes/canvas/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, SitePressLanguageSwitcher->language_selector_footer, icl_get_languages, SitePress->get_ls_languages

[11-Dec-2012 08:11:28 UTC] WordPress database error Unknown column 'wp_posts.post_type' in 'where clause' for query SELECT wp_comments.* FROM wp_comments JOIN wp_icl_translations t ON wp_comments.comment_post_ID = t.element_id
AND t.element_type='post_post' AND t.language_code='th' JOIN wp_icl_translations tc ON wp_comments.comment_ID = tc.element_id AND tc.element_type='comment' AND tc.language_code='th' WHERE comment_post_ID = '225' AND comment_approved = '1' AND wp_posts.post_type NOT IN ('shop_order') ORDER BY comment_date_gmt DESC LIMIT 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

December 11, 2012 at 12:19 pm #89706


Languages: English (English ) German (Deutsch )

Hello Ian,

Can you please provide the plugin versions of WPML and its add-ons you may be using?

Also, which action generates the errors?

Are you using an eCommerce plugin? If so, which one?

December 11, 2012 at 1:05 pm #89720


Hi Sarah
Ok I am using WPML CMS Nav v. 1.2.7
WPML Media 1.2.0
WPML Multilingual CMS 2.6.0
WPML Sticky Links 1.2.0
WPML String Translation 1.3.1
WPML Translation Management 1.3.1
I am using WooCommerce as my eCommerce solution version with
WooCommerce Multilingual 1.4


December 11, 2012 at 1:05 pm #89721


Ah - I have no idea which action is generating the errors. Sorry.

December 11, 2012 at 1:16 pm #89725


Languages: English (English ) German (Deutsch )


Thank you for getting back to me. I would suggest that you first update your WPML and its add-ons to their latest versions.

You can check the latest released versions under "My Account -> Downloads" on this site. Instructions to update can be found here:

After this, keep an eye on the error log to see whether you get those warnings repeating after the update. If you don't see new errors generated then you should be fine.

December 11, 2012 at 1:52 pm #89735


I am ok to upgrade the plugins but using the installer looks like I have to uninstall and delete teh directory holding the existing plugins. If I do that am I going to lose all my settings? If so what is the recommended UPGRADE path rather than a new install which the installer plugin documentation refers to.


December 17, 2012 at 7:58 am #91084


Languages: English (English ) German (Deutsch )

Hello Ian,

You should always backup your database prior to any update.

Then, manually deleting the plugins from the "plugin" folder will not affect your database (settings and content is saved in the db)

If however you prefer to manually upgrade here are the steps:

Backup your database first. You can use a plugin for this if you like such as:

1. Deactivate the existing WPMl plugin and add-ons.

2. Manually delete the plugin files from the plugin folder

3. Download the updated plugins from our servers and upload them to the plugin directory.

4. Activate the WPML plugin and add-ons.

Hope this helps.

December 17, 2012 at 10:43 am #91182


Well I inadvertantly deleted a lot of information. have recovered now. Thanks for the advice on backing up databases. My bad.