4 ms·
If you use certain new features of SQLite, the database file gets "upgraded". At that time, you must use a version of SQLite that understands these new features
by curiousmindz 6y ago
If you use certain new features of SQLite, the database file gets "upgraded". At that time, you must use a version of SQLite that understands these new features.
So, the other computer you used was probably running an older version of SQLite. Just update it to make it work.
- bollockitis 6y agoThat’s a good catch. I’d there any way to tell which version of SQLite created the file? Aside from trial and error, I mean?
- lbutler 6y agoThe version is stored in byte 96 of the header of the sqlite file[1]. I haven't looked but there will be some sqlite command to query it and I'm sure some viewer tools will display it as well. [1] https://www.sqlite.org/fileformat.html https://www.sqlite.org/fileformat.html
- pjscott 6y agoYou can print the version with this magical incantation: $ python -c 'import sys, struct; print(struct.unpack(">I", open(sys.argv[1], "rb").read()[96:100])[0])' foo.db
- banana_giraffe 6y agoRecentish versions of file can show you the version: $ file example.db example.db: SQLite 3.x database, last written using SQLite version 3007017
- 6gvONxR4sf7o 6y agoI think the computer it worked on was one with an older version of SQLite rather than a newer one, but I’m not certain. It was a while ago. I thought I’d checked for the upgrade issue, but my memory is shit.