Re: 'This driver does not support transactions' for Linux/PDO/MySQL driver

PHP 5.1b3 ships with a more recent mysql driver than is available via PECL; I suggest that you "pear uninstall pdo_mysql" and check that you enabled pdo_mysql when you configured PHP (it should also turn on automatically if you enable mysql). The other thing to note is that MySQL has pretty crappy transaction support, unless you create tables using a special table engine (BDB or InnoDB). What's really bad is that MySQL will happily let you begin a transaction even when none of your tables support it. --Wez. On 7/22/05, Matthew Peters <matthew_peters@uk.ibm.com> wrote: > I just did PDO's ->beginTransaction() on Linux with a recently > downloaded and installed PHP/PDO/MySQL combination and got the subject > message. > > I was surprised. It seems a bit fundamental. Have I done something wrong > or is it true - I can only have autocommit with Linux/PDO/MySQL? I did > hunt around in the docs but couldn't find the answer. > > Versions: > RedHat Linux RHEL3 > MySQL 4.1.13 > PHP 5.1.0b3 > PDO_Mysql driver 0.2 beta installed via 'pear -dpreferred_state=beta > install pdo_mysql' > > Matthew > > -- > PECL development discussion Mailing List (http://pecl.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >