Hi Donald, many thanks for your response. I used the command: "pragma integrity_check" with db opened with version 3.9.1.
The result is: Error: database disk image is malformed Am I missing something or this error is more silent that the original fault? I am planning to make a patch of the conversion utility. But it uses System.Data.Sqlite library not the sqlite3.dll, so I think it is a little more complicated. Thanks in advance, Andi On Sat, Oct 31, 2015 at 6:17 PM, Donald Griggs <dfgriggs at gmail.com> wrote: > Hi, Andi, > > I imagine this doesn't fully solve your problem, but I noted that: > > 1. Your example database does NOTt pass > PRAGMA INTEGRITY_CHECK; > When using 3.9.1 command line utility. > > 2. Using 3.8.10.2, it DOES pass. > > 3. I can use ".dump" under 3.8.10.2, to produce a text sql file, then, > under 3.9.1, create a new db file and use ".read" to load it. The result > passes the integrity check and has non-null values for the ID_KCOMPONENT > column of the kcomponent table. > > 4. My guess is that the conversion utility fails (unfortunately silently) > for new versions of sqlite. If you agree, I imagine you'll want to contact > MfHernandez (the kind provider of the utility) and see if either a fix -- > or at minimum a warning on the download site -- can be arranged. Perhaps > you can submit a patch. > > 5. I note that the utility is dated 2012, is labeled "beta" and the author > wrote: > "I do it just for learning purposes and for fun, of course :)" > > Maybe this helps, > Donald G. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
