[Solved] PDO Module Error

K3nB

I started to install Vanilla last night and immediately ran into two errors:

You must have the PDO module enabled in PHP in order for Vanilla to connect to your database.
You must have the MySQL driver for PDO enabled in order for Vanilla to connect to your database.

I opened a support ticket with my webhost and they said they'd install the needed modules and to try again in 30 minutes. This morning the installer still gives me the same errors. My webhost says the modules are installed and referred me to my PHPINFO file which shows the Configure Command section below, and it does look like those needed modules are installed. Is there something that I need in my PHP.INI file to get Vanilla to see these modules? Thanks!

'./configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zend-multibyte' '--enable-zip' '--prefix=/usr' '--with-bz2' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mm=/opt/mm/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'

peregrine

create a phpinfo.php program with this line and run it. It will show your php configuration, should show whether pdo is enabled or not as well as mysql, etc.

<?php phpinfo(); ?>

UnderDog

The messages come from this piece of code:

private function _CheckPrerequisites() {
     // Make sure PDO is available
      if (!class_exists('PDO'))
         $this->Form->AddError(T('You must have the PDO module enabled in PHP in order for Vanilla to connect to your database.'));

      if (!defined('PDO::MYSQL_ATTR_USE_BUFFERED_QUERY'))
         $this->Form->AddError(T('You must have the MySQL driver for PDO enabled in order for Vanilla to connect to your database.'));

in /applications/dashboard/controllers/class.setupcontroller.php

Also please take a look at these Urls :

http://stackoverflow.com/questions/6113262/how-to-determine-if-pdo-enabled-in-php

http://stackoverflow.com/questions/10388833/how-can-i-tell-if-pdo-module-installed-disabled

http://www.veppa.com/blog/forums/topic/autoloader-did-not-found-file-for-pdo/

http://www.precurio.com/forums/archive/index.php?thread-488.html

http://pastebin.com/KNJpCeiL

Lots of reading material, some scripts you can run, to really determine if PDO is running.

Hope it helps :-)

K3nB

Thanks much, UnderDog! I finally figured out what the problem was. I had an old custom PHP.INI in my root that was overriding what my webhost had configured. On adding the correct directives for PDO to my custom PHP.INI, Vanilla's installer fired right up. I then realized I no longer needed that old PHP.INI and just zapped it. I appreciate all the resources you provided, though.