[PyCharm CE 2017.1.2] DB Navigator - Script execution error
Hi!
I use PyCharm with the DB Navigator plugin and it works fine with my SQLite databases.
But there is one problem:
When I try to execute a simple SQL script via "Execute Statement" everything works fine.
But when I try to execute via "Execute SQL script" I get the following error message:
Error executing SQL script "/home/juergen/PycharmProjects/foobarbaz/vornamen.sql".
Details: Cannot run program "sqlite3 "/home/juergen/Dokumente/Datenbank/Vornamen/vn.db" < "/tmp/DBN2565824973113411985.sql"": error=2, No such file or directory
The SQLite binary is available via PATH environment variable and the database is in the mentioned place, but it seems, that there is no DBN2565824973113411985.sql inside the tmp directory.
How to fix this problem?
Greetings from germany
Jürgen
Please sign in to leave a comment.
Hi Jürgen! Unfortunately DB Navigator is a 3rd party plugin and we can't provide any support on it. You need to contact plugin vendor, he has an issue tracker and I found a similar ticket to you problem: Execute SQL Script: No such file or directory.
Hi Pavel!
Thanks a lot für your answer. I was not aware, that the DB Navigator is a third party plugin, because of its well integration into PyCharm.
I've left a comment to the issue in the issue tracker.
Greetings
Jürgen