SQLite suddenly a readonly database?

  1. 2 years ago

    Tim S

    18 Jun 2017 Pre-Release Testers, Xojo Pro Phoenix Arizona USA

    Hello all,

    In a web app, suddenly I am getting an error while trying to update a SQLIte database - "clsdefaults_controller.Update attempt to write a readonly database, SQL Err". The target is Linux ARM (Raspberry Pi). The permissions for the folder and the database is 0775.

    I have not had this problem before, and would appreciate any direction to find and fix the cause.

    Thank you!
    Tim

    Hi Ralph.
    Sorry for the late reply - Yes I did find the problem, and should have posted it but got caught up in other things. The issue WAS permissions, specifically the owner of the file. Once changed, it all worked as it did. The problem was caused by loading a new database file, instead of overwriting an existing.

    Hope that helps you!
    Tim

  2. Ralph A

    20 Jun 2017 Santa Monica, California

    did you solve this problem?

  3. Tim S

    21 Jun 2017 Pre-Release Testers, Xojo Pro Answer Phoenix Arizona USA

    Hi Ralph.
    Sorry for the late reply - Yes I did find the problem, and should have posted it but got caught up in other things. The issue WAS permissions, specifically the owner of the file. Once changed, it all worked as it did. The problem was caused by loading a new database file, instead of overwriting an existing.

    Hope that helps you!
    Tim

  4. 8 months ago

    John S

    16 Nov 2018 Pre-Release Testers, Xojo Pro

    I'm trying to change the owner of the database from 0 to 1000 but in FTP but am getting don't have permission error

    ideas?

  5. Greg O

    17 Nov 2018 Xojo Inc

    0 would indicate that it’s owned by root, and only a root user can change it to something else.

or Sign Up to reply!