Questions tagged [sqlite3]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
45 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 ...
user892837's user avatar
3 votes
1 answer
83 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: ...
IlVin's user avatar
  • 31
1 vote
1 answer
785 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. ...
Dennis 's user avatar
  • 174
0 votes
0 answers
132 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 ...
PenMonk's user avatar
0 votes
0 answers
139 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'; ...
147pm's user avatar
  • 2,155
0 votes
1 answer
203 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 ...
MDeBusk's user avatar
  • 1,145
0 votes
0 answers
50 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,...)
Chris P's user avatar
  • 197
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 ...
hra1234's user avatar
  • 101
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/...
Huan's user avatar
  • 1
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 ...
MajorTom's user avatar
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 ...
xpt's user avatar
  • 1,035
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 ...
pkiller162's user avatar
0 votes
0 answers
774 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 '...
spiralcules's user avatar
0 votes
1 answer
214 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.
magicgeorge's user avatar
2 votes
2 answers
180 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. ...
Sruly's user avatar
  • 133
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... ...
Mittenchops's user avatar
  • 1,620
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/...
Lorena Malpica's user avatar
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 ...
Eduardo Flores's user avatar
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....
nephewtom's user avatar
  • 239
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 ...
Grigory Ilizirov's user avatar
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/...
GAVD's user avatar
  • 101
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?
vico's user avatar
  • 4,523
41 votes
1 answer
84k 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 ...
user avatar
0 votes
1 answer
71 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 ...
John Smith's user avatar
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 ...
senaps's user avatar
  • 493
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 ...
user avatar
8 votes
4 answers
20k 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 ...
J.D. Corbin's user avatar
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.
Donyi Anthoney Pegu's user avatar
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 (...
letsdisappear's user avatar
0 votes
1 answer
721 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'...
user368225's user avatar
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 ...
Britto's user avatar
  • 149
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
Britto's user avatar
  • 149
-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 ...
Muhammed Jibran's user avatar
2 votes
1 answer
752 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 ...
user3636470's user avatar
1 vote
1 answer
990 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. ...
geoB's user avatar
  • 149
0 votes
1 answer
690 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(...
geoB's user avatar
  • 149
0 votes
1 answer
371 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-...
Hannu's user avatar
  • 5,271