Help needed with sqlite

troy · #1 (**permalink**) 04-06-2008, 11:05 PM

Hello
I am very new to Zend moving from CodeIgnitor

Following code will list the tables but not execute anything else.
I tried DROP, CREATE and SELECT

I even set the file to rw 777
-rwxrwxrwx 1 www-data www-data 2048 2008-04-06 18:19 sqlite.db

PHP Code:


			
try {

    require_once 'Zend/Db/Adapter/Pdo/Sqlite.php';

    require_once 'Zend/Auth/Adapter/DbTable.php';

    $sqlite = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => ROOT.'/sqlite.db'));

    $sqlite->getConnection();

} catch (Zend_Db_Adapter_Exception $e) {

    echo $e->getMessage();

} catch (Zend_Exception $e) {

    echo $e->getMessage();

}

// This works

echo '<pre> Tables';print_r($sqlite->listTables());



// This doesn't works

$sql = 'DROP TABLE IF EXISTS log';

$sqlite->query($sql);

TablesArray
(
[0] => log
)

Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 14 unable to open database file' in /opt/zend/library/Zend/Db/Statement/Pdo.php:238
Stack trace:
#0 /opt/zend/library/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /opt/zend/library/Zend/Db/Adapter/Abstract.php(405): Zend_Db_Statement->execute(Array)
#2 /opt/zend/library/Zend/Db/Adapter/Pdo/Abstract.php(205): Zend_Db_Adapter_Abstract->query('DROP TABLE IF E...', Array)
#3 /var/www/pzzazz/zend/accounts.php(75): Zend_Db_Adapter_Pdo_Abstract->query('DROP TABLE IF E...')
#4 /var/www/pzzazz/zend/public/index.php(20): require_once('/var/www/pzzazz...')
#5 {main}
thrown in /opt/zend/library/Zend/Db/Statement/Pdo.php on line 238

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode