Pyscripter: Error: attempt to write a read-only database

Questions about WAPT Packaging / Requests and help regarding Wapt packages.
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Locked
seb b
Messages: 23
Registration: Oct 26, 2017 - 3:12 p.m.

July 25, 2018 - 08:43

Hello everyone.

I have been experiencing a problem in my development environment for some time now.
When the PC on which I develop my "home" packages reboots while a package is open in pyscripter (and saved), it is impossible to launch the execution configurations afterwards, I get the message in the title, namely "OperationalError: attempt to write a readonly database.

That takes me back to the next line:

Code: Select all

self.db.execute('insert or replace into wap_params(name,value,create_date) values(?,?,?), (name, value, datetime2isodate()))
from common.py (line 1087)

How can I reset the permissions on this database? Without having to recreate my package from scratch, because that's the only way I've found so far.

So far I have tested without success:
  • restarting the workstation
  • relaunch of the wapt service
  • reinstalling the workstation
  • reset the permissions on the package folder
If anyone has an idea, I'm all ears, because having to recreate it for each test on multi-gigabyte packets isn't very practical ;)

Thank you and have a good day.
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

July 25, 2018 - 09:44

https://www.wapt.fr/fr/doc/Frequent-pro ... pyscripter

You can also check in the properties of pyscripter that it should always be launched as administrator.
seb b
Messages: 23
Registration: Oct 26, 2017 - 3:12 p.m.

July 25, 2018 - 11:25

So cool! Thanks!

Just a quick suggestion: if the error message text could be searchable, that would be awesome.
seb b
Messages: 23
Registration: Oct 26, 2017 - 3:12 p.m.

July 25, 2018 - 11:30

I can confirm, it works.

Thank you!
Locked