Questions tagged [sqlite]
Questions about the database program sqlite and also those programs that use sqlite databases.
88
questions
0
votes
1
answer
279
views
Why is mysql run in server-client model?
From https://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run
Please make sure that you have installed the mysql-server, not the mysql-...
- 25.2k
2
votes
0
answers
264
views
Are Live Bookmarks in Places.sqlite?
In reading about Places.sqlite, it's not clear to me whether or not that includes Live Bookmarks.
How can I access, either through sqlite or by other means, the Live Bookmarks? I've installed the ...
- 4,551
8
votes
1
answer
26k
views
How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?
I'm using Ubuntu 12.04 LTS and Skype 4.3 on my machine. I've taken a file named main.db from the location on my machine ~/.Skype/SKYPEUSERNAME/
Now I want to see the chat history from that file with ...
- 1,787
2
votes
1
answer
5k
views
How to install sqlite SQLite 3.7.11 on Ubuntu 12.04
According to this question, to get code my code work on this 12.04 machine I need to upgrade the version of SQLite to 3.7.11. However, on Ubuntu 12.04 the installed version of sqlite is
> sqlite3 -...
- 2,363
0
votes
1
answer
621
views
sqlite3 on precise pangolin: installed but not found?
vagrant@precise64:~$ sudo apt-get install sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libsqlite3-...
- 523
1
vote
1
answer
315
views
Recover a file which has lost 5 minutes ago
Is it possible to recover a file which removed 5 minutes ago? I was working with sqliteman and suddenly it saved an empty database on my database file.
It would be greatly appreciated if you suggest ...
- 165
5
votes
3
answers
10k
views
SQLite header and source version mismatch
I had the Ubuntu repositories of SQLite3 with v3.7.17. But it doesn't have the .save command as newer versions.
To update I did:
sudo apt-get purge sqlite3
Download SQLite 3.8.4.3
Install it with ./...
- 18.9k
1
vote
1
answer
7k
views
svn SQLite compiled for 3.7.17, but running with 3.6.1
Trying to update a svn working copy using
svn update .
I get the following error:
svn: E200029: Couldn't perform atomic initialization
svn: E200030: SQLite compiled for 3.7.17, but running with 3.6....
- 849
0
votes
1
answer
616
views
Shotwell photos lose edits when files are missing
I have my photos stored on my desktop computer, using Shotwell. I recently went on an extended holiday and wanted to take my laptop to edit and organise photos with Shotwell, so I copied all the ...
- 2,986
3
votes
0
answers
442
views
Issue Backporting SQLite 3.8.1 to Ubuntu Precise from Trusty
I'm pretty new to all of the packaging of Ubuntu applications and what not so this may not be the correct place to ask this question or there may be a more appropriate place to re-ask this question. I'...
- 141
2
votes
2
answers
4k
views
phpliteadmin cant find sqlite3
I installed sqlite3 using sudo apt-get install sqlite3. I also installed phpliteadmin in the var/www folder. When I go on phpliteadmin, it says it cant find sqlite3 and sqlite3database. How do I fix ...
- 193
4
votes
2
answers
9k
views
How to use a SQLite database from QML? [duplicate]
I have not been able to find a working example in QT creator or gallery to use SQLite offline storage API for an Ubuntu touch application.
- 41
14
votes
3
answers
56k
views
sqlite installation
I'm installing sqlite like this SQLite - Installation
I get this error, anyone know what to do?
anonymous@Anonymous:~/sqlite-autoconf-3080001$ make install
make[1]: Entering directory `/home/...
- 141
2
votes
1
answer
5k
views
How install sqlite3 from scratch
I'm trying to install sqlite3 in Ubuntu 12.04. I tried sudo apt-get install sqlite3 but I get the following error:
tanvir@TanvirPC:~$ 'sqlite3' is currently not installed. You can install it by
...
- 219
6
votes
1
answer
60k
views
AttributeError: 'tuple' object has no attribute 'translate'
I am developing this program and for some reason, I keep getting this error. Is this an Ubuntu caused error, or something in my code that it crashing my program?
I am accessing a database and trying ...
- 9,783
0
votes
1
answer
2k
views
sqlite3 timestamp (current_timestamp) one hour off
I run a small crawler on a virtual ubuntu server, initiated by crontab hourly. Datetime is inserted by defaulting the date filed to TIMESTAMP DEFAULT CURRENT_TIMESTAMP.
Table creation looks like ...
- 585
10
votes
1
answer
11k
views
Cannot install sqlite3
OS: Ubuntu 12.04 LTS
$sudo apt-get install libsqlite3-dev
The following packages have unmet dependencies: libsqlite3-dev : Depends: libsqlite3-0 (=3.7.9-2ubuntu1) but 3.7.9-2ubuntu1.1 is to be ...
- 213
5
votes
2
answers
6k
views
How to install SpatiaLite 3 on 12.04?
I'm having some problems to install SpatiaLite 3 on Ubuntu 12.04, those are the steps to I did:
1) sudo apt-get install libsqlite3-dev libgeos-dev
2) libspatialite-3.0.0-stable$ ./configure
Result:...
- 151
0
votes
1
answer
681
views
sqlite2 does not work in 11.10
I have configured Ubuntu 11.10 in my PC. I have installed php 5.3.6-13ubuntu3.8.
My problem is that after PC upgrade, sqlite2 is not supported in PHP. Also sqlite3 database is locked whenever I have ...
- 101
1
vote
1
answer
7k
views
Call to undefined function sqlite_open() in CLI mode
12.04 AMD 64
apt-get install sqlite php5-cli php5-sqlite
php -r '$x = sqlite_open();' PHP Fatal error: Call to undefined function sqlite_open() in Command line code on line 1
- 11
4
votes
1
answer
6k
views
Missing ODBCConfig for SQLite and LibreOffice Base
I have used OpenOffice Base as a front end for SQlite databases, in 10.04 linked via ODBC.
I am updating to 12.04, so I loaded LibreOffice Base, looks just like OObase. I have 12.04 on one drive and ...
- 41
2
votes
1
answer
3k
views
Where should I place my sqlite database for proper packaging?
I built my first application with quickly uses a sqlite database file. It contains all the settings of the program. While developing I simply put it into the root folder of the app.
quickly package
...
- 121
7
votes
1
answer
6k
views
SQLite binary file does not work on my Ubuntu,
I'm new to sqlite , I just got the binary of sqlite by using wget http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip, then extract sqlite3 from the zip file, it does not work, it's driving me ...
- 501
2
votes
1
answer
359
views
How to get the procedural interface back?
Setting up a new machine, I just discovered the procedural interface to SQLite3 seems to be gone:
PHP Fatal error: Call to undefined function sqlite3_open()
Is there any way to get that back again? ...
- 21
4
votes
3
answers
9k
views
SQLite stopped working after upgrade
As many of you did, I upgraded from Lucid to Precise this week and almost everything seems to work find.
everything except… SQLite, which was working well before but not anymore.
I checked ...
- 306
2
votes
2
answers
121
views
Need database selection advise
I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
- 305
1
vote
1
answer
3k
views
configuration of Eclipse (C++ version) for running SQLite?
I need to run C++ code via eclipse which has SQlite. I can run it via terminal with typing g++ test.cpp -lsqlite3 . but how can I run it via Eclipse? how should pur the command "-lsqlite3" in its ...
- 577
2
votes
2
answers
400
views
Error while installing rails
Following this tutorial here, to install ruby on rails on ubuntu 11.10 with sqlite3
when I run the following command
sudo gem install rails
I get the following error :
ERROR: Could not find a ...
- 145
2
votes
2
answers
23k
views
Get a SQLite3 db in LibreOffice (via ODBC). Using Ubuntu 11.04 (64bit)
I'm stuck with this. I had SQLite working with OpenOffice in the past. But since then i reinstalled my machine and so... Now I can't get it to work.
i pretty much followed this guide: http://...
- 638
0
votes
1
answer
368
views
Why do I get these strange errors when running PHP scripts?
I installed PHP and the SQLite extension using:
sudo apt-get install php5-cli php5-sqlite
However, each time PHP starts up, I get the message:
PHP Warning: PHP Startup: Unable to load dynamic ...
- 32.2k
0
votes
2
answers
1k
views
Accessing Sqlite3 via php not working?
my local web server on one machine running Ubuntu 11.04 works fine using php5 to access sqlite3 - however on a new machine running Ubuntu 11.10 the same code, same structure, does not work at all - ...
- 1
1
vote
2
answers
3k
views
How do I set SQLite data browser as the default application for .sqlite3 files?
When I try to open a .sqlite3 file, I get the following error:
There is no application installed for SQLite3 database files
When trying to select a default application, the SQLite database browser ...
- 295
5
votes
3
answers
7k
views
How can I restore a corrupted Shotwell db?
While I was importing photos from a SD card in Shotwell, my laptop has crashed (shutdown because of over-heating). Now, I can no longer launch Shotwell:
$ shotwell
**
ERROR:x86_64-linux-gnu/db/...
- 346
1
vote
1
answer
869
views
Is there a binary package for php5-sqlite3 with fts3 enabled?
I would like to have PHP with SQlite with FTS3 extension enabled, as noted in Manual:SQLite - MediaWiki.
I'm somewhat confused about FTS3 support in the default Ubuntu packages;
from Bug #229003 ...
- 3,056
10
votes
1
answer
18k
views
How to execute query to a DB from a terminal and store output to a file?
I want to access this DB and I use this to access the SQLite DB: sqlite3 .mozilla/firefox/profile_name/places.sqlite
The query that I want to execute to this DB and store the output in a text file is ...
- 22.2k
2
votes
2
answers
249
views
How do I finish the installation of a program from source?
I compiled sqlite3 from source code, version 3.6.16. I used --prefix=/usr/bin as my only compiling option.
The binaries compiled and installed correctly, but at the directory /usr/bin/sqlite3/bin. So ...
- 99
3
votes
2
answers
1k
views
sqlite-ruby gem problem
I am trying to get my ruby on rails up and running but i can't seem to install sqlite3-ruby gem . When i run it i get this error :
Fetching: sqlite-ruby-2.2.3.gem (100%)
Building native ...
- 133
10
votes
2
answers
10k
views
How can I install SQLite to be used with OpenOffice?
My GPS uses a SQLite database. I would like to access this data using OpenOffice to look at the relationship between data entries. Is there a way to install SQLite with OpenOffice?
- 3,932