CMS MADE SIMPLE FORGE

CMS Made Simple Core

 
Back Back to List

[#7596] MySQL ADOConnection does not support transactions

avatar
Created By: Jurrie Overgoor (jurrie)
Date Submitted: Sun Feb 12 04:48:34 -0500 2012

Assigned To:
Version: 1.10
CMSMS Version: 1.10
Severity: Major
Resolution: Invalid
State: Closed
Summary:
MySQL ADOConnection does not support transactions
Detailed Description:
A fresh install of 1.10.3 breaks transactions in my modules. They work ok in
1.9.3.

In CMSMS 1.9.3, lib/adodb.functions.php:76 reads:
$dbinstance =& ADONewConnection($config['dbms'],
'pear:date:extend:transaction');

In CMSMS 1.10.3, lib/adodb.functions.php:79-80 read:
$str = 'pear:date:extend';
$dbinstance = ADONewConnection($config['dbms'], $str);

So the 'transaction' extention disappeared. Reenabling it makes my transactions
work again (the
lib/adodb_lite/adodbSQL_drivers/mysql/mysql_transaction_module.inc file is even
included in 1.10.3). So this is probably a bug.

Please make lib/adodb.functions.php:79-80 read:
$str = 'pear:date:extend:transaction';
$dbinstance = ADONewConnection($config['dbms'], $str);


History

Comments
avatar 
Date: 2012-02-12 10:22
Posted By: Robert Campbell (calguy1000)

CMSMS core does not use transactions... therefore this was not needed.
if you need transaction access to an Innodb table you will need to create your
own database connection.
avatar 
Date: 2012-02-13 02:47
Posted By: Jurrie Overgoor (jurrie)

CMSMS does not need transactions? I find that a bit hard to believe... But ok,
that's not the question here.

What do you mean by 'create your own database connection'? Can I use some
function in adodb.functions.php? Should I copy-and-alter adodb.functions.php?
Should I NOT use ADODB at all, but start my own DB layer from scratch?

In short:: to what extent is creating your own db connections supported in
CMSMS?
Updates

Updated: 2012-08-02 12:55
state: Open => Closed

Updated: 2012-02-12 10:22
resolution_id: => 9