Hello, I'm not experienced user of SQLite and i have small problem with my database. I'm using SQLite database for my website (through PHP PDO).
On remote Server everything is OK. I'm using: sqlite3 database.db and after '.tables' command I see all tables. Problems are on localhost: sqlite3 database.db SQLite version 3.4.2 Enter ".help" for instructions sqlite> .tables Error: malformed database schema - near "STATEMENT": syntax error Database.db it's of course the same file. I suppose problem is with different SQLite versions. On remote host it's 3.2.1 and on my localhost: 3.4.2. database.db was firstly 2.8 SQLITE database. A couple months ago I made migration by typing: sqlite old_database.db .dump | sqlite3 database.db Do I have to make anything like that again? I mean: migration from 3.2 to 3.4? Thank You for help. -- Best Regards Wojciech Kocjan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
