Comment by curiousmindz

5 years 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.

5 comments

curiousmindz

Reply
6gvONxR4sf7o  5 years ago

I 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.

bollockitis  5 years ago

That’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  5 years ago

    The 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

    • pjscott  5 years ago

      You 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  5 years ago

    Recentish versions of file can show you the version:

        $ file example.db
    example.db: SQLite 3.x database, last written using SQLite version 3007017