Re: [sqlite] Malformed database schema with SQLite version > 3.5.x
I actually created all my views by means of "CREATE VIEW ... AS ...", and (as Mr. Hipp said) these views was accepted from SQLite as "valid" SQL statements. The problem (was) that right now I couldn't open the DB anymore, due to the malformed schema error. Thanks again Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Malformed database schema with SQLite version > 3.5.x
...oopss.. I supposed it was a fault of mine. Thanks for the support and the help. Just two points: 1. the "PRAGMA writable_schema=ON" is not described in the "official" documentation for the PRAGMA syntax 2. does this mean that if I create an invalid view in the database, the entire database file becomes unreadable because of the "schema error"? I know I can't create an invalid view, because SQLite refuses to create it, but this seems a problem to me... could SQLite just open the database, and complain only on the invalid views (i.e. for instance when I open the view to query the data in it)? Thanks again Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Malformed database schema with SQLite version > 3.5.x
Yes, of course I can send you the DB: the file is under 1MB, about 100K if compressed via .zip Can I send it to you via e-mail? Thanks very much for the support On Tue, Mar 18, 2008 at 1:10 PM, <[EMAIL PROTECTED]> wrote: > MarcoN <[EMAIL PROTECTED]> wrote: > > I actually don't know how to export it, because "SQLite Database > browser" > > (that is able to open the database and execute the query) has no way to > > export it; SQLiteSpy will not open the database because it is compiled > with > > a new SQLIte library version > > Maybe I can try to find an older version of SQLiteSpy on my archives, > but I > > need more time for this... > > > > Can you send me the entire database file? How big is it? > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Malformed database schema with SQLite version > 3.5.x
I actually don't know how to export it, because "SQLite Database browser" (that is able to open the database and execute the query) has no way to export it; SQLiteSpy will not open the database because it is compiled with a new SQLIte library version Maybe I can try to find an older version of SQLiteSpy on my archives, but I need more time for this... Thanks for the reply ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Malformed database schema with SQLite version > 3.5.x
Hello, everybody. I have the following problem: I have an old project that uses a database created with an older SQLite library version. Now, since I updated SQLite to 3.5.5, I can't use the database anymore, because any query on the database tables returns: SQLite error 11 - Malformed database schema - near ")": syntax error The strange point is that I downloaded "SQLite Database Browser" from sourceforge, and I can actually open the database with this tool. In the help, it is saying that "SQLite Database Browser" is using version 3.3.5 of the database engine. With this tool, I can browse the data in any table, and a "pragma integrity_check" returns "ok". Any idea / help on this would be greatly appreciated. Thanks and kind regards Marco. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users