If you forgot "echo $form->renderHiddenFields();", then
"unset($this["id"])" make sense since the validator don't try to taint
the missing value.
Can you paste your template code please ?
Samuel Morhaim wrote:
unseting id worked.. However.. why is this necessary? The generated
Crud, did not do this initially, why is it necessary now? because i
unsetted one element, then i always need to unset id and such ?
On Thu, Feb 18, 2010 at 11:09 AM, Germana Oliveira
<germanaolivei...@gmail.com> wrote:
what about:
unset(
.....
$this['id']
);
2010/2/18 Daniel Lohse <annismcken...@googlemail.com>
Maybe yu forgot to do "echo $form->renderHiddenFields();" in your form so
the ID that's already assigned to the object is not transmitted when
submitting the form?
Daniel
On 18.02.2010, at 16:57, Samuel Morhaim wrote:
<?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.
--
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.
--
Germana Oliveira
germanaoliveirab arroba gmail punto com
http://626f67.wordpress.com
http://slcarabobo.wordpress.com
--
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.