2

I ran into a strange error, I want to share it with you.

I had to convert my MySQL database to SQLite, which was actually a piece of cake with the program called DBConvert.

So I changed in my application.ini:

resources.db.adapter = "PDO_SQLITE"
resources.db.params.dbname = APPLICATION_PATH "/../data/db/db_name.db"

And try to show my website, everything looks correct. Except when I try to login to my website, it gives the following error: The supplied parameters to Zend_Auth_Adapter_DbTable failed to produce a valid sql statement, please check table and column names for validity.

markus
  • 40,136
  • 23
  • 97
  • 142
DelphiLynx
  • 911
  • 1
  • 16
  • 41
  • 2
    Move everything below the line in your question to an answer, posted below. In 2 days, you can mark it as the accepted answer. – Robert Harvey Apr 26 '11 at 15:29
  • 1
    Because SHA is not supported by SqLite. Same thing with PostgreSQL and SHA1. So, it is not "fault" of ZF, but sqlite. So your question title could be more specific ;) – Radek Benkel Sep 03 '11 at 16:25

1 Answers1

1

setCredentialTreatment(SHA(?)) is not supported by SQLite.

Remove that setCredentialTreatment line, and change the following:

$authAdapter->setCredential(**sha1(**$password));
markus
  • 40,136
  • 23
  • 97
  • 142