Questions tagged [sqlite3]
The sqlite3 tag has no usage guidance.
37
questions
0
votes
0
answers
47
views
probable bug with dbbrowser
Since recent update, i had to fix the batch loading code to load data into sqlite3 (V3.44)
adding :
PRAGMA trusted_schema=1;
to solve an error message :
sqlite> .import Enseignants.csv ...
3
votes
1
answer
97
views
Installing DBSqlite Browser on Ubuntu
I tried to install DBSqlite Browser for Ubuntu and Derivatives.
After installation, I enter the command to open Ubuntu in the terminal: "sqlitebrowser" and the following crashes:
qt.qpa.xcb: ...
1
vote
1
answer
1k
views
Ubuntu 20.04 has no installation candidate for php8.1-sqlite
Apparently package php8.1 is available for Ubuntu 22.04 but not available for 20.04. php7.4-sqlite is, however, available for 20.04.
In particular I'd like to use PDO with sqlite on PHP8.1 on 20.04. ...
0
votes
0
answers
139
views
Error when transferring Plex watch history from Windows 10 to Ubuntu 22.04
I have been running a Plex server on a Windows PC, and want to move over to an Ubuntu PC.
I'm trying to do this by just fresh installing Plex and moving over the watch history.
I followed the ...
0
votes
0
answers
151
views
phpliteadmin won't accept my directory
I have a system-wide apt install of phpliteadmin 1.9.8.2 on Ubuntu 22.10. In my /etc/phpliteadmin.config.php file I've tried to give a directory
$directory = '/home/homedir/Dropbox/org/databases';
...
0
votes
1
answer
222
views
Notification when a record in an SQLITE database gets too low
I'd like to be notified when inventory in an sqlite database drops below a certain level.
The amount drops by a set number every day, and I update the database via a cron job in the evening. The cron ...
0
votes
0
answers
58
views
Sqlite3 editor - viewer
is there any (free) program for sqlite3 viewer.
I used db browser for sqlite3 but it doesn't have all available sqlite3 data types (datetime,varchar,...)
0
votes
0
answers
1k
views
Installing libsqlite3-0 and libsqlite3-dev from sources on Ubuntu 18.04
So I have Ubuntu 18.04 under which the newest version of sqlite3 (and libsqlite3-dev and libsqlite3-0) that can be installed with apt is 3.22.0. And I want to install v3.25.0 or higher because it ...
0
votes
1
answer
2k
views
sqlite3_error in Ubuntu20.04
I met a strange problem when using Ubuntu 20.04 LTS. When I type any non-meaning word in the command line, such as a letter A, it returns something related to python3.8 with "ImportError: /usr/...
2
votes
0
answers
119
views
Thunderbird wont start. Crash reporter says sqlite version error
my Dad cant get thunderbird to start. This started after he got tired of the nag screens and updated ubuntu.
He is now running ubuntu 20.04.1 and thunderbird 68.10.0
Whenever he types thunderbird at ...
2
votes
1
answer
2k
views
Using Json1 Extension with sqlite3
The docs says, that The json1 extension is a loadable extension for sqlite3, and the loadable extensions need to be compiled as shared libraries (source).
I searched a lot and I don't know how to ...
9
votes
4
answers
5k
views
Is it possible to install SQLite 3.24+ on Ubuntu 18.04?
I am trying to update my SQLite version to 3.24 or above so that a Python app can make use of the new "UPSERT" queries. I have been trying for a few hours to do this with little success; it refuses to ...
0
votes
0
answers
779
views
error when compiling sqlite
I received this error when compiling sqlite:
Makefile:743: recipe for target 'alter.lo' failed make[4]: *
[alter.lo] Error 1 CMakeFiles/external_sqlite.dir/build.make:113:
recipe for target
'...
0
votes
1
answer
218
views
problem installing sqlite3 using apt-get install
Installation hangs at 4% completion due to a prompt requesting acceptance of Oracle's license agreement. No way to respond interactively.
2
votes
2
answers
185
views
How do I invoke the sqlite3-doc package
I installed the package but can't figure out how to use/start it. What I'm am looking for is a interactive help/docs for sqlite3 I assumed that what this package does but I don't know how to start it.
...
1
vote
1
answer
1k
views
Installing qgis in ubuntu 18.04 error with sqlite tables, can no longer use apt
I'm getting the following error:
$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree
Reading state information... ...
5
votes
2
answers
3k
views
nautilus: symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/libtracker-data.so.0: undefined symbol: sqlite3_bind_pointer
I upgraded to Ubuntu 18.04 and I can't get Nautilus to work. I get the following error when I launch it from the command line:
nautilus: symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/...
1
vote
2
answers
1k
views
I messed up ocamlfuse by using sudo command "Error: Sqlite3 error: READONLY"
I started using ocamlfuse to access google drive with Nautilus and it was functioning perfectly fine. The thing is, at some point I used, by accident, the sudo command, I'm not shure if it was to run ...
0
votes
1
answer
737
views
Which sqlite database uses new Skype for Linux?
Skype for Linux version 4.3 stores data on ~/.Skype/<user>/main.db.
I installed recently a new version 5.5.0.1 that changes completely its GUI.
Note: I also tested Skype Insider version 8.x.x....
4
votes
1
answer
26k
views
Install Ubuntu package, php7.0-sqlite3 missing
Ubuntu with php7
Error occurs when trying to use SQLite3 from php:
PHP Fatal error: Class 'SQLite3' not found in /var/www/html/index.php on line 1
I've tried to install php7.0-sqlite3 :
$ sudo ...
0
votes
0
answers
4k
views
Error package 'sqlite3>=3.7.11' not found
I clone a project from github and run cmake, but I get the message:
-- checking for module 'sqlite3>=3.7.11'
-- package 'sqlite3>=3.7.11' not found
CMake Error at /usr/share/cmake-2.8/Modules/...
2
votes
1
answer
4k
views
Install command line tool sqlite3
Trying to install sqlite3 command line tool with :
sudo apt-get install sqlite3 libsqlite3-dev
But I still can't run ./sqlite3 - nu souch file
How to solve this problem?
41
votes
1
answer
85k
views
How to properly view a .sqlite file using sqlite?
I have installed the program sqlite in order to view file types with that extension, however even after reading its help documentation and its manpage, I am still confused about how I get it to show ...
0
votes
1
answer
73
views
How do I re-enter a sqlite database that I already created?
I am using sqlite3 and created a new database in the terminal by using:
sqlite3 test.db
I then created some tables in this database but then I closed sqlite3. How can I re enter my test.db? Do I ...
35
votes
1
answer
64k
views
How to Exit sqlite3 in terminal
I have ran sqlite3 from terminal but have problem exiting it.
this is how i have ran it:
sqlite3 database.db
i have tried CTRL+C but it wont exit, i have tried ESC, close(), exit() and it doesn't ...
5
votes
1
answer
7k
views
How do I install sqlite3 ODBC drivers with unixODBC?
According to the unixODBC drivers page (straight out of the 90s), I should download the SQLite3 drivers from: http://www.ch-werner.de/sqliteodbc
The instructions for building sqliteodbc from the ...
8
votes
4
answers
21k
views
Can SQLite3 be upgraded on Ubuntu?
I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool ...
0
votes
1
answer
2k
views
Unable to acess SQLite database in Ubuntu using PHP under Apache
I am having trouble using SQLite3 with PHP in Ubuntu but it works well with Windows. In Ubuntu I have installed the php-sqlite package and the SQLite database is made using SQLite3.
0
votes
2
answers
8k
views
Django and SQLite3 doesn't work
My problem is following, I'm starting with tutorial https://docs.djangoproject.com/en/1.8/intro/tutorial01/ , and after I type in terminal python manage.py runserver I'm getting an error:
Traceback (...
0
votes
1
answer
723
views
Was Installing Syncevolution, when I came across the following messages!
I was trying to build syncevoltion, and I came across the following error after ./configure
checking for SQLITE3... configure: error: Package requirements (sqlite3) were not met:
No package 'sqlite3'...
1
vote
1
answer
4k
views
SQLite >= 3.8.3 version on Ubuntu 14.04
Please, is there a simple way to install SQLite >= 3.8.3 on Ubuntu 14.04 LTS. By now, is impossible to do this via apt-get because only SQLite 3.8.2 it's available at the "Trusty" repositories.
I need ...
3
votes
1
answer
3k
views
SQLite 3.8.8 in Ubuntu 14.04 via apt-get
How to install the SQLite 3.8.8 in Ubuntu 14.04 via apt-get?
The default installation is for 3.8.2.
Thanks, Christian
-1
votes
2
answers
3k
views
class SQLite3 not found
After struggling through a lot of pages and answers i am still unable to use sqlite with php. i am using fresh install of Ubuntu, Apache 2, SQLite3 and Php5.
I am still getting class SQLite3 not ...
2
votes
1
answer
762
views
Not able to include sqlite3 in c program
I installed libsqlite3-dev from ubuntu software center and after the installation, i found the sqlite3.h file in usr/include folder. There was no error in including that header file, but i am not able ...
1
vote
1
answer
995
views
Custom compile sqlite as php so
In Compile sqlite with soundex feature I learned how to do a custom compile of sqlite. While this was a step towards my goal of using sqlite's soundex in a functional test, I find I'm not there yet. ...
0
votes
1
answer
695
views
Compile sqlite with soundex feature
In 14.04 LTS:
I'm trying to build a functional test of a Symfony application that uses the soundex() function in MySQL. The test environment uses sqlite, which by default does not compile its soundex(...
0
votes
1
answer
375
views
sqlite3 - humongous dependency list?
$ sudo apt-get install sqliteman* sqlite3*
gives me a display that includes this:
...
Recommended packages:
bacula-sd-mysql bacula-sd-tools cl-sql-backend ada-reference-manual
gdb-minimal php-...