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 it all works fine. it was installing sqlite3 to my local bin but the version was being read from the usr/bin instead of the usr/local/bin i believe. this was my fault. i installed mysql some time ago and must have accidently left off the / when i was modifying the path :( thanks all for your help, I believe this solved the problem : D Lawrence Gold-3 wrote: > > 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 version 3.5.4 >> 3 - I know that macports has installed 3.6.11, but don't know where >> it was >> installed. >> >> How on earth do i get all these versions to be the same? > > MacPorts installs to /opt/local/bin by default. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/sqlite3---version-showing-the-wrong-version-tp22596369p22613840.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users