The example is with sfGuardDoctrine plugin, but i am sure the core of
the problem is somewhere within Doctrine and/or the sfDoctrinePlugin
itself.
Basicly, what gets broken is adding a new user trough the generated
admin interface. The error i get is :
[Doctrine_Connection_Pgsql_Exception]
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input
syntax for integer: ""
at ()
in SF_ROOT_DIR\plugins\sfDoctrinePlugin\lib\doctrine\Doctrine
\Connection.php line 1056 ...
$name = 'Doctrine_Connection_' . $this->driverName .
'_Exception';
$exc = new $name($e->getMessage(), (int) $e->getCode());
if ( ! is_array($e->errorInfo)) {
$e->errorInfo = array(null, null, null, null);
}at Doctrine_Connection-
>rethrowException(object('PDOException'),
object('Doctrine_Connection_Statement'))in SF_ROOT_DIR\plugins
\sfDoctrinePlugin\lib\doctrine\Doctrine\Connection\Statement.php line
244 ... } catch (Doctrine_Adapter_Exception $e) {
}
$this->_conn->rethrowException($e, $this);
return false;
}
at Doctrine_Connection_Statement->execute(array('gosho', ''))in
SF_ROOT_DIR\plugins\sfDoctrinePlugin\lib\doctrine\Doctrine
\Connection.php line 985 ... try {
if ( ! empty($params)) {
$stmt = $this->prepare($query);
$stmt->execute($params);
return $stmt;
} else {at Doctrine_Connection->execute('SELECT s.id AS
s__id, s.username AS s__username, s.algorithm AS s__algorithm, s.salt
AS s__salt, s.password AS s__password, s.last_login AS s__last_login,
s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin,
s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM
sf_guard_user s WHERE (s.username = ? AND s.id != ?)', array('gosho',
''))in SF_ROOT_DIR\plugins\sfDoctrinePlugin\lib\doctrine\Doctrine\Query
\Abstract.php line 977 ... return $this->_conn-
>exec($query, $params);
}
$stmt = $this->_conn->execute($query, $params);
return $stmt;
}
at Doctrine_Query_Abstract->_execute(array('gosho', ''))in SF_ROOT_DIR
\plugins\sfDoctrinePlugin\lib\doctrine\Doctrine\Query\Abstract.php
line 1019 ... $result = $this-
>_constructQueryFromCache($cached);
}
} else {
$stmt = $this->_execute($params);
if (is_integer($stmt)) {
$result = $stmt;at Doctrine_Query_Abstract-
>execute(array('gosho', ''))in SF_ROOT_DIR\plugins\sfDoctrinePlugin\lib
\validator\sfDoctrineUniqueValidator.class.php line 67 ... $res =
$query->execute(array($value));
} else {
$query->where($columnName.' = ? AND '.$primaryKey.' != ?');
$res = $query->execute(array($value, $primaryKeyValue));
}
if ($res->count())at sfDoctrineUniqueValidator->execute('gosho',
null)in SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\validator
\sfValidatorManager.class.php line 299 ... // loop through our
validators
foreach ($data['validators'] as $validator)
{
if (!$validator->execute($value, $error))
{
$retval = false;
at sfValidatorManager->validate('username', array(null, 'is_file' =>
'', 'required' => '1', 'required_msg' => 'Please, enter a username',
'validation_status' => '1',
array(object('sfDoctrineUniqueValidator'))), 'sf_guard_user')in
SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\validator
\sfValidatorManager.class.php line 93 ... continue;
}
if ($subdata['validation_status'] == true && !$this-
>validate($subname, $subdata, $name))
{
// validation failed
$retval = false;at sfValidatorManager->execute()in
SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\filter
\sfValidationExecutionFilter.class.php line 137 ...
require($validateFile);
// process validators
$validated = $validatorManager->execute();
}
// process manual validationat sfValidationExecutionFilter-
>validateAction(object('sfFilterChain'),
object('sfGuardUserActions'))in SF_SYMFONY_LIB_DIR\plugins
\sfCompat10Plugin\lib\filter\sfValidationExecutionFilter.class.php
line 92 ... return $actionInstance->getDefaultView();
}
return $this->validateAction($filterChain, $actionInstance) ?
$this->executeAction($actionInstance) : $this-
>handleErrorAction($actionInstance);
}
/**at sfValidationExecutionFilter-
>handleAction(object('sfFilterChain'), object('sfGuardUserActions'))in
SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\filter
\sfValidationExecutionFilter.class.php line 43 ... $timer =
sfTimerManager::getTimer(sprintf('Action "%s/%s"', $actionInstance-
>getModuleName(), $actionInstance->getActionName()));
}
$viewName = $this->handleAction($filterChain, $actionInstance);
if (sfConfig::get('sf_debug') &&
sfConfig::get('sf_logging_enabled'))
{at sfValidationExecutionFilter-
>execute(object('sfFilterChain'))in SF_SYMFONY_LIB_DIR\filter
\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\filter
\sfCommonFilter.class.php line 29 ... public function
execute($filterChain)
{
// execute next filter
$filterChain->execute();
// execute this filter only once
$response = $this->context->getResponse();at sfCommonFilter-
>execute(object('sfFilterChain'))in SF_SYMFONY_LIB_DIR\filter
\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\filter
\sfRenderingFilter.class.php line 33 ... public function
execute($filterChain)
{
// execute next filter
$filterChain->execute();
if (sfConfig::get('sf_logging_enabled'))
{at sfRenderingFilter->execute(object('sfFilterChain'))in
SF_SYMFONY_LIB_DIR\filter\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\controller
\sfController.class.php line 250 ... }
// process the filter chain
$filterChain->execute();
}
else
{at sfController->forward('sfGuardUser', 'edit')in
SF_SYMFONY_LIB_DIR\action\sfAction.class.php line 136 ... $this-
>dispatcher->notify(new sfEvent($this, 'application.log',
array(sprintf('Forward to action "%s/%s"', $module, $action))));
}
$this->getController()->forward($module, $action);
throw new sfStopException();
}at sfAction->forward('sfGuardUser', 'edit')in SF_ROOT_DIR\cache
\frontend\dev\modules\autoSfGuardUser\actions\actions.class.php line
55 ...
public function executeSave ()
{
return $this->forward('sfGuardUser', 'edit');
}
public function executeEdit ()at autoSfGuardUserActions-
>executeSave(object('sfWebRequest'))in SF_SYMFONY_LIB_DIR\action
\sfActions.class.php line 53 ... }
// run action
return $this->$actionToRun($request);
}
}
at sfActions->execute(object('sfWebRequest'))
in SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\filter
\sfValidationExecutionFilter.class.php line 174 ...
{
// execute the action
$actionInstance->preExecute();
$viewName = $actionInstance->execute($this->context-
>getRequest());
$actionInstance->postExecute();
return $viewName ? $viewName : sfView::SUCCESS;at
sfValidationExecutionFilter-
>executeAction(object('sfGuardUserActions'))in SF_SYMFONY_LIB_DIR
\plugins\sfCompat10Plugin\lib\filter
\sfValidationExecutionFilter.class.php line 92 ... return
$actionInstance->getDefaultView();
}
return $this->validateAction($filterChain, $actionInstance) ?
$this->executeAction($actionInstance) : $this-
>handleErrorAction($actionInstance);
}
/**at sfValidationExecutionFilter-
>handleAction(object('sfFilterChain'), object('sfGuardUserActions'))in
SF_SYMFONY_LIB_DIR\plugins\sfCompat10Plugin\lib\filter
\sfValidationExecutionFilter.class.php line 43 ... $timer =
sfTimerManager::getTimer(sprintf('Action "%s/%s"', $actionInstance-
>getModuleName(), $actionInstance->getActionName()));
}
$viewName = $this->handleAction($filterChain, $actionInstance);
if (sfConfig::get('sf_debug') &&
sfConfig::get('sf_logging_enabled'))
{at sfValidationExecutionFilter-
>execute(object('sfFilterChain'))in SF_SYMFONY_LIB_DIR\filter
\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\filter
\sfCommonFilter.class.php line 29 ... public function
execute($filterChain)
{
// execute next filter
$filterChain->execute();
// execute this filter only once
$response = $this->context->getResponse();at sfCommonFilter-
>execute(object('sfFilterChain'))in SF_SYMFONY_LIB_DIR\filter
\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\filter
\sfRenderingFilter.class.php line 33 ... public function
execute($filterChain)
{
// execute next filter
$filterChain->execute();
if (sfConfig::get('sf_logging_enabled'))
{at sfRenderingFilter->execute(object('sfFilterChain'))in
SF_SYMFONY_LIB_DIR\filter\sfFilterChain.class.php line 53 ... }
// execute the next filter
$this->chain[$this->index]->execute($this);
}
}
at sfFilterChain->execute()in SF_SYMFONY_LIB_DIR\controller
\sfController.class.php line 250 ... }
// process the filter chain
$filterChain->execute();
}
else
{at sfController->forward('sfGuardUser', 'save')in
SF_SYMFONY_LIB_DIR\controller\sfFrontWebController.class.php line
53 ... }
// make the first request
$this->forward($moduleName, $actionName);
}
catch (sfException $e)
{at sfFrontWebController->dispatch()in SF_SYMFONY_LIB_DIR\util
\sfContext.class.php line 164 ... */
public function dispatch()
{
$this->getController()->dispatch();
}
/**at sfContext->dispatch()in SF_ROOT_DIR\web\frontend_dev.php line
12 ...require_once(dirname(__FILE__).'/../config/
ProjectConfiguration.class.php');
$configuration =
ProjectConfiguration::getApplicationConfiguration('frontend', 'dev',
true);
sfContext::createInstance($configuration)->dispatch();
Everything is working fine, if i switch to mysql.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
