☆ A M B ☆
I couldn’t test the Person example on xPDO site per lack of table/class/map files. So, I created the table and the class, and as I looked at the map file, I realized I hadn’t created a table for the Person example, rather the xpdosample table... So, I needed to adjust the person example to match that of my table/map file...
<?php
$sample= $xpdo->newObject('xpdosample');
$sample->set('parent', null );
$sample->set('unique_varchar', 'row_one');
$sample->set('varchar', 'hello world');
$sample->set('text', 'xPDO Sample');
$sample->set('timestamp', date('H:i:s'));
$sample->set('unix_timestamp', time );
$sample->set('date_time', date('Y-m-d H:i:s'));
$sample->set('date', date('Y-m-d'));
$sample->set('enum', 'T');
$sample->set('password', md5('password'));
$sample->set('integer', 13);
$sample->set('boolean', 1);
$sample->save();
CREATE TABLE `xpdosample` (
`parent` int(11) default NULL,
`unique_varchar` varchar(255) NOT NULL,
`varchar` varchar(100) NOT NULL,
`text` text,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`unix_timestamp` int(11) NOT NULL,
`date_time` datetime NOT NULL,
`date` date NOT NULL,
`enum` enum('','T','F') NOT NULL,
`password` varchar(255) NOT NULL,
`integer` int(11) NOT NULL,
`boolean` binary(1) NOT NULL,
UNIQUE KEY `unique_varchar` (`unique_varchar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='My first xPDO Test ;)'
Fatal error: Uncaught exception ’PDOException’ with message ’could not find driver’ in /home/username/public_html/xpdo/xpdo.class.php:293 Stack trace: #0
<?php $this->pdo= new PDO($this->config['dsn'], $this->config['username'], $this->config['password'], $this->config['driverOptions']);
PDO support enabled
PDO drivers sqlite2
☆ A M B ☆
MODX Staff
You should have the pdo_mysql.so (or pdo_mysql.dll on windows) available in your PHP installation. I bet it just needs to be uncommented in your php.ini.
All works (connection established, etc) until I uncomment the save() method. Error indicates a missing driver?
phpinfo() revealed:
PDO support enabled
PDO drivers sqlite2
Well, on the php.net PDO page, it states that if on PHP 5.1+ (which I am) PDO and PDO_SQLITE are included in the distribution, and are automatically enabled by running configure...Also, You may also need to enable the PDO driver for your database of choice:
[*] PDO Drivers: http://www.php.net/manual/en/ref.pdo.php#pdo.drivers (Reference MySQL 3.x and 4.x )
Oh no! I am running MySQL 5.0.27-standard! Can I still use xPDO?
☆ A M B ☆
MODX Staff
Can you not test/develop this locally? And, honestly, they either need to disable PDO altogether or at least enable some drivers for MySQL at least...unfortunately, that’s the one situation where I can’t find a way to get xPDO to work: the fact that the PDO class is available triggers the cascade that then requires the native PDO driver, rather than the emulated PDO drivers provided for systems using the emulated PDO class.
Great... I hope my shared host can assist! Really wish I had dedicated right now... Maybe xPDO will have to wait for me
☆ A M B ☆
MODX Staff
That’s what I’m saying; it happens automatically based on the existence of the native PDO class extension that comes built into PHP 5.1+, and there is no easy way to test for the MySQL PDO driver without loading PDO, and then you’ve already loaded the class you now don’t want. You need to trick it, by hardcoding it and making sure the PDO class in the package gets loaded, rather than the PDO that exists in PHP.
oooh, I like the sound of this... Where (in the docs perhaps?) can I find how to swap native PDO for xPDO? (As you described)
MODX Staff
Hmmm then again, you could force the loading of the emulated PDO, which will be able to find the driver...just find both instances of class_exists(’PDO’) in xpdo.class.php and remove them, altering the logic to load the xPDO-provided PDO class rather than the native PDO class already available and to set the XPDO_MODE constant to XPDO_MODE_EMULATED.
MODX Staff
☆ A M B ☆
Indeed, I am modifying the xpdo class to allow this by simply defining the constant XPDO_MODE with a value of 2 before including the main xpdo.class.php. Will be available in the next release...
