Error: The event could not be added to the database. This may indicate a problem

Can you give me more details about the event you are trying to create?

Also check your database. Table wp_spiffy_calendar should have the following structure:

event_id INT(11) NOT NULL AUTO_INCREMENT ,
event_begin DATE NOT NULL ,
event_end DATE NOT NULL ,
event_title VARCHAR(30) NOT NULL ,
event_desc TEXT NOT NULL ,
event_time TIME ,
event_end_time TIME ,
event_recur CHAR(1) ,
event_repeats INT(3) ,
event_author BIGINT(20) UNSIGNED ,
event_category BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ,
event_link TEXT ,
event_image BIGINT(20) UNSIGNED ,
PRIMARY KEY (event_id)

The DDl for the table…

CREATE TABLE wp_spiffy_calendar (
event_id int(11) NOT NULL AUTO_INCREMENT,
event_begin date NOT NULL,
event_end date NOT NULL,
event_title varchar(30) NOT NULL,
event_desc text NOT NULL,
event_time time DEFAULT NULL,
event_end_time time DEFAULT NULL,
event_recur char(1) DEFAULT NULL,
event_repeats int(3) DEFAULT NULL,
event_author bigint(20) unsigned DEFAULT NULL,
event_category bigint(20) unsigned NOT NULL DEFAULT ‘1’,
event_link text,
event_image bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (event_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$

I tried to create an event with

eventname : what ever
date: 2013-05-29

I manage to run this from Mysql workbench

INSERT INTO wordpress.wp_spiffy_calendar
(
event_begin,
event_end,
event_title,
event_desc
)
VALUES
(
‘2013-05-23’,
‘2013-05-23’,
‘Etest’,
‘desc’

);

Are you able to get any logging? Try running your WordPress install in debug mode or check the error logs on your server for any SQL errors.

please elaborate

Turn on WP_DEBUG, see https://codex.www.ads-software.com/Debugging_in_WordPress

This may give you some helpful error messages.

Your server may also have an error log at the root directory of your WordPress installation.