For Those Who Don't Have PDO

Shadowdare

A question that usually would appear would be about an error relating to PDO shows up when you visit your freshly uploaded Vanilla 2.0.15 folder. It's obviously not a bug but I don't know where else to post this, but I originally had the question of "why am I getting an error about PDO?"

I wanted to help out by showing a small workaround. This happens because the PDO extension doesn't exist on the servers of your host. If your host, for some weird reason, denies enabling PDO, then there are workarounds available online. I managed to get PHPPDO to do it.

The error looks like this:
Class 'PDO' not found in /vanilla/conf/config-defaults.php

I downloaded PHPPDO and created a folder called "phppdo" in the root of my Vanilla folder. I then opened /vanilla/library/core/class.router.php and added these lines of code to the top:
function db_connect($dsn, $username = '', $password = '', $driver_options = array(), $path = './phppdo')
{
$driver = strtolower(trim(substr($dsn, 0, strpos($dsn, ':'))));

if($driver && class_exists('PDO') && extension_loaded('pdo_' . $driver))
{
$class = 'PDO';
}
else
{
require_once($path . '/phppdo.php');
$class = 'PHPPDO';
}

return new $class($dsn, $username, $password, $driver_options);
}

try
{
$db = db_connect('mysql:dbname=', 'dbuser', 'dbpass', array(), $_SERVER['DOCUMENT_ROOT'].'/vanilla/phppdo');
} catch(PDOException $e)
{
die($e->getMessage());
}

For the try statement, I added in my database info after each equals sign and the variables in $db. I'm not sure how to call the variables for $DatabaseName, $DatabaseUser, $DatabasePassword yet. If anyone knows how, please let me know.

After saving that file, I received another error like this one:
Cannot instantiate abstract class PDO in /vanilla/applications/dashboard/controllers/class.setupcontroller.php on line 120

So I opened that file up and went down to line 120 and changed it up:
Find:
$Connection = new PDO
Change that to:
$Connection = new PHPPDO

Then I received the same error for /vanilla/library/database/class.database.php. The same fix applies here on line 56:
Change:
$this->_Connection = new PDO
To:
$this->_Connection = new PHPPDO

Now you can run Vanilla without PDO installed on your server.

Mark

This is cool. I bet you could turn this into a plugin pretty easily. I bet @Todd has something to say about it...

TiGR

@Mark, would plugin work during installation process?

Shadowdare

It would have to make use of $class as a global as well. The plugin would be an interesting idea but for new fresh installs the installation page won't be able to show up unless there's a if statement in the router to enable the plugin in case when no PDO is detected instead of doing these changes directly to the other two files. Actually, a plugin is more than is necessary. What do you think @Mark?

lion91

I do all this but show me:

SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'localhost' (using password: YES)

what now ? ;)

kaos

@lion91 i think you need to change the username and password to your host details

Shadowdare

@lion91: I think Kaos is right. Let us know what happens.
$db = db_connect('mysql:dbname=', 'dbuser', 'dbpass', array(), $_SERVER['DOCUMENT_ROOT'].'/vanilla/phppdo');
Add the dbname after the equals sign and change dbuser and dbpass. Also, make sure that the path to the phppdo is correct.

Bassscape

Thanks for the PDO tip Shadowdare!
I have just used these mods to run Vanilla2 on my MoWeS local host.
I was wondering if anyone has experienced any adverse affects from making these changes?

Shadowdare

I've been running Vanilla without any problems for about a month now with PHPPDO.

cvwpadmin

What do you need to add to db_connect if your database isn't running on localhost?

ModsGuru

Please try to use the following:
$db = db_connect("mysql:host='your_hostname';dbname=", 'dbuser', 'dbpass', array(), $_SERVER['DOCUMENT_ROOT'].'/vanilla/phppdo');

Ristlin

I get this error when I make the first set of changes:

Parse error: syntax error, unexpected T_TRY, expecting T_FUNCTION

Any ideas?

dleffler

For v2.0.18.1 some of the info has changed:

in /vanilla/library/database/class.database.php - comment out line 55 ($this->IsPersistent ... - edit is now on line 58

in /vanilla/library/core/class.router.php - you enter the code AFTER the opening line <?php - you must enter the database name, user name, and password

in /vanilla/applications/dashboard/controllers/class.setupcontroller.php - edit is now on line 137

Also, if you muck up the install along the way, you may have to empty the database (drop all the tables) and delete the /conf/config.php file.

dleffler

For v2.0.18.2 some of the info has changed:

in /vanilla/library/database/class.database.php - comment out line 54 ($this->IsPersistent ... - edit is now on line 57 - also had to add require_once($_SERVER['DOCUMENT_ROOT'].'/external/vanilla/phppdo'. '/phppdo.php'); on line 29

in /vanilla/library/core/class.router.php - you enter the code AFTER the opening line <?php - you must enter the database name, user name, and password

in /vanilla/applications/dashboard/controllers/class.setupcontroller.php - edit is now on line 137

Also, if you muck up the install along the way, you may have to empty the database (drop all the tables) and delete the /conf/config.php file.

I seem to get timeout errors though when trying it with remote sites (rather than a local test site)

coloradomoms

I now get this... Fatal error: Undefined class constant 'PDO::ATTR_DEFAULT_FETCH_MODE' in /home/emily/public_html/vanilla/phppdo/phppdo.php on line 361

Any advice?