ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Channel Form DB Error on Submit

October 16, 2014 12:56pm

Subscribe [1]
  • #1 / Oct 16, 2014 12:56pm

    matchlessamp

    14 posts

    I have a channel form that when I hit submit, I get this error message:

    Error Number: 1364
    
    Field 'field_id_2' doesn't have a default value
    
    INSERT INTO `exp_channel_data` (`entry_id`, `channel_id`, `site_id`, `field_id_9`, `field_ft_9`) VALUES (8, '3', '1', 'in vcc.', 'none')
    
    Filename: libraries/api/Api_channel_entries.php
    
    Line Number: 1507

    This is my template: Very simple, a user should be able to add Gigs, for now as a test, with just a title and a description box.

    {exp:channel:form channel="gigs" return="/gigs"}
      <input name="title" id="title" type="text">
      <textarea name="gig_description" id="gig_description"></textarea>
      <input type="submit" value="Submit">
    {/exp:channel:form}
    {exp:channel:entries channel="gigs"}
    {title}
    {/exp:channel:entries}
.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases