Thread: Troubleshooting X-ray functionality for "War and Peace"
View Single Post
Old 07-24-2018, 08:39 PM   #50
j.p.s
Grand Sorcerer
j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.
 
Posts: 5,813
Karma: 103362673
Join Date: Apr 2011
Device: pb360
Quote:
Originally Posted by Ephemerality View Post
How are you creating the new db? Are you including
Code:
PRAGMA user_version = 1;
in there somewhere? You can check, in SQLiteBrowser at least, under the Edit Pragmas section. If it's not 1, set it to 1, save, then see if it will load.
TL;DR
That worked. Thanks!

The way I made it was to run sqlite3 on the original db, then set output file to Wap.sql, did a .dump then did
sqlite3 XRAY.entities.B00JCDK5ME.asc < Wap.sql
in a directory that had no file named XRAY.entities.B00JCDK5ME.asc
As you suspected, user_version = 0

My sqlitebrowser at work has an Edit Pragmas tab, but I have no XRAY file there.

At home, sqlitebrowser doesn't have an Edit Pragmas tab so I just used sqlite3
j.p.s is offline   Reply With Quote