Activity_id wrong value

  • Resolved globus2008

    (@globus2008)


    2 days, 6 hours ago

    Hello, I have installed the recent version 1.18.2 and I found that after an event is booked then in the database in the column ‘activity_id’ value ‘NULL’ is written which has never happened before.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author yoancutillas

    (@yoancutillas)

    1 day, 11 hours ago

    Hi, this column was deleted mostly because it was not used, and also because we need to have a single source of truth, which is the activity_id column of the wp_bookacti_events table.

    So you can use the event_id column of the wp_bookacti_bookings table, and join it to the id column of the wp_bookacti_events, to find the activity_id in this same table.

    Something like, for example for booking #145:

    SELECT E.activity_id FROM wp_bookacti_bookings as B LEFT JOIN wp_bookacti_events as E ON B.event_id = E.id WHERE B.id = 145

    Thread Starter globus2008

    (@globus2008)

    2 hours, 31 minutes ago

    Thank you for the information and advice on how to proceed.

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

You must be logged in to reply to this topic.