Multisite: Subsite events not displayed in main blog

  • Resolved bramwillemse

    (@bramwillemse)


    10 years, 10 months ago

    Hi there,

    I have a Multisite install running for a customer and I’m using Events Manager for events and WP FullCalendar as addition to pretty up the calendar a bit.

    Everything has been running smoothly, but all of the sudden subsite events are not displayed in the main blog’s calendar.

    I’ve tried adding a test event to check if this was true (the customer stated the problem today) and it is. Rebuilding the main blog’s calendar doesn’t help. It doesn’t work normal and recurring events..

    The only thing I’m getting from my debug.log is the follwoing:

    [05-Jun-2013 10:15:05 UTC] WordPress databasefout 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 '' at line 1 bij query SELECT location_status FROM wp_em_locations WHERE location_id= gemaakt door edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Location->set_status
    [05-Jun-2013 10:15:05 UTC] WordPress databasefout 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 '' at line 1 bij query UPDATE wp_em_locations SET location_status=NULL WHERE location_id= gemaakt door edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Location->set_status
    [05-Jun-2013 10:15:24 UTC] WordPress databasefout 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 '' at line 1 bij query SELECT location_status FROM wp_em_locations WHERE location_id= gemaakt door edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Location->set_status
    [05-Jun-2013 10:15:24 UTC] WordPress databasefout 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 '' at line 1 bij query UPDATE wp_em_locations SET location_status=NULL WHERE location_id= gemaakt door edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Location->set_status

    I really don’t know where to start looking. I’ve checked a lot of settings but nothing has changed as far as I can see.. some ideas where to look would be great. Thanks!

    http://wordpress.org/extend/plugins/events-manager/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    10 years, 10 months ago

    a few first steps/questions, is global tables turned on in your network settings?

    are you on the latest updates?

    does it work with other event lists and calendars?

    do the events show up on your subsites (with and without WPFC)?

    Thread Starter bramwillemse

    (@bramwillemse)

    10 years, 10 months ago

    Hi Marcus, thanks for your reply.

    is global tables turned on in your network settings?
    Yes.

    are you on the latest updates?
    Yes.

    does it work with other event lists and calendars?
    What do you mean with other event lists / calendars?

    do the events show up on your subsites (with and without WPFC)?
    Yes. The events show up on the sites where they were posted. But not in the main blog, also not after the post rebuild.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    10 years, 10 months ago

    hi,

    have you tried options at

    http://domain.com/wp-admin/network/admin.php?page=events-manager-options#general > Multi Site Options > Display global events on main blog =Yes ?

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    10 years, 10 months ago

    What do you mean with other event lists / calendars?

    I mean not using WPFC, but our simple calendar that comes with EM (or the small calendar widget for the sidebars). Wanted to verify if it’s an EM issue or WPFC only.

    btw, if this post isn’t resolved, unresolve it on the right when you reply.

    Thread Starter bramwillemse

    (@bramwillemse)

    10 years, 10 months ago

    Wanted to verify if it’s an EM issue or WPFC only.

    I though I checked this, but I just double checked and it seems to work when WPFC is disabled. So it’s a WPFC issue. You are the developer of this plugin too, right?

    caimin_nwl

    (@caimin_nwl)

    10 years, 10 months ago

    Thanks for this. Yes, WPFC is one of ours so it’s likely Marcus can suggest a fix. I’ll make sure he knows this thread has been updated.

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    10 years, 10 months ago

    I’ve noted this down and will fix in the next update of wpfc.

    Thread Starter bramwillemse

    (@bramwillemse)

    10 years, 10 months ago

    Great stuff, thanks Marcus 🙂

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Multisite: Subsite events not displayed in main blog’ is closed to new replies.