Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:29 PM, erfon haubenstock m...@erfon.com wrote: Hi again. Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you must

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread erfon haubenstock
Hey Jean-Denis! I think you may not have seen my most recent post : D I used the link you sent me (i think it was yours) that explained that the local .bash_login could be overriding my .profile. I copied the contents of .profile into my .bash_login and now my port command works just fine! I

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/20/09 10:41 AM, erfon haubenstock m...@erfon.com wrote: Hey Jean-Denis! I think you may not have seen my most recent post : D I used the link you sent me (i think it was yours) that explained that the local .bash_login could be overriding my .profile. I copied the contents of

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:35 PM, P Kishor punk.k...@gmail.com wrote: why make things so difficult for yourself? download the amalgamation source code and untar/unzip it somwhere. type ./configure followed by make sudo make install this will put your sqlite libraries under /usr/local/ type

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 11:07 AM, erfon haubenstock m...@erfon.com wrote: Hello Jean-Denis! I did it manually in terminal. I'm not familiar with macports or finks. Here's the exact code i used: $ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx $ cd sqlite-3.6.11 $ ./configure

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 10:28 AM, erfon haubenstock m...@erfon.com wrote: This is really strange. I'm using a mac with leopard which comes with version 3.4.0 installed. I've installed 3.6.11, and it installs successfully as far as I can tell, but then when I check the version with sqlite3 --version in

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Hello Jean-Denis! I did it manually in terminal. I'm not familiar with macports or finks. Here's the exact code i used: $ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx $ cd sqlite-3.6.11 $ ./configure --prefix=/usr/local $ make $ sudo make install thank you :-) erfon

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 12:20 PM, erfon haubenstock m...@erfon.com wrote: EEESH, i installed macports and when i try to port install i get an error that says the error port: command not found maybe this has something to do with it? my

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
EEESH, i installed macports and when i try to port install i get an error that says the error port: command not found maybe this has something to do with it? my $PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin Jean-Denis

[sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
This is really strange. I'm using a mac with leopard which comes with version 3.4.0 installed. I've installed 3.6.11, and it installs successfully as far as I can tell, but then when I check the version with sqlite3 --version in terminal, the version is shows that the installed version is STILL

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Hi again. Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you must open a new shell for the port command to be recognised (or re-export the

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread P Kishor
On Thu, Mar 19, 2009 at 5:29 PM, erfon haubenstock m...@erfon.com wrote: Hi again.  Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Lawrence Gold
On Mar 19, 2009, at 4:29 PM, erfon haubenstock wrote: Hi again. Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you must open a new

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Ok, we're getting somewhere now. I typed /usr/local/bin/sqlite3 -version and got 3.6.11. But when i typed sqlite3 --version i get 3.4. So it must be a path issue. This is my first experience with PATH. I know I need to change my path, but I don't know what is missing from it that is giving

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Thanks for pointing me to that piece of the guide. Copying the contents of my .profile into my .bash_login fixed the port command problem i was having : D This is my first experience with paths, .profile, or .bash_login and macports so this has all be quite a learning experience for me. I feel

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
ok so macports installed sqlite3 just fine, but how do i check the version? i think i now have 3 versions of sqlite installed. 1 - when i type sqlite3 --version i get version 3.4.0 2 - when i type usr/local/bin/sqlite3 --version i get version 3.5.4 3 - I know that macports has installed

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Lawrence Gold
On Mar 19, 2009, at 5:19 PM, erfon haubenstock wrote: ok so macports installed sqlite3 just fine, but how do i check the version? i think i now have 3 versions of sqlite installed. 1 - when i type sqlite3 --version i get version 3.4.0 2 - when i type usr/local/bin/sqlite3 --version i get

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread P Kishor
On Thu, Mar 19, 2009 at 6:19 PM, erfon haubenstock m...@erfon.com wrote: ok so macports installed sqlite3 just fine, but how do i check the version? i think i now have 3 versions of sqlite installed. 1 - when i type sqlite3 --version i get version 3.4.0 2 - when i type usr/local/bin/sqlite3

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Ok, i think i figured it out, only took me about 8 hours! see the path i had: $PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sb in:/sbin:/usr/local/bin:/usr/X11/bin it's missing the / as the very beginning of the path. i changed it to /usr/local... and now