Questions about the database program sqlite and also those programs that use sqlite databases.
0
votes
1answer
32 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 ...
2
votes
0answers
202 views
SQLite 3.7.15 cross compile for ARM
I am using SQLite 3 for Database management in my ARM9 based microprocessor.
I want to cross compile the latest version of the SQLite 3 for my project in Linux (Ubuntu 10.04). I am using the ...
0
votes
1answer
111 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 ...
4
votes
1answer
383 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 ...
1
vote
0answers
40 views
SQLite encryption what package
I have an application witch uses an encrypted sqllite db with AES 128.I receive the error : File is encrypted or not a database.
It is an ok database because on windows I can read it using the same ...
5
votes
3answers
457 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
...
0
votes
1answer
133 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 ...
1
vote
1answer
342 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
0
votes
1answer
793 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 ...
1
vote
1answer
146 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
...
0
votes
1answer
373 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 ...
2
votes
1answer
108 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? ...
2
votes
3answers
4k 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 ...
2
votes
2answers
58 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 ...
1
vote
1answer
882 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 ...
2
votes
2answers
272 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 ...
0
votes
2answers
5k 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: ...
0
votes
1answer
248 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 ...
0
votes
2answers
384 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
vote
1answer
528 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 ...
4
votes
3answers
2k 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
**
...
0
votes
1answer
372 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 ...
1
vote
1answer
779 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 ...
2
votes
2answers
117 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 ...
3
votes
2answers
470 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 ...
7
votes
3answers
3k 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?
