timestamp defaults to now() while AR sees it as NOT NULL

[acron]

I have a table of the following structure in my mysql-db:

CREATE TABLE contract (
  contract              SERIAL,
  user                  BIGINT UNSIGNED     NOT NULL,
  start                 DATE                NOT NULL,
  end                   DATE,
  description           VARCHAR(59),

  changed               TIMESTAMP           DEFAULT now()  ON UPDATE now(),

  PRIMARY KEY             (contract),

  FOREIGN KEY             (user) REFERENCES user (user)
    ON DELETE RESTRICT

)
ENGINE = INNODB;

If I try to save a new record with an AR like this:

Code:

$ad = new ActionDump;
$ad->start = $dbStart;
$ad->end = $dbEnd;
$ad->action_type = $this->action_type->getDropDownList()->getDropDownList()->getSelectedValue();
$ad->contract = $contract;

$ad->save();

I get the follwing error:

TActiveRecordException
Description

Property 'ActionDump::$changed' must not be null as defined by column 'changed' in table '`action_dump`'.

So the question is: What's going wrong there? How can that issue be fixed?

Greetings acron

ps I *can* insert a record without setting the changed column using the mysql console or phpmyadmin...
pps the Contract-AR is generated by php-cli and not modified.

[andiTaker]

you can try the following in your ActionDump class:

Code:

class ActionDump extends TActiveRecord {

const TABLE ="blabla"

public $changed = 0;

public static function finder($className=__CLASS__)
{
return parent::finder($className);
}

[acron]

Thanks for your answer.
Explicit setting of a value which should be implictly be set by the default seems not a solution to me.

I consider the behaviour of AR as bugish and posted it with a possible solution here:
http://www.pradosoft.com/forum/index.php/topic,10603.0.html

Greets acron

[acron]

Thanks for your answer.
Explicit setting of a value which should be implictly set by a default value seems not a solution to me.

I consider the behaviour of AR as bugish and posted it with a possible solution here:
http://www.pradosoft.com/forum/index.php/topic,10603.0.html

Greets acron