natcl

Thanks.
I’ll try to pressure the theme author some more.

With a default theme it works. It seems to be a conflict between the theme I use and the Events Calendar. I also sent a support request on the theme forum and they say it’s not their code… So I’m not sure what to do next. What I do know is that it worked before I updated to 3.1

By the way it seems I’m not the only one with this issue:

https://tri.be/support/forums/topic/wordpress-database-error-not-unique-tablealias/

Here is the error message with WPML turned off:

[Wed Oct 23 09:29:14 2013] [error] [client 132.204.140.139] Erreur de la base de donn\xc3\xa9es WordPress Not unique table/alias: ‘wp_bramspostmeta’ pour la requ\xc3\xaate SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_bramsposts.*, IF (wp_bramsposts.post_type = ‘tribe_events’, wp_bramspostmeta.meta_value, wp_bramsposts.post_date) AS post_date FROM wp_bramsposts INNER JOIN wp_bramspostmeta ON (wp_bramsposts.ID = wp_bramspostmeta.post_id) LEFT JOIN wp_bramspostmeta on wp_bramsposts.ID = wp_bramspostmeta.post_id AND wp_bramspostmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND wp_bramsposts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘tribe_events’, ‘membres’) AND (wp_bramsposts.post_status = ‘publish’ OR wp_bramsposts.post_author = 5 AND wp_bramsposts.post_status = ‘private’) AND ( (wp_bramspostmeta.meta_key = ‘_ttrust_in_slideshow_value’ AND CAST(wp_bramspostmeta.meta_value AS CHAR) = ‘true’) ) ORDER BY post_date DESC LIMIT 0, 10 faite par require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/pure/page.php’), get_header, locate_template, load_template, require_once(‘/themes/pure/header.php’), include(‘/themes/pure/includes/slideshow.php’), query_posts, WP_Query->query, WP_Query->get_posts

But it still fails with wplm de-activated, can it still be related ?

In the case where the issue is not resolvable, is there a way I can downgrade the plugin ?

Found this info about this particular table:
https://wpml.org/documentation/support/wpml-tables/

That would most probably be WPML (https://wpml.org)
It’s a pretty popular blog translation plugin.

Thanks a lot for your answer.

I just tried disabling all plugins except The Events Calendar and my theme with the same result, my homepage won’t load and I get the error posted earlier. As soon as I deactivate the Events Calendar it starts working. It worked also just before the update to 3.1

I also posted on the forum of the theme developer and they said to contact the plugin authors first as they couldn’t find anything abnormal in their code.

I would also be glad to update to the pro version if this can help sort this out.

Thanks a lot !

Ahhh nice, now everything works nicely, thanks a lot !