Update of Events Calendar corrupted my WordPress database

Hello Dave, i thought the same but it seems that everything is there, you just have to disable the plugin, and you’ll see everything again.

(I should have known, I restore the database and I found that the problem was the plugin was active, I soon as I disabled it, I saw everything again)

Oh by the way, I’m waiting for a response like you, so I can activate the plugin again (I’m using the free one).

Well, that’s good to hear! I won’t have to keep restoring my database! LoL

And, hoping our sharp people at Modern Tribe can get this fixed soon! ??

Hey @dave4876,

Real sorry to hear about your issues. The 3.11 update has gone smoothly for the vast majority of folks so I’m curious about what could’ve gone wrong here. You mention this in your first post:

The first time I ran my Plugin updates tonight there were 7 to do. I ran them all and found afterwards that I could no longer see my posts or pages in the Admin console.

What are some of the other plugins on your site?

Thank you!
George

Hey @rami,

Just to be clear here, did you encounter the exact same issues as @dave4876 when trying to upgrade to 3.11?

Also, who is your web hosting provider? Is is also WP Engine by any chance?

Thank you!
George

Hi All,

I’m getting the same behavior on one of my sites. The view all posts page shows no posts. I installed Query Analyzer and am getting the following SQL error.

Unknown column '1LEFT' in 'on clause'

Here is the bit of the query where the trouble seems to be…

AND l.active=<strong>1LEFT JOIN</strong> zouemu_postmeta AS tribe_event_start_date
ON zouemu_posts.ID = tribe_event_start_date.post_id
AND tribe_event_start_date.meta_key = '_EventStartDate'
LEFT JOIN zouemu_postmeta AS tribe_event_end_date
ON zouemu_posts.ID = tribe_event_end_date.post_id
AND tribe_event_end_date.meta_key = '_EventEndDate'
WHERE 1=1

Many thanks,
-Tim

Oh….minus the strong tags….let me try that again. >_<…

Unknown column '1LEFT' in 'on clause'

AND l.active=1LEFT JOIN zouemu_postmeta AS tribe_event_start_date
ON zouemu_posts.ID = tribe_event_start_date.post_id
AND tribe_event_start_date.meta_key = '_EventStartDate'
LEFT JOIN zouemu_postmeta AS tribe_event_end_date
ON zouemu_posts.ID = tribe_event_end_date.post_id
AND tribe_event_end_date.meta_key = '_EventEndDate'
WHERE 1=1

I do have quite a few plugins installed. You can see an index of them here:

Plugins List

Thanks momnt for your reply. Yes you are right, it might be a conflict with an existing plugin.

I should check it one by one (unfortunately all my plugins are required, so I wouldn’t be able to use this plugin even if I find the confluct)

cheers

I have exactly the same problem, after updating the plugin I can not see my tickets and neither my pages.

I have solved disabling the plugin but I hope they can fix it soon.

Same here. Installed the 3.11 update overnight, posts, pages and WooCommerce product empty. Seems like a missing space between the 1 and LEFT, “l.active=1LEFT JOIN…” I think.

Database error produced:
WordPress databasefout Unknown column '1LEFT' in 'on clause' bij query SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_icl_translations t ON wp_posts.ID = t.element_id\r\n\t\t\t\t\t\tAND t.element_type = 'post_page' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN wp_postmeta AS tribe_event_start_date ON wp_posts.ID = tribe_event_start_date.post_id AND tribe_event_start_date.meta_key = '_EventStartDate' LEFT JOIN wp_postmeta AS tribe_event_end_date ON wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' WHERE 1=1 AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'esi_not_in_pool' OR wp_posts.post_status = 'private') ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC,tribe_event_start_date.meta_value ASC, tribe_event_end_date.meta_value ASC gemaakt door WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: https://www.*****.be/wp-admin/edit.php?post_type=tribe_events&_wpnonce=7e2db00c8f

FYI, looks like tribe released an update. Version 3.11.1

https://www.ads-software.com/plugins/the-events-calendar/changelog/

I just updated Events Calendar, reactivated it, and the All Posts page is now working again.

Best,
-Tim

Awesome!

For everyone else (except for Dave, of course, who created this topic) please be mindful of the forum guidelines and please create new topics of your own.

@denisdetaeye I suspect you in particular are facing a conflict with another plugin, there (a multilanguage plugin perhaps).

Dave – how are you getting on – are you all sorted now?

Hi Barry, yes it updated successfully and I can still see my posts and pages in the Admin tool. Glad you found the solution! Thank you! ??

Barry,

Solved for me too now! So no conflict with other plugin. Thanks!

D.