I am trying to migrate my opensource project (http://blogcms.com/) from MySQL 4.0 (mysql) and MySQL 4.1 (mysqli) to SQLite as well. Seems pretty easy with DB layer, but... when I open DB via sqlite_open() and execute few CREATE TABLE queries, via sqlite_query(), the connection is dropped and I cannot execute any other queries anymore.
This is what I get (customized error message): Invalid query: CREATE INDEX membername ON nucleus_member (mname); Error: SQL logic error or missing database When I try to execute the same query using sqlitecc.exe it works just fine. Index is created. Have spend last 3 hours trying to get more than 10 tables / indexes created, but with no luck. Any hints where to look for my own / SQLite bugs? Radek