Authentication using DbTable Adapter doesn't work for 2.1.0

[samsonasik]

I tried 2.1.0 , and for Authentication using DbTable adapter result :

 SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

It just work for 2.0.6

[weierophinney]

Can you provide the code you're using, and the db schema, please?
On Jan 30, 2013 6:01 PM, "Abdul Malik Ikhsan" notifications@github.com
wrote:

I tried 2.1.0 , and for Authentication using DbTable adapter result :

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

It just work for 2.0.6

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/3623.

[samsonasik]

I'm using sample code here : https://github.com/samsonasik/SanAuth

for detail code dbtable auth adapter passing table , user, and password column :

'AuthService' => function($sm) {
    $dbAdapter = $sm->get('Zend\Db\Adapter\Adapter');
    $dbTableAuthAdapter = new \Zend\Authentication\Adapter\DbTable($dbAdapter,
                    'users','user_name','pass_word', 'MD5(?)');

    $authService = new \Zend\Authentication\AuthenticationService();
    $authService->setAdapter($dbTableAuthAdapter);

    return $authService;
},

with db table structure :

CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  user_name varchar(100) NOT NULL,
  pass_word varchar(100) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO users (user_name, pass_word)
    VALUES ('samsonasik', 'e10adc3949ba59abbe56e057f20f883e');

[Exlord]

i am having the same problem . my code was working fine with 2.0.5 today i updated and now its not working and getting the same exception ... any updated on this matter ???

It appears to be a pdo issue. All tests passed, but they use sqlite. When I test it with mysql I get the same exception. Looking into it.

Which db adapter were you using?

Found it.
https://github.com/zendframework/zf2/blob/master/library/Zend/Authentication/Adapter/DbTable.php#L369
The result of this line is 'SELECT users.*, (CASE WHEN password = MD5(:column1) THEN 1 ELSE 0 END) AS zend_auth_credential_match FROM users WHERE username = :where1'

Somehow the positional parameters are converted into named parameters.

ping @ralphschindler

[samsonasik]

I test using mysqli and pdo_mysql driver, get same error

[michalzwolinski]

Same here via Zend\Authentication\Adapter\DbTable. Probably sql query doesn't have values of params.

[intellix]

I was having this issue and the above fix worked :) thanks

[ThaDafinser]

Same problem with 2.1 here.

Above bugfix is fine!