WP Calendar
DB Error when inserting an Event (3 posts)

  1. nascent666
    Posted 5 years ago #

    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.

  2. nascent666
    Posted 5 years ago #

    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.

  3. faebu
    Plugin Author

    Posted 5 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP Calendar
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic