Event page not showing any content (but code is there)

I have to correct myself. After comparing source code of the page “without booking” and the page that is supposed to show an event with booking option, the event content is indeed missing. But anyway also the theme generated footer is missing, why I still think, there is a code issue somewhere, cutting everything below, while generating the page.

still very confused. the other pages, generated automatically by the plugin are working (until the point, wehere the event page is displayed)
see summary page for example: https://www.smarter-franke.de/veranstaltungen/

I don’t know where the problem is but the page stopped loading for some reason. Try to switch to a default theme (e.g., Twenty Twenty-Four) to see if the conflict is with the theme. If it’s still there with the default theme then I would check with your web host to see if they are using some kind of caching on the server.

Try adding the following to wp-config.php to see if there are any errors occurring in the code:

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_DISPLAY', true);
define( 'WP_DEBUG_LOG', true );

Maybe some PHP error is occuring when generating the booking form.

• This reply was modified 9 months, 2 weeks ago by joneiseman.

thanks for the hint. The error message is:
SELECT booking_id FROM l183_em_bookings WHERE event_id = 4 AND person_id = 1 AND booking_status NOT IN (2,3)

I checked the table l183_em_bookings and there is no column booking_id. (Thats literally what the error message says). But now I am totally lost. The DB entries are created automatically – How should I repair this?

Any ideas?

I don’t know why the column is missing. If you look in wp-content/plugins/events-manager/em-install.php you will see the following code in the function em_create_bookings_table:

    $sql = "CREATE TABLE ".$table_name." (
        booking_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        booking_uuid char(32) NOT NULL,
        event_id bigint(20) unsigned NULL,
        person_id bigint(20) unsigned NOT NULL,
        booking_spaces int(5) NOT NULL,
        booking_comment text DEFAULT NULL,
        booking_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
        booking_status int(2) NOT NULL DEFAULT 1,
        booking_rsvp_status int(1) NULL DEFAULT NULL,
        booking_price decimal(14,4) unsigned NOT NULL DEFAULT 0,
        booking_tax_rate decimal(7,4) NULL DEFAULT NULL,
        booking_taxes decimal(14,4) NULL DEFAULT NULL,
        booking_meta LONGTEXT NULL,
        PRIMARY KEY  (booking_id)
        ) DEFAULT CHARSET=utf8 ;";

Make sure all of these columns are there and make sure you make booking_id the primary key. You could delete the bookings table and then recreate it with the above create table command.

Thanks a lot. Your comments actually pushed me into the right direction. What I did now, was deinstalling the plugin, wiping the DB afterwards from all “EM” related tables and did then a new installation. That worked, and now I can execute bookings. Thanks again!