On 3/9/07, Kyohere Luke <[EMAIL PROTECTED]> wrote:
Hello, I'm using ZF 0.8.0 on windows with Sqlite version 3.3.7 and PHP 5.2.0. I've tried everything to get ZF to successfully insert data into the database but I keep getting the error: *Fatal error *: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 SQL logic error or missing database' in C:\Program ... etc
This error usually mean that statement cannot be accepted by the database engine because of primary key violation, setting not-null field with null value, and so forth. I have solved this by dumping the query and trying to execute it in separate script. The query can be dumped in Zend_Db_Adapter_Abstract::insert(). I've tried $db->insert(..), $db->query and $tableObj->save(). $row->save() is calling $db->insert() so this methods does the similar thing. To the best of my knowledge, the file system is writable. Is there something
i'm missing? Has anyone come across this? I saw a similar bug report online, but that user was able to get the insert to work in some cases (using the pdo object directly?). It also said that the bug was fixed in 0.8.0. Please help, Thanks! Luk
Sincerely, -- Alexander http://www.alexatnet.com/ - Blog and CMS created with Zend Framework and Ajax.
