current community

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -2 down vote favorite

It seems that recent versions of php (5.3 and above?) the sqlite driver for pdo is not installed/enabled by default. This, despite official claims to the contrary.

Although there appears to be an easy fix for linux/debian/ubuntu users thanks to apt-get I'm having trouble fixing this on OSX (I think ampps works OK, but that lacks other extensions I need, and mac ports doesn't work). Anyone have a fix for this? (failing that, more info?)

share|improve this question
 
Check here abouthalf.com/development/php-in-snow-leopard –  Yogus Jun 12 '13 at 1:32
 
Thx @Yogus I may be able to find something in that. That page is largely about mysql (not sqlite) however. –  iPadDeveloper2011 Jun 12 '13 at 2:34
 
google is your friend this question has been asked –  Joe Jun 12 '13 at 6:24
 
@Joe. Although I find the ubiquitous "google is your friend" comment terribly annoying (after googling this for most of the day) the link you provided was helpful. Thank you. –  iPadDeveloper2011 Jun 13 '13 at 2:47
 
Also, its not the same question. My question is specifically about the sqlite pdo driver. –  iPadDeveloper2011 Jun 13 '13 at 2:58
show 3 more comments

1 Answer

up vote 1 down vote

What worked for me:

sudo port install php5-sqlite
sudo port install php5 +apache2 +sqlite

The second line here didn't seem to do anything, but you never know.

After restarting I noticed I didn't have imagemagick, which I thought I already had, so

sudo port install php5-imagick

Now restarting apache2 the "macports" way:

sudo port unload apache2
sudo port load apache2

And looking at phpinfo, I have sqlite2 and sqlite (which, confusingly, is sqlite3) drivers enabled for pdo.

share|improve this answer
 
Note that this is a solution only if you are using macports, or are prepared to use it. –  iPadDeveloper2011 Jun 17 '13 at 4:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.