Heavy error with PHP 5.1.1 and ADOB Topic is solved

[Piratos]

If you install a module and change the group permissions for the module the most permissions are lost.

PHP 5.1.1 with adodb from your package and the latest  4.70 Adodb is the same.

Alle the  rest works.

[Piratos]

It is the adodb function DBTimeStamp that makes the error.

i have tested it with the package adodb and  adodb 4.70 full version.

i have found this in adodb forum:

Hi there ...

following code (adodb 4.68, PHP5.1.1, mysql 4.1):
$dh = NewADOConnection( 'mysql' );
$dh->Connect( **,**,** );

$insert = array();
$msg = 'test';
$typ = "TEST";

$insert['typ'] = $dh->qstr( $typ , FALSE ); [1]
$insert['msg'] = $msg;
$insert['DBTIME'] = $dh->DBTimeStamp( time() );

$dh->AutoExecute( 'table_eg', $insert, 'INSERT' );

gives me this wrong sql-statment:
INSERT INTO da1.table_eg ( TYP, MSG, DBTIME ) VALUES ( '\'TEST\'', 'test', ''2005-12-03 15:40:11'' )

[Piratos]

And this is the reason of the double qouted timestring (in adodb.inc.php)

var $fmtTimeStamp = "'Y-m-d, h:i:s A'"; /// used by DBTimeStamp as the default timestamp fmt.

change it to

var $fmtTimeStamp = "Y-m-d, h:i:s A"; /// used by DBTimeStamp as the default timestamp fmt.

and it works.

[Ted]

Thanks for that.  It's fixed in svn.