[Plugin: WP Calendar] DB Error when inserting an Event

  • Hi. I just installed and activated the WP Calendar (Version 1.4.3). I’m using WP 3.1. I tried to add my first event and I got a DB error…

    INSERT INTO wp_fsevents (subject, tsfrom, tsto, allday, description, location, author, createdate, state, postid, updatedbypost) VALUES ('This is the subject field', 1300909500, 1300914300, 0, 'This is the description field.', 'This is the location field', 1, 1300909431, 'draft', NULL, 0)
DB Error

    I then go into phpmyadmin and try to insert the same SQL statement and get this…

    #1364 - Field 'publishauthor' doesn't have a default value

    Can you help me get passed this?

    I’m going to assume it has something to do with the field, publishauthor, where the type is bigint(20) and Null is set to No without a default and you aren’t passing any info to it via the INSERT.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter nascent666

    (@nascent666)

    Follow up…

    I think there is a bug in your CREATE TABLE within fsCalendar.php. I think it needs to be:

    ....
publishauthor BIGINT NULL,
publishdate INT NULL,
....

    In order for me to add an Event, I needed to change the structure of your table, wp_fsevents. I changed the fields, publishauthor and publishdate to allow NULL.

    Plugin Author faebu

    (@faebu)

    yes this is an error. don’t know why this is working in my blogs… i allready fixed but i’m currently fixing another issue with zime zones. i hope to release an update on weekend.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: WP Calendar] DB Error when inserting an Event’ is closed to new replies.