WordPress.org

Support

Support » Plugins and Hacks » Error: The event could not be added to the database. This may indicate a problem

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Bev

    @bstofko

    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’

    );

    Plugin Author Bev

    @bstofko

    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

    Plugin Author Bev

    @bstofko

    Turn on WP_DEBUG, see http://codex.wordpress.org/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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error: The event could not be added to the database. This may indicate a problem’ is closed to new replies.