WordPress.org

Ready to get started?Download WordPress

Forums

Spiffy Calendar
Error: The event could not be added to the database. This may indicate a problem (7 posts)

  1. thuan.van.nguyen@gmail.com
    Member
    Posted 1 year ago #

    I'm using mysql 5.6 and having this error when adding events

    Error: The event could not be added to the database. This may indicate a problem with your database or the way in which it is configured

    Any ideas?

    and thanks for the plugin.

    http://wordpress.org/extend/plugins/spiffy-calendar/

  2. Bev
    Member
    Plugin Author

    Posted 1 year ago #

    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)

  3. thuan.van.nguyen@gmail.com
    Member
    Posted 1 year ago #

    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

  4. thuan.van.nguyen@gmail.com
    Member
    Posted 1 year ago #

    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'

    );

  5. Bev
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  6. thuan.van.nguyen@gmail.com
    Member
    Posted 1 year ago #

    please elaborate

  7. Bev
    Member
    Plugin Author

    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.