[SOLVED] Zend_Auth_Adapter_DbTable and Zend_Db_Adapter_Pdo_Sqlite error

[nadeemshafi9]

my application can connect to the guestbook sqlite db throgh its wired configuration but here i am having trouble , i think it has somthing to do with this :memory: buisness

 

$db = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => ':memory:'));
                $authAdapter = new Zend_Auth_Adapter_DbTable($db);
                $authAdapter->setTableName('users');
                $authAdapter->setIdentityColumn('username');
                $authAdapter->setCredentialColumn('password');

 

 

Message: The supplied parameters to Zend_Auth_Adapter_DbTable failed to produce a valid sql statement, please check table and column names for validity.

 

CREATE TABLE [users] ( 
			[id] INTEGER  NOT NULL PRIMARY KEY,  
			[username] VARCHAR(50) UNIQUE NOT NULL,  
			[password] VARCHAR(32) NULL,  
			[real_name] VARCHAR(150) NULL)

 

any help , thanks

 

 

 

[nadeemshafi9]

$db = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => APPLICATION_PATH."/../data/db/guestbook-dev.db"));