Skip to content
This repository has been archived by the owner on Jan 8, 2020. It is now read-only.
This repository has been archived by the owner on Jan 8, 2020. It is now read-only.

ZF2 2.0.6 Authentication and postgres database #3534

Closed
@joenilson

Description

Hi, i'm using zend server ce 5.6 SP4 with php 5.3.14 and zend framework 2.0.6 with a postgres database 9.1, i use the Authentication class using the example in the official documentation :

$adapter = new AuthAdapter($db,
'users',
'username',
'password',
"MD5(CONCAT('staticSalt', ?, password_salt))"
);

When i use it with mysql database it work fine, but with postgres i get this error:

SQLSTATE[42P18]: Indeterminate datatype: 7 ERROR: could not determine data type of parameter $1

When i change the CredentialTreatment from "MD5(CONCAT('staticSalt', ?, password_salt))" to "MD5(?)" it works fine, but when i change it to a simple "MD5(concat(?))" give me the same SQLSTATE error.

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions