<?php
/**
* Campaign Entry Form.
*/
class CampaignForm extends BaseCampaignForm
{
public function configure()
{
unset(
$this['organization_id'],
$this['is_active']
);
}
}
On Thu, Feb 18, 2010 at 10:42 AM, Gábor Fási <maerl...@gmail.com> wrote:
> This looks fine. Can we see your form's configure() method?
>
> On Thu, Feb 18, 2010 at 16:08, Samuel Morhaim <samuel.morh...@gmail.com>
> wrote:
>> Here goes the extra info. :)
>>
>> 1. I am just doing a simple edit. (based almost on the generated CRUD
>> actions)
>> 2. Yes, it is unique, (schema below).
>> 3. I am NOT trying to update/modify the ID since it is unique, etc.
>> THAT IS the problem.. for some reason it trying to set the ID to
>> empty. OR should not be updating the ID at all, but it is doing it....
>>
>>
>>
>>
>> Actions:
>>
>> public function executeEdit(sfWebRequest $request)
>> {
>> $this->forward404Unless($campaign =
>> Doctrine::getTable('Campaign')->find(array($request->getParameter('id'))),
>> sprintf('Object campaign does not exist (%s).',
>> $request->getParameter('id')));
>> $this->form = new CampaignForm($campaign);
>> }
>>
>> public function executeUpdate(sfWebRequest $request)
>> {
>> $this->forward404Unless($request->isMethod(sfRequest::POST) ||
>> $request->isMethod(sfRequest::PUT));
>> $this->forward404Unless($campaign =
>> Doctrine::getTable('Campaign')->find(array($request->getParameter('id'))),
>> sprintf('Object campaign does not exist (%s).',
>> $request->getParameter('id')));
>> $this->form = new CampaignForm($campaign);
>>
>> $this->processForm($request, $this->form);
>>
>> $this->campaigns =
>> Doctrine::getTable('Campaign')->getCampaigns($this->getUser()->getGuardUser()->Organization);
>> $this->setLayout(AJAX_ENABLED);
>> return $this->renderPartial('campaign/list', array('campaigns' =>
>> $this->campaigns));
>> }
>>
>> protected function processForm(sfWebRequest $request, sfForm $form)
>> {
>> $form->bind($request->getParameter($form->getName()),
>> $request->getFiles($form->getName()));
>> if ($form->isValid())
>> {
>> $campaign = $form->save();
>>
>> }
>> }
>>
>>
>>
>> ======================
>>
>>
>> SCHEMA
>>
>> Campaign:
>> columns:
>> id:
>> primary: true
>> unique: true
>> type: integer
>> notnull: true
>> autoincrement: true
>> organization_id:
>> type: integer
>> notnull: true
>> name:
>> unique: false
>> type: string(255)
>> notnull: true
>> description:
>> type: blob(0)
>> is_active:
>> default: true
>> type: boolean
>> notnull: true
>> indexes:
>> IX_Campaign_1:
>> fields: [id]
>> IX_Campaign_2:
>> fields: [is_active]
>> relations:
>> Organization:
>> local: organization_id
>> foreign: id
>>
>>
>>
>> =======
>>
>>
>>
>> 2010/2/18 Michał Piotrowski <mkkp...@gmail.com>:
>>> I'm wondering why do you want to update id? I assume that you are
>>> using id as primary key, so updating it to other value just doesn't
>>> makes sense.
>>>
>>> Maybe someone will help you if you explain what do you want to do.
>>> Actually we don't have enough information on such things as:
>>> - what do you want to do
>>> - what you are doing - iow - show us the code - maybe others are, but
>>> I'm not a seer :)
>>>
>>> Regards,
>>> Michal
>>>
>>> 2010/2/18 Samuel Morhaim <samuel.morh...@gmail.com>:
>>>> Anyone?
>>>>
>>>> On 2/17/10, Samuel Morhaim <samuel.morh...@gmail.com> wrote:
>>>>> If it helps.. this is the error, of course because it lost the id..
>>>>>
>>>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
>>>>> '0' for key 1
>>>>> stack trace
>>>>>
>>>>> * at ()
>>>>> in
>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>>>>> line 1082 ...
>>>>> 1079. $message .= sprintf('. Failing Query:
>>>>> "%s"', $query);
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Feb 17, 2010 at 5:20 PM, Samuel Morhaim
>>>>> <samuel.morh...@gmail.com> wrote:
>>>>>> I am getting an error when doing a simple edit/update ... the ID of
>>>>>> the item is being lost.
>>>>>>
>>>>>> This is the DB log... maybe somebody can help ?
>>>>>>
>>>>>>
>>>>>> #
>>>>>>
>>>>>> SELECT c.id AS c__id, c.organization_id AS c__organization_id, c.name
>>>>>> AS c__name, c.description AS c__description, c.is_active AS
>>>>>> c__is_active FROM campaign c WHERE (c.id = '2') LIMIT 1
>>>>>> 0.00s, "doctrine" connection Toggle debug stack
>>>>>> #23 » in sfDoctrineConnectionProfiler->preStmtExecute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/EventListener/Chain.php
>>>>>> line 494
>>>>>> #22 » in Doctrine_EventListener_Chain->preStmtExecute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php
>>>>>> line 231
>>>>>> #21 » in Doctrine_Connection_Statement->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>>>>>> line 1006
>>>>>> #20 » in Doctrine_Connection->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php
>>>>>> line 976
>>>>>> #19 » in Doctrine_Query_Abstract->_execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php
>>>>>> line 1026
>>>>>> #18 » in Doctrine_Query_Abstract->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query.php
>>>>>> line 281
>>>>>> #17 » in Doctrine_Query->fetchOne() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Table.php
>>>>>> line 1611
>>>>>> #16 » in Doctrine_Table->find() from
>>>>>> SF_ROOT_DIR/apps/backend/modules/campaign/actions/actions.class.php
>>>>>> line 53
>>>>>> #15 » in campaignActions->executeUpdate() from
>>>>>> SF_SYMFONY_LIB_DIR/action/sfActions.class.php line 60
>>>>>> #14 » in sfActions->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 92
>>>>>> #13 » in sfExecutionFilter->executeAction() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 78
>>>>>> #12 » in sfExecutionFilter->handleAction() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 42
>>>>>> #11 » in sfExecutionFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #10 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfBasicSecurityFilter.class.php line 72
>>>>>> #9 » in sfBasicSecurityFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #8 » in sfFilterChain->execute() from
>>>>>> SF_ROOT_DIR/plugins/sfDoctrineGuardPlugin/lib/sfGuardRememberMeFilter.class.php
>>>>>> line 56
>>>>>> #7 » in sfGuardRememberMeFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #6 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfRenderingFilter.class.php line 33
>>>>>> #5 » in sfRenderingFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #4 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/controller/sfController.class.php line 229
>>>>>> #3 » in sfController->forward() from
>>>>>> SF_SYMFONY_LIB_DIR/controller/sfFrontWebController.class.php line 48
>>>>>> #2 » in sfFrontWebController->dispatch() from
>>>>>> SF_SYMFONY_LIB_DIR/util/sfContext.class.php line 170
>>>>>> #1 » in sfContext->dispatch() from SF_ROOT_DIR/web/backend_dev.php line
>>>>>> 13
>>>>>> #
>>>>>>
>>>>>> SELECT c.id AS c__id, c.organization_id AS c__organization_id, c.name
>>>>>> AS c__name, c.description AS c__description, c.is_active AS
>>>>>> c__is_active FROM campaign c WHERE (c.id = '')
>>>>>> 0.00s, "doctrine" connection Toggle debug stack
>>>>>> #31 » in sfDoctrineConnectionProfiler->preStmtExecute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/EventListener/Chain.php
>>>>>> line 494
>>>>>> #30 » in Doctrine_EventListener_Chain->preStmtExecute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php
>>>>>> line 231
>>>>>> #29 » in Doctrine_Connection_Statement->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>>>>>> line 1006
>>>>>> #28 » in Doctrine_Connection->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php
>>>>>> line 976
>>>>>> #27 » in Doctrine_Query_Abstract->_execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php
>>>>>> line 1026
>>>>>> #26 » in Doctrine_Query_Abstract->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query.php
>>>>>> line 281
>>>>>> #25 » in Doctrine_Query->fetchOne() from
>>>>>> SF_SYMFONY_LIB_DIR/plugins/sfDoctrinePlugin/lib/validator/sfValidatorDoctrineUnique.class.php
>>>>>> line 99
>>>>>> #24 » in sfValidatorDoctrineUnique->doClean() from
>>>>>> SF_SYMFONY_LIB_DIR/validator/sfValidatorSchema.class.php line 90
>>>>>> #23 » in sfValidatorSchema->clean() from
>>>>>> SF_SYMFONY_LIB_DIR/validator/sfValidatorSchema.class.php line 246
>>>>>> #22 » in sfValidatorSchema->postClean() from
>>>>>> SF_SYMFONY_LIB_DIR/validator/sfValidatorSchema.class.php line 186
>>>>>> #21 » in sfValidatorSchema->doClean() from
>>>>>> SF_SYMFONY_LIB_DIR/validator/sfValidatorSchema.class.php line 90
>>>>>> #20 » in sfValidatorSchema->clean() from
>>>>>> SF_SYMFONY_LIB_DIR/form/sfForm.class.php line 247
>>>>>> #19 » in sfForm->doBind() from
>>>>>> SF_SYMFONY_LIB_DIR/form/addon/sfFormSymfony.class.php line 75
>>>>>> #18 » in sfFormSymfony->doBind() from
>>>>>> SF_SYMFONY_LIB_DIR/form/sfForm.class.php line 227
>>>>>> #17 » in sfForm->bind() from
>>>>>> SF_ROOT_DIR/apps/backend/modules/campaign/actions/actions.class.php
>>>>>> line 77
>>>>>> #16 » in campaignActions->processForm() from
>>>>>> SF_ROOT_DIR/apps/backend/modules/campaign/actions/actions.class.php
>>>>>> line 56
>>>>>> #15 » in campaignActions->executeUpdate() from
>>>>>> SF_SYMFONY_LIB_DIR/action/sfActions.class.php line 60
>>>>>> #14 » in sfActions->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 92
>>>>>> #13 » in sfExecutionFilter->executeAction() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 78
>>>>>> #12 » in sfExecutionFilter->handleAction() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 42
>>>>>> #11 » in sfExecutionFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #10 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfBasicSecurityFilter.class.php line 72
>>>>>> #9 » in sfBasicSecurityFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #8 » in sfFilterChain->execute() from
>>>>>> SF_ROOT_DIR/plugins/sfDoctrineGuardPlugin/lib/sfGuardRememberMeFilter.class.php
>>>>>> line 56
>>>>>> #7 » in sfGuardRememberMeFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #6 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfRenderingFilter.class.php line 33
>>>>>> #5 » in sfRenderingFilter->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 53
>>>>>> #4 » in sfFilterChain->execute() from
>>>>>> SF_SYMFONY_LIB_DIR/controller/sfController.class.php line 229
>>>>>> #3 » in sfController->forward() from
>>>>>> SF_SYMFONY_LIB_DIR/controller/sfFrontWebController.class.php line 48
>>>>>> #2 » in sfFrontWebController->dispatch() from
>>>>>> SF_SYMFONY_LIB_DIR/util/sfContext.class.php line 170
>>>>>> #1 » in sfContext->dispatch() from SF_ROOT_DIR/web/backend_dev.php line
>>>>>> 13
>>>>>> #
>>>>>>
>>>>>> UPDATE campaign SET name = 'TER', id = '' WHERE id = '2'
>>>>>>
>>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google Groups
>>>> "symfony users" group.
>>>> To post to this group, send email to symfony-us...@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> symfony-users+unsubscr...@googlegroups.com.
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/symfony-users?hl=en.
>>>>
>>>>
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "symfony users" group.
>> To post to this group, send email to symfony-us...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> symfony-users+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/symfony-users?hl=en.
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
