[BUG] INSERT INTO table (col1,col3) VALUES (x,y) never works if col2 is a NOT NULL column.

Have you tried setting the default value in the model like so :

    public function beforeValidationOnCreate()
    {
        if ( !isset($this->field) || empty($this->field) ) {
            $this->field = new \Phalcon\Db\RawValue('default');
        }
    }

I've tried and worked just once, then left my database in this state: Error: Failed to read auto-increment value from storage engine

I needed droping and reassign the autoincrement type. Then it didnt work anymore but like at the beginning, with the null values.

Have you tried setting the default value in the model like so :

   public function beforeValidationCreate()
   {
       if ( !isset($this->field) || empty($this->field) ) {
           $this->field = new \Phalcon\Db\RawValue('default');
       }
   }

Have you tried changing beforeValidationOnCreate() to beforeValidation() ?

Doesn't. And on the way I've found two more bugs on the querybuilder of phalcon...really is getting a pain in the ass, I waste more time finding bugs than programming.

Have you tried changing beforeValidationOnCreate() to beforeValidation() ?

Hi, i had similiar problem with phalcon 1.3 ( or 1.2?) and oracle sql. Now i always set default values to model definition like this:

class ClassName extends \Phalcon\Mvc\Model {

    /**
     * ID
     *
     * @var int
     * @access protected
     */
    protected $ID;

    /**
     * SOME_COLUMN
     *
     * @var int
     * @access protected
     */
    protected $SOME_COLUMN = 'default_value';

    ...
}

I hope it helps or inspire you...