Bookings DB vs WP

  • Resolved georgerl

    (@georgerl)


    7 years, 5 months ago

    Hi,
    Under WordPress I can see all the bookings ==> +- 300 bookings.
    But in MySQL table ==W wp_em_bookings I got more than 570 bookings. Why?

    In the WordPress backend, under bookings you got the option to export as CSV file.
    This is wonderful feature.

    For MySQL, I need to play with 3 tables.
    wp_users, wp_em_events, wp_em_bookings

    I would like to have the name of the attendees per classes.

    wp_users.ID JOIN to wp_em_bookings.person_id to have the event_id JOIN to wp_em_events.events_name

    At this time I made (but this is not good enough):
    SELECT * FROM wp_em_bookings
    LEFT JOIN wp_users
    ON ID = person_id
    LEFT JOIN wp_em_events
    ON event_start_date = booking_date

    Anyway, thank you for your nice plugin and support.
    Kind regards,

    George

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

  • Hi,

    I’m glad you are a fan of the plugin and the provided support. Hopefully we can get your concern resolved so you can get back up and running.

    Unfortunately, I’m having a little trouble understanding the goal you would like to accomplish. Could you please be a little more clear with what you are trying to accomplish? Is it to just have the attendee name show for users, events, and bookings?

    Thread Starter georgerl

    (@georgerl)

    Hi,
    What I try to do:
    1–
    I have created an account under WordPress for the manager.
    This is perfect except that he couldn’t see all the bookings. I can see 300 bookings. Same thing with the export CSV.

    In the database bookings table, I got all the bookings. Around 570 bookings.
    Is there a way to see ALL the 570 bookings under WordPress Bookings.

    2–
    What I try to do is:
    Export the 3 tables listed before and I would like to know the name of the attendees per event.
    Example: Event of August 30th at 10am, attendees list.

    After I can manage the data with Python easily.
    Thanks for your support.

    George

    Plugin Support angelo_nwl

    (@angelo_nwl)

    1. you can try to set the user capabilities of the manager under events > settings > general > user capability

    2. just to confirm, did you mean export attendee’s list? if yes, you can try this snippet – https://pastebin.com/i6EjdNsg

    Thread Starter georgerl

    (@georgerl)

    Dear Angelo_nwl,

    As the WordPress admin, under Bookings, I can see only 50% of the bookings.
    I done the trick under functions.php and added the “Attendee Name” to the gear icon and done an export as CSV.
    I got nearly the same result.
    Now, I can see only 200 bookings.
    In MySQL I can see the whole list around 600 bookings.

    What I try to do is to have all the bookings per client.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    can I know what is your current EM version please?

    Thread Starter georgerl

    (@georgerl)

    EM Version 5.7.3

    Did you try checking the user capabilities setting Angelo mentioned? It could be the manager user level doesn’t have permission to view all bookings.

    Thread Starter georgerl

    (@georgerl)

    I got the same issue as the admin.
    I can see only 177 bookings. And in the database all the bookings > 600 bookings.

    It’s possible this is a conflict caused by your theme or another plugin. To check if it is, can you test with all other plugins deactivated and while running the default WordPress theme?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Bookings DB vs WP’ is closed to new replies.