• Hello, I just updated the plugin to 3.1 and now my home page doesn’t work anymore.
    It seems to be a conflict between my Theme (pure by themetrust) and the Events Calendar plugin. See error message below:

    [Fri Oct 11 10:15:19 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_bramsicl_translations t ON wp_bramsposts.ID = t.element_id\r\n AND t.element_type LIKE ‘post\\_%’ LEFT JOIN wp_bramsicl_languages l ON t.language_code=l.code AND l.active=1 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 = 1 AND wp_bramsposts.post_status = ‘private’) AND ( (wp_bramspostmeta.meta_key = ‘_ttrust_in_slideshow_value’ AND CAST(wp_bramspostmeta.meta_value AS CHAR) = ‘true’) ) AND (t.language_code=’fr’ OR t.language_code IS NULL ) 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, referer: http://www.brams.org/

    http://wordpress.org/plugins/the-events-calendar/

Viewing 15 replies - 1 through 15 (of 15 total)
  • Hi!

    So to confirm, this only occurs with your theme? Have you tried keeping your theme and The Events Calendar active and disabling all other plugins?

    Thanks!

    Thread Starter natcl

    (@natcl)

    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 !

    The references to the wp_bramsicl_languages and wp_bramsicl_translations tables interest me – do you know which plugin these relate to?

    Thread Starter natcl

    (@natcl)

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

    Thread Starter natcl

    (@natcl)

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

    Thread Starter natcl

    (@natcl)

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

    If it does indeed relate to WPML then, sadly, we are unable to assist with this. We do have instructions for downgrading though:

    http://tri.be/faqs/help-i-upgraded-but-its-causing-me-problems-how-can-i-downgrade-to-a-pre-3-0-version/

    Thread Starter natcl

    (@natcl)

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

    Thread Starter natcl

    (@natcl)

    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

    Thread Starter natcl

    (@natcl)

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

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

    Does this still occur with all other plugins deactivated and with a default, unmodified theme?

    Thread Starter natcl

    (@natcl)

    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

    Unfortunately, though compatibility with as wide a range of themes as possible is important to us, we can’t get in to the specifics of troubleshooting issues like this that occur only with one specific theme – which is why we treat default themes like Twenty Twelve and Twenty Thirteen as a baseline.

    Thread Starter natcl

    (@natcl)

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

    No problem, hopefully we arrive at a solution one way or another!

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Problem with Pure theme by Theme Trust’ is closed to new replies.