Ubuntu :: Sqlite Query Syntax ?
Feb 27, 2010With this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
ADVERTISEMENT
General :: Sqlite Query To Retrieve Browser History?
May 24, 2010This query is giving "Unable to open data base" can anybody suggest what's wrong with this query.
sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite
General :: Rpm Spec File Conflicts Syntax Query - Not Keeping The Package Name
Mar 9, 2011I have inherited our Linux packaging and as the number of versions increase, the number of conflicts is starting to get a bit unmanageable. I believe the easiest way would have been to keep the package names the same and just change the release in the spec file but unfortunately I am past that as a lot of these packages are rolled out to our estate. (I am told there were reasons for not keeping the package name the same and incrementing the version/release)
Is it possible to wildcard conflicts so I don't need to keep adding as new versions are created. For example, instead of using all the conflicts below, have something along the lines of AAtest45* <= 1.4 & BBtest45* <= 1.4 Meaning that all I would need to do was change this to 1.5 at the next release (the packages below version matched the release in the spec file)
[Code]....
General :: Mysql Query With Unix Timestamp Error "check The Syntax Near The Between"
Jun 28, 2010Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
General :: Can't Open File/abcd/configFiles/vim/syntax/syntax.vim?
Mar 7, 2011When ever i open vim, i get the error that the following error: E484: Can't open file/abcd/configFiles/vim/syntax/syntax.vim There was a .vimrc file in my home folder that i have removed.
Still i keep getting the same error. Presently in my home folder there is no .gvimrc or .vimrc file.
But still i keep getting the same error. I am not too sure where this file is mentioned.
Background info: The SHELL has been changed from tcsh to bash Earlier i had created a .vimrc file in tcsh, i have removed the .vimrc in bash SHELL.
General :: SUSE 10 Syslog-ng Syntax - Bash: Syntax Error Near Unexpected Token "("
Apr 20, 2011I am a Novell (now defunct) CNE tring to learn Linux and am having a lot of trouble finding out where the WB 6-6 is wrong in the syntax for adding local4... the the syslog-ng config file. In the instructions there are discrepancies between commas and simi-comma, they are both in the statements in no particular order. there is no pattern to them. Here is what the book shows:
filter f_local4debug { level(debug) and facility(local4); };
When I try to input this in the Gnome terminal window to try and find out where it goes wrong I get the following: -bash: syntax error near unexpected token "(" If I can get the correct syntax I belive I can use the info to get past the rest of this portion of the lesson. I am desperate to learn Linux as the only jobs out there for a Novell CNE are migrations to MS, which really sucks, since MS really really sucks.
Fedora :: How To Install Sqlite-python
Nov 18, 2009I am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 Replies View RelatedFedora Servers :: Enabling Sqlite In 12?
Feb 4, 2010I'm having a bit of trouble with a web server running Fedora 12. Apache works fine, and serves up php content without a hitch. My problem is SQLite -- I thought that it was built into php5, but support is disabled in the repo version. phpinfo shows this as part of the configure command:
Code:
'--without-sqlite' ... '--disable-pdo' ... '--without-sqlite3'
The only solution I've read anywhere is "compile php from source," but I'd like to avoid that if possible, for ease of future upgrades. Is there a way to convince php to use sqlite despite its current state?
Fedora :: SQLite Browser - Binary Available Somewhere?
Jan 29, 2011Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedOpenSUSE :: Install Gnucash 2.4 In 11.4 To Use Sqlite?
Apr 18, 2011Based on Product highlights - openSUSE, it would appear that using sqlite3 in gnucash would be available. However, I do not have an option to save an existing book to the database format, nor is it available when creating a new book - only xml is available. Is there anything special that I need to do to enable the sqlite backend?
View 2 Replies View RelatedOpenSUSE :: Zimbra Cannot Find Sqlite?
Sep 13, 2011When I try to install Zimbra 7.1.2, the installation fails because it cannot find sqlite. I used strace and found that it uses "rpm -q sqlite" to find the package. But it fails-"package sqlite is not installed". Although I have sqlite installed:
Code:
#rpm -qa | grep sqlite
mono-data-sqlite-2.6.4-2.13.x86_64
[code]....
Software :: Connect To Sqlite Via Perl?
Apr 22, 2011I am trying to connect to sqlite via perl:
Code:
#! /usr/bin/perl
use LWP::Simple;
use XML::DOM;
use DBI;
[Code]....
Programming :: Execute SQLite Db Commands From C++?
Jun 10, 2010Anyone know how to execute SQLite db commands from C++?
View 1 Replies View RelatedUbuntu :: Synaptics Tomahawk: Depends: Libqt4-sql-sqlite But It Is Not Going To Be Installed?
Jun 10, 2011I get the error when trying to mark tomahawk for installation using synaptics. I googled the error but couldn't find anything on it. could some one help me figure out what's going on?
View 3 Replies View RelatedFedora Installation :: How To Install Php-sqlite Extension On F14
Apr 15, 2011How do I install php-sqlite extension on fedora 14.
View 5 Replies View RelatedProgramming :: Load Multiple Records Into SQLite?
Nov 19, 2008I am using SQLite as my database for some portable cross platform applications I am working on with REALBasic as my IDE. I have an old Sybase 8.0 database that I can access via Microsoft Access and thereby extract the data I need from each table.
Now I know I can create .csv files from each table and load them into SQLite using the import tool, but then I can't define the primary key and other field attributes. So the other option is to load each file via SQL.
Now with most SQL editors I can create multiple queries and they will run just fine. But I can't seem to do that with the SQLite interfaces. I can paste multiple queries but I can only run one at a time. And by that I mean I have to click run.
Ummm that's not acceptable since my biggest table contains over 600,000 records. I have the queries all written, that was easy using a simple interface I wrote in Access.
Code:
INSERT INTO tblMeters(recordId,meterId,meterName,meterSerNum,registerSerNum,mxuSerNum,meterType,manufacture,meterModel,readType,groupId,multiplier,rollover,vendorId,xfrmerCode,bldgCode,CATEGORY,energyType,unitOfMeasure,location,access,comments,dateInstalled,dateCalibrate,pipeSizeIn,pipeSizeOut,elecMeterSpecs)
[Code]...
So is there another method I can use? I can't seem to find anything relating to my particular question at the SQLite web site
Software :: Cross Compiling Sqlite On Arm9
May 28, 2010i am trying to compile too the sqlite for arm9 - mini2440.could you please tell me what was the steps you make? im read that book but im still having some trouble while i compile i have been trying to do the compilation.
View 3 Replies View RelatedGeneral :: Unable Command Line Autocomplete After Sqlite?
Jun 3, 2010Once upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now.
View 1 Replies View RelatedGeneral :: Delete Old Records From Firefox Sqlite Databases?
May 23, 2010I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies View RelatedSoftware :: Unable To Create An RPM That Will Install Python 2.7.1 Along With Sqlite 3.7.3?
Mar 8, 2011I want to be able to create an RPM that will install python 2.7.1 along with sqlite 3.7.3, MySQL-Python-1.2.3 on a CentOS 5.5 x86_64 host(s) in a directory (e.g. /opt/python2.7). Once that's done, I want to be able to alias the new python binary in .bash_profile so that my developers can begin using it.
I understand 2.7.1 can't be installed on a CentOS host but I've done the above using a shell script successfully. If you search hard enough, I posted my script on line . However, I need to create the RPM for political reasons. Besides placing the source file(s) in the SOURCES directory, what do I need to do in the spec to be able to successfully create an RPM installer?
Please be gentle with me. I've been drinking the Windows cool-aid for most of my IT career so, this is one of my first attempts of becoming a better DevOps Admin.
Programming :: Variable Substitution In Sqlite Open Db Command?
Jun 15, 2010I have the following TCL code:
if{ [catch {sqlite3 db /path/to/db/file} result] } {
puts stderr $result
} else {
do something
}
What I want is to use a variable for the file name/path. When I put in a variable instead of the absolute path, I get an error: "missing close-brace: possible unbalanced brace in comment while executing"
This is weird because when I run the code with the fully qualified pathname, it works fine. I substitute out the pathname for a variable containing the pathname ($variable) and I get this error.
Debian :: Deleting Data Before Specific Date In SQLite Database
Jun 22, 2015This is a continuation of the post in [URL].... . What has happened is that I have a huge log of 600 MB + and do not know from when the data is in there.
Code: Select all┌─[shirish@debian] - [~/.config/quassel-irc.org] - [9714]
└─[$] ll -h quassel-storage.sqlite
-rw------- 1 shirish shirish 647M Jun 22 21:15 quassel-storage.sqlite
So I need to know if there is a way to get just the first five or ten entries listed as one can do using head, tail etc. I did try just using head but it was unsuccessful. The second thing would be deleting some days, weeks or months data from the existing sqlite log. I did see URL... but in my case I am deleting old entries in the sqlite log and also do not know if sqlite makes backups of the data or not ?
Programming :: Python / Sqlite - Database Locked Despite Large Timeouts?
Apr 8, 2010I'm sure I'm missing something pretty obvious, but I can't for the life of me stop my pysqlite scripts crashing out with a database is locked error. I have two scripts, one to load data into the database, and one to read data out, but both will frequently, and instantly, crash depending on what the other is doing with the database at any given time.I've got the timeout on both scripts set to 30 seconds: cx = sqlite.connect("database.sql", timeout=30.0)and think I can see some evidence of the timeouts in that i get what appears to be a timing stamp (e.g 0.12343827e10 1) dumped occasionally in the middle of my curses formatted output screen, but no delay that ever gets remotely near the 30 second timeout, but still one of the other keeps crashing again and again from this. I'm running RHEL5.4 on a 64 bit HS21 IBM blade, and have heard some mention about issues about multi-threading and am not sure if this might be relevant.
Packages in use are sqlite-3.3.6-5 and python-sqlite-1.1.7-1.2.1, and upgrading to newer versions outside of RedHat's official provisions is not a great option for me. Possible, but not desirable due to the environment in general.I have had autocommit=1 on previously on both scripts, but have since disabled on both, and am now cx.commit()ing on the inserting script and not committing on the select script. Ultimately as I only ever have one script actually making any modifications, I don't really see why this locking should ever ever happen
Programming :: SQLite Read, Write, Select, Compare Statements For C++
Jun 9, 2010I am using C++ with SQLite db in a program that will read read a sub set of records, compare records and write different records to another database. I have a SQLite book, but it only shows examples for the C API. Anyone have code samples in C++ for the following:
Open database
Close
Select *
Read
Write
Or, just show me how to execute a SQL statement with C++ and I can then figure out the various SQL statements I need.
Fedora :: Failure: Repodata-primary.sqlite.bz2 From Updates: [Errno 256] No More Mirrors To Try?
Jun 10, 2010Fresh install of F13, just went to update and I get the following error:Code:failure: repodata-primary.sqlite.bz2 from updates: [Errno 256] No more mirrors to try.
View 7 Replies View RelatedCentOS 5 :: /primary.sqlite.bz2: [Errno -1] Metadata File Does Not Match Checksum?
May 10, 2011I have several CentOS 5.5 machines running on my network; yum works just fine for them. I used the 5.5 cds to install them. I decided to grab the DVD of 5.6 and build a new machine. Can't run yum.
http://mirrors.finalasp.com/CentOS/5.6/updates/x86_64/repodata/primary.sqlite.bz2: [Errno -1] Metadata file does not match checksum
Trying other mirror.
[code]....
Software :: ERROR "global Name 'sqlite' Is Not Defined" When Install Apache + Subversion + Trac
Oct 3, 2010ERROR "global name 'sqlite' is not defined" when install Apache + Subversion + Trac
Apache+Subversion+Trac
httpd-2.2.16
Python-2.6
swig-1.3.31
sqlite-3.6.13
subversion-1.6.12
mod_python-3.3.1
[Code]....
Ubuntu :: Netbook Edition Query ?
Mar 25, 2011I recently been given my dad's old netbook which is a toshiba nb100
I installed Ubuntu Netbook Edition onto it as i have some experiance with linux and have used ubuntu before and thought it would speed up this little machine. After the initial grind of the instal, it seemed to be running fine, however i didnt really like the netbook layout.
I noticed on the log in screen that i could select the desktop or netbook edition, is that normal? i have been using the desktop version since.
I have been doing some research however into the 11.04 release that is almost ready, and is ready in alpha stages. And what i understand is that the netbook layout is called Unity, and will be replacing gnome.
If and when i upgrade to 11.04, if i upgrade on the netbook login, will it replace both the logins i have access to currently, because the ubuntu install is changed and that was basically just choosing which display to use, unity or gnome. is that right?
Also i heard that for the 11.10 release they will be bringing the gnome desktop back? and that ubuntu netbook edition is being scrapped as they are basically merging
At the moment i prefer the desktop layout as i know where to access everything, although im sure i could get used to Unity, if its not too graphically demanding.
Either way i think i will wait till the end of april to upgrade to 11.04 as this laptop is fairly slow to begin with.
Ubuntu :: Partition Query - 35Gb In Limbo?
Jan 21, 2010I have recently setup my laptop to dual boot Win 7 and Karmic. Before I installed Karmic I shrank the space on one of the drives to accommodate Ubuntu. However, when I put the live CD in the drive - it gave me the option of installing Karmic next to Windoze or in the free space that I had created. I chose it to go next to Win 7 because it inferred that a choice of OS would be given on boot up by putting it next to Win 7.
However, I have a 35Gb 'unallocated' (as stated by GParted) - this is the space that I created but have not used. I wanted to remove this partition to maximise potential storage and would be grateful for advice on how this can be achieved.
Ubuntu :: Dual Boot Query On Reinstalling XP ?
Jul 13, 2010Have 2 HDDs, ubuntu 804 is on primary, xp is on secondary. using grub boot loader which defaults to xp.
xp install has crapped out and needs reinstalling. any caveats i should be aware of?
My thoughts were that i should just stick the xp cd in, boot her up, reformat secondary, install xp and everything would be fine?