+Add Timeslot in the backend not loading

Hi, thanks for reaching out to us. Can you please check if in your database the table wp_cbs_data exists? Please be aware that the prefix wp_ can be different in your example.

If the table is missing, please deactivate our plugin and reactivate it. By doing this, all missing tables are recreated.

Please check if the tables are now present. If they are still missing, please double check the right for WordPress to create new tables.

Does this procedure solve your error?

Hello and thanks a lot for your quick reply.

the table indeed did not exist but deactivating and activating it again did unfortunately not resolve the problem.

Hello, please execute following MySQL on your database to create the missing tables manually. Please remind to replace the prefix wp_ with your prefix, if necessary:

CREATE TABLE IF NOT EXISTS wp_cbs_attendances (
attendance_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
attendance int(11) NOT NULL,
PRIMARY KEY (attendance_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_bookings (
booking_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (booking_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_cancellations (
cancellation_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
user_id int(11) NOT NULL,
timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (cancellation_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_data (
id int(11) NOT NULL AUTO_INCREMENT,
day int(11) NOT NULL,
date date NULL,
post_id int(11) NOT NULL,
start time NULL,
end time NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_logs (
log_id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) NOT NULL,
card_name VARCHAR(255) NOT NULL,
card int(11) NULL,
course_id int(11) NOT NULL,
action VARCHAR(255) NOT NULL,
timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (log_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_notes (
note_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
note text NOT NULL,
PRIMARY KEY (note_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_substitutes (
substitute_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (substitute_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS wp_cbs_waitlists (
waitlist_id int(11) NOT NULL AUTO_INCREMENT,
course_id int(11) NOT NULL,
date date NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (waitlist_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

In the meantime we are working to create missing databases in our plugin automatically.

Today we provided a new update for our plugin which recreates missing database tables automatically if they are missing. I hope you are happy with this new update.

I hereby mark this topic as resolved.