I am processing a submitted Zend Form which updates a Doctrine Record using the following code, where $query is a query built using a doctrine query builder:
$record_array = $query->getResult();
$this->_record = $record_array[0];
if($this->getRequest()->isPost())
{
if ($this->_form->isValid($this->_request->getPost()))
{
$newEntity = $this->_form->update($this->_record);
$this->_em->flush();
$this->view->success = 'Record Saved.';
} else {
$this->view->errors = $this->_form->getErrors();
}
}
The above works fine if there are no integers in the record, i.e. only strings. However, I get the error above if I include fields on the form which are mapped as integers in the doctrine entity.
Any help would be appreciated.
UPDATE:
/**
* @var integer $solicitorid
*
* @Column(name="SolicitorID", type="integer", nullable=false)
* @Id
* @GeneratedValue(strategy="IDENTITY")
*/
private $solicitorid;
/**
* @var string $solicitor
*
* @Column(name="Solicitor", type="string", length=160, nullable=true)
*/
private $solicitor;
/**
* @var string $address
*
* @Column(name="Address", type="string", length=160, nullable=true)
*/
private $address;
/**
* @var string $town
*
* @Column(name="Town", type="string", length=100, nullable=true)
*/
private $town;
/**
* @var string $county
*
* @Column(name="County", type="string", length=100, nullable=true)
*/
private $county;
/**
* @var string $postcode
*
* @Column(name="Postcode", type="string", length=100, nullable=true)
*/
private $postcode;
/**
* @var string $dxaddress
*
* @Column(name="DXAddress", type="string", length=150, nullable=true)
*/
private $dxaddress;
/**
* @var string $phone
*
* @Column(name="phone", type="string", length=30, nullable=true)
*/
private $phone;
/**
* @var string $fax
*
* @Column(name="fax", type="string", length=30, nullable=true)
*/
private $fax;
/**
* @var string $email
*
* @Column(name="email", type="string", length=255, nullable=true)
*/
private $email;
/**
* @var string $password
*
* @Column(name="password", type="string", length=30, nullable=false)
*/
private $password;
/**
* @var integer $leadStatus
*
* @Column(name="lead_status", type="integer", nullable=true)
*/
private $leadStatus;
/**
* @var string $termsref
*
* @Column(name="termsRef", type="string", length=10, nullable=true)
*/
private $termsref;
/**
* @var integer $termsconditions
*
* @Column(name="termsconditions", type="integer", nullable=true)
*/
private $termsconditions;
/**
* @var date $termssent
*
* @Column(name="termsSent", type="date", nullable=true)
*/
private $termssent;
/**
* @var date $termssigneddate
*
* @Column(name="termssigneddate", type="date", nullable=true)
*/
private $termssigneddate;
/**
* @var integer $paymentterms
*
* @Column(name="paymentterms", type="integer", nullable=true)
*/
private $paymentterms;
/**
* @var integer $discountterms
*
* @Column(name="discountterms", type="integer", nullable=true)
*/
private $discountterms;
/**
* @var float $discountrate
*
* @Column(name="discountrate", type="float", nullable=true)
*/
private $discountrate;
/**
* @var integer $accountscontact
*
* @Column(name="AccountsContact", type="integer", nullable=true)
*/
private $accountscontact;
/**
* @var date $warned
*
* @Column(name="warned", type="date", nullable=true)
*/
private $warned;
/**
* @var float $feerate
*
* @Column(name="FeeRate", type="float", nullable=true)
*/
private $feerate;
/**
* @var string $labourrate
*
* @Column(name="LabourRate", type="string", length=100, nullable=true)
*/
private $labourrate;
/**
* @var text $specialinst
*
* @Column(name="SpecialInst", type="text", nullable=true)
*/
private $specialinst;
/**
* @var text $reportinst
*
* @Column(name="ReportInst", type="text", nullable=true)
*/
private $reportinst;
/**
* @var boolean $autostatement
*
* @Column(name="AutoStatement", type="boolean", nullable=true)
*/
private $autostatement;
/**
* @var datetime $lastmodifed
*
* @Column(name="lastModifed", type="datetime", nullable=false)
*/
private $lastmodifed;
Above is the entity. The issue comes when I try to update an integer field.