Hi,
my error occurs because symfony is generating this (you'll find it in
my post before):
Doctrine_Connection->execute('SELECT b.id AS b__id, b.day AS
b__day FROM birthday b WHERE b.day >= ? AND b.day <= ?', array('month'
=> '1', 'day' => '2', 'year' => '2014'))
Ok, the clause is a bit confuse because i called "day" the field of
Birthday model. If I call it "testdate" this would be the result:
Doctrine_Connection->execute('SELECT b.id AS b__id, b.testdate AS
b__testdate FROM birthday b WHERE b.testdate >= ? AND b.testdate
<= ?', array('month'
=> '1', 'day' => '2', 'year' => '2014'))
To the point: i still don't know how to solve this..
Javi
On Jan 5, 2:40 pm, tirengarfio <[email protected]> wrote:
> Hi,
>
> I have added this model and this fixture to my app:
>
> Birthday:
> columns:
> day: date
>
> Birthday:
> example:
> day: "2010-1-1"
>
> I have generated the Birthday module. Then I've generated the filter
> class (BirthdayFormFilter.class.php) and I have created a form filter
> object in executeIndex():
>
> $this->filter = new BirthdayFormFilter();
>
> After that, i've added this lines to the index template:
>
> <?php echo form_tag('birthday/filtrar') ?>
> <?php echo $filter; ?>
> <div><?php echo submit_tag('Filter') ?></div>
> </form>
>
> When i click the 'Filter' button i get this error:
>
> 500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
> SQLSTATE[HY093]: Invalid parameter number: number of bound variables
> does not match number of tokens
> stack trace
>
> * at ()
> in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Connection.php line 1086 ...
> 1083.
> 1084. $name = 'Doctrine_Connection_' . $this->driverName
> . '_Exception';
>
> 1085.
> 1086. $exc = new $name($e->getMessage(), (int)
> $e->getCode());
>
> 1087. if ( ! isset($e->errorInfo) || !
> is_array($e->errorInfo)) {
>
> 1088. $e->errorInfo = array(null, null, null,
> null);
> 1089. }
> * at Doctrine_Connection->rethrowException(object('PDOException'),
> object('Doctrine_Connection_Statement'))
> in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Connection/Statement.php line 253 ...
> 250. } catch (Doctrine_Adapter_Exception $e) {
> 251. }
> 252.
> 253. $this->_conn->rethrowException($e, $this);
> 254.
> 255. return false;
> 256. }
> * at Doctrine_Connection_Statement->execute(array('month' => '1',
> 'day' => '2', 'year' => '2014'))
> in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Connection.php line 1014 ...
> 1011. try {
> 1012. if ( ! empty($params)) {
> 1013. $stmt = $this->prepare($query);
> 1014. $stmt->execute($params);
> 1015.
> 1016. return $stmt;
> 1017. } else {
> * at Doctrine_Connection->execute('SELECT b.id AS b__id, b.day AS
> b__day FROM birthday b WHERE b.day >= ? AND b.day <= ?', array('month'
> => '1', 'day' => '2', 'year' => '2014'))
> in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Query/Abstract.php line 992 ...
> 989. return $this->_conn->exec($query,
> $params);
> 990. }
> 991.
> 992. $stmt = $this->_conn->execute($query,
> $params);
> 993. return $stmt;
> 994. }
> 995.
> * at Doctrine_Query_Abstract->_execute(array('month' => '1', 'day'
> => '2', 'year' => '2014'))
> in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Query/Abstract.php line 1036 ...
> 1033. $result =
> $this->_constructQueryFromCache($cached);
>
> 1034. }
> 1035. } else {
> 1036. $stmt = $this->_execute($params);
> 1037.
> 1038. if (is_integer($stmt)) {
> 1039. $result = $stmt;
> * at Doctrine_Query_Abstract->execute()
> in SF_ROOT_DIR/apps/frontend/modules/birthday/actions/
> actions.class.php li
>
> Any idea?
>
> Javi
--
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.
