Events Table query

  • Resolved fersamp

    (@fersamp)


    10 years, 1 month ago

    Hi guys,
    I don’t understand why some events are not displayed in backend table:
    here a screenshot -> https://www.dayroma.it/wp-content/uploads/2016/04/ev.jpg

    The count is correct, as you can see in the picture(I have 13 events in events table): I think that event published count is done through a select like this SELECT * FROM SqE_posts WHERE post_type=’event’` in the WP posts table.

    Instead, I think that events list table in backend is filled through events.php file that is in /wp-content/plugins/events-manager/templates/tables, but I don’t understand in detail.

    There’s a cycle with

    foreach ( $EM_Events as $EM_Event ) {

}

    but I don’t understand which query fills the $EM_Events array.

    I really need to understand the way events are retrieve from DB because some events are not visible in backend, so I think they are not selected from em_events table.

    Thank you for my strange request 🙂

    PS: I tried to disable all plugin, same result.

    https://ww.wp.xz.cn/plugins/events-manager/

Viewing 4 replies - 1 through 4 (of 4 total)
  • caimin_nwl

    (@caimin_nwl)

    10 years, 1 month ago

    Hi,

    Have you also tried while running the default WordPress theme?

    Which version of Events Manager and WordPress are you using?

    Thread Starter fersamp

    (@fersamp)

    10 years, 1 month ago

    Hi,
    I don’t think is a problem about theme conflit. (tested with theme 15th)
    I’m testing a kind of event importing, some events are displayed and other not, so I have to understand how events are extracted from DB to find the different between official events creation and mine.

    Do you know what query fills $EM_Events in this case, if $EM_Events array is the correct variable that fills the table?

    EM version 5.6.3, wordpress version 4.5.1–it_IT

    Really thank you for help

    Thread Starter fersamp

    (@fersamp)

    10 years, 1 month ago

    UPDATE:
    I tried with

    echo EM_Events::output(array('scope'=>'future', 'limit'=>10, 'pagination'=>1));

    and my events are shown, even events imported manually.

    In the events table of backend, instead not.
    Only events added through “New Event” page are shown…

    How is it possible?

    Thread Starter fersamp

    (@fersamp)

    10 years, 1 month ago

    UPDATE:
    I used this code

    function fix_em_divi_problem(){
        if( is_admin() ){
            remove_action('parse_query', array('EM_Event_Post','parse_query'));
            remove_action('restrict_manage_posts', array('EM_Event_Posts_Admin','restrict_manage_posts'));
        }
}
add_action('admin_init', 'fix_em_divi_problem');

    and ALL events are shown, the problem is that date scope filter is disappeared… In this way I can’t filter events in backend…

    I’m using Kleo theme

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Events Table query’ is closed to new replies.