Questions tagged [sqlite]
Questions about the database program sqlite and also those programs that use sqlite databases.
88
questions
0
votes
0
answers
77
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 ...
- 1
-1
votes
1
answer
158
views
how to export db sql database to microsoft access database mdb?
i need to export a database in "db" format to access database "mdb" in Ubuntu
db browser for sql lite don't have the option to export to mdb - it just have the option to export to ...
- 1
0
votes
0
answers
59
views
Updating SQLite kills PHP
SUMMARY: I updated the SQLite on my Ubuntu dedicated server, but now I get an Internal Server Error when trying to run any PHP script (even "Hello World").
DETAILS: I rent a "Fully ...
0
votes
1
answer
116
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 ...
- 1,067
0
votes
3
answers
347
views
zdb.Connect: zdb requires SQLite 3.35.0 or newer
I'm trying to install goatcounter on Ubuntu 20.04.
There's no help at Github goatcounter issues https://github.com/arp242/goatcounter/issues
I'm getting the error "zdb.Connect: zdb requires ...
- 55
0
votes
0
answers
247
views
Sqlite is a read only database error
I want to run manic time server on my Ubuntu server but when I run manic time I get this error how can I solve this?
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to ...
- 1
0
votes
0
answers
437
views
Is it possible to rebuild Python3.8 installed by "apt install"?
I am facing module missing issue.
https://stackoverflow.com/questions/43993890/modulenotfounderror-no-module-named-sqlite3
After some survey, the only way to fix it (as far as I know) is "install ...
- 101
2
votes
0
answers
209
views
E: Sub-process /usr/bin/dpkg returned an error code (1) (When installing sqlite on a raspberry pi running ubuntu 18.04)
I am trying to install sqlite onto the raspberry pi I have been using. The following error code appears and any attempts to fix it have failed so far. I have tried reinstalling python3.6, purging the ...
- 21
1
vote
1
answer
4k
views
How can I start SQLiteStudio on Ubuntu?
I've seen the other threads on installing .tar.xy files, but SQLite Studio doesn't come with an installer. From the website - "All files are portable packages (no installer, just download, ...
0
votes
0
answers
271
views
sqliteman no longer available?
Just upgraded to Kubuntu 20.04. Been putting it off for ages.
It appears my favorite sqlite3 front-end won't install anymore? Any way around this? I use it all the time.
2
votes
0
answers
115
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 ...
- 21
1
vote
0
answers
36
views
Desktop freeze when using the desktop as destination path for a sqlite database (Ubuntu 20.04)
i wrote a little php testscript. The script insert 10000 numbers into a sqlite database. (I know, it is stupid and senseless to do 10000 insert statements in a loop.) But, when i using the home-...
- 11
0
votes
1
answer
132
views
Where is the database for feedreader?
It's implied:
https://code.launchpad.net/~eviltwin1/feedreader/sqlite
that feedreader uses sqlite or that it can be configured to do so.
I looked in the .config folder, but didn't see anything ...
- 1,064
0
votes
1
answer
232
views
Should I always use the terminal for a portable program?
I got the portable version of SQLite Studio from the website https://sqlitestudio.pl/.
I am a new ubuntu user and wonder. Should I always go to the file location and run the executable file to launch ...
- 3
0
votes
2
answers
4k
views
Problem with installing sqlite browser
Unfortunately I am unable to install sqlite browser. The issue that pops up is :"Unable to install sqlite browser: no snap revision on specified channel".
Can anyone help me with proceeding?
Cheers,
...
- 1
0
votes
0
answers
430
views
Thunderbird: How to recover email passwords if master-password is known?
I forgot one of my email passwords. And it's still saved in Thunderbird that ran on Kubuntu. But now my Kubuntu is broken, and I cannot open thunderbird's GUI. The only thing I know is username and ...
- 161
1
vote
0
answers
43
views
How to get Sqlite with PHPBB to work with apache2
I was wondering if anyone knew the steps/modules I needed in order for PHPBB to work with sqlite?
I've got mysql working, but I want to intigrate it with another piece of software that uses only ...
8
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 ...
- 181
0
votes
1
answer
674
views
How to install specific(older) version of sqlite
I want to install a previous version of SQLite(<=3.26.0).
And so far I am not able to find a way to do so in ubuntu.
As my current version is causing me bugs with a Django project.
- 85
1
vote
0
answers
2k
views
Ubuntu 18.04, PHP 5.3 installing
I have on my server Ubuntu 18.04 LTS 64bit with Plesk the PHP 5.3 with the instructions Can I install PHP 5.3.5 on Ubuntu Server 18.04 LTS? Installed
So far, he has carried out the installation ...
0
votes
1
answer
1k
views
"Error: unable to open database" when creating sqlite3 database in terminal
The other questions I've seen deal with this have to do with creating databses through Django or some other Python framework. I am simply trying to create a database with $sqlite3 database.db. It ...
- 295
0
votes
1
answer
290
views
db browser sqlite on 16.04
I recently upgraded from ubuntu 14.04 to 16.04.
And found db browser for sqlite to be version 3.7.0
While it was 3.9.99 with 14.04
(and current version is 3.10.1)
Any reason it was switched back to ...
- 31
3
votes
1
answer
196
views
Why is SQLite compiled with the OMIT_LOOKASIDE option in Ubuntu 18.04?
I am working on a project using SQLite and I need an option enabled that is not enabled in the version installed on my Ubuntu 18.04.1 box. No big deal - I can easily grab the source and build my own ...
- 133
2
votes
1
answer
2k
views
How to install SQLite backend for GnuCash on Ubuntu 18.04?
I was using GnuCash without problem on Ubuntu 16.04. Now I am not able to open GnuCash file after switching to 18.04. It give this message:
No suitable backend was found for...
If I remember ...
- 505
0
votes
2
answers
976
views
How to upload sqlite3 database to webserver? [closed]
I am very new to this. There is tuptime.db file which has records of uptime in my computer(local server). How can I upload it to web server and show the database content in a website. I want something ...
- 55
2
votes
2
answers
10k
views
How to open and read SQLite files
I am trying to recover something from Mozilla Firefox history, and grep returns lots of binary files, I think they come from sqlite content. How can I view them in human-readable form, as text? At the ...
- 191
1
vote
0
answers
616
views
Undefined symbol error
I'm working on a base project by someone else and I'm kind of new to the Linux system.
I know how to use sqlite3 in Windows' Visual Studio, however in Linux it's not working.
I've come to the ...
- 11
1
vote
1
answer
2k
views
How to recover deleted SQLite database files?
How to recover deleted SQLite database files?
Using magicrescue tool with the following params simply extracts the SQL query files instead:
sudo magicrescue -r sqlite -d ~/output /dev/hdb1
- 978
0
votes
1
answer
730
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....
- 239
0
votes
1
answer
1k
views
sqlite database locking
I would like to know about the locking method in sqlite. I am using some python scripts using sqlalchemy to write to sqlite db. There are lot of scripts writing to the db simultaneously and I am ...
- 151
-1
votes
1
answer
73
views
PHP warning files
I installed php 5.6 in ubuntu 16.04 and I installed package sqlite but now I have this problem
-3
votes
1
answer
90
views
Where to find 'libodb-sqlite' package for 14.04? [closed]
I am a user of Ubuntu 14.04 and need to install the package libodb-sqlite. However, this is not yet available for my version of Ubuntu. I have seen if for the later Ubuntu version 16.04. What shall I ...
- 51
2
votes
1
answer
2k
views
"Unmet dependencies" when installing SQLite driver in PHP7 on 16.04
This is a bit of a weird one. When I run sudo apt-get install php7.0-sqlite3 I get told that
Some packages could not be installed. This may mean that you have
requested an impossible situation or if ...
- 123
0
votes
0
answers
103
views
Background process no longer has access to .db file after I log out
I have a java application which I start with...
nohup java -cp MyServer.jar > log.txt 2> errors.txt < /dev/null &
The application is just a web-service that provides a few methods to ...
- 899
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?
- 4,467
2
votes
2
answers
5k
views
SQLite error after COTURN installation on Ubuntu Server 16.04.1
I'm Installing COTURN on Ubuntu Server 16.04.1 according instructions from here.
All steps done well but when trying to run turnserver this error happens:
Error retrieving SQLite DB information: file ...
- 1,262
41
votes
1
answer
78k
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 ...
user364819
0
votes
1
answer
233
views
Open SQL Light DB from Unity
I have installed sqlitebrowser to browse database. But when I try to open db from Unity I have only one option Open with gedit
When I choose open With Other Application... I cant find sqlitebrowser. ...
- 4,467
1
vote
0
answers
279
views
Sqlite, DB clients & BLOB's: Practical DB Use
I'm looking for a client that helps me to make practical use of a DB. I'm looking at SQLite since it's simple, embedded (stored in a file rather than accessed via a server) and has a shell interface ...
- 450
2
votes
1
answer
146
views
How can I use sqlite3 in my Ubuntu Phone app? (C++ backend)
I want to create an app, which has a C++ backend and uses sqlite3.
I can connect to an Database in memory using the following code:m_db = QSqlDatabase::addDatabase("QSQLITE"); m_db.setDatabaseName(":...
- 173
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 ...
user390136
0
votes
1
answer
3k
views
running sqlite from php5-sqlite install
I have installed php5 and sqlite3 by using:
sudo apt-get install -y php5 php5-sqlite unzip
But when I run sqlite (or sqlite3) in the terminal, it says that I need to install it using apt-get.
I ...
- 165
0
votes
1
answer
376
views
How to identify programically in QML app, where is located my sqlite database file
I have QML application which use as well C++ .
From C++ I need to connect to DB ( sqlite ) . For this I need to know the exact name and location of the database file . How to identify it ?
Or how to ...
- 2,021
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
709
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
8k
views
"No module named 'pysqlite2'" Error
I am trying to run a server, but I get this error:
$ python manage.py runserver
Traceback (most recent call last):
File "/home/user/Demo/lib/python3.4/site-packages/django/db/backends/sqlite3/base....
- 177
0
votes
1
answer
2k
views
How can I change the mode of Sqlite Database?
I want to add some record in my database it is read_only by default, how I can change its mode to add the record.
I want some linux command, I was trying gfix but it failed to execute.
- 393
-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
2k
views
sqlite make test fails because of "tcl.h not found" or "undefined reference to Tcl_Free"
I have obtained the sqlite source code with:
sudo apt-get install fossil
mkdir sqlite
cd sqlite
fossil clone http://www.sqlite.org/cgi/src/doc/trunk a
fossil open a
rm a
and compiled it with the ...
13
votes
5
answers
17k
views
Which apps read/write an SQLite 3 database in Ubuntu?
Have an app on another device which exports an SQLite v3 database. I wish to read and alter the content of that .db file. Tried Libre Office Base, no joy. Which apps will read that .db file, and edit ...
- 16.9k