Page 1 of 1
Heavy error with PHP 5.1.1 and ADOB
Posted: Thu Jan 19, 2006 1:06 pm
by 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.
Re: Heavy error with PHP 5.1.1 and ADOB
Posted: Thu Jan 19, 2006 2:21 pm
by 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'' )
Re: Heavy error with PHP 5.1.1 and ADOB
Posted: Thu Jan 19, 2006 3:10 pm
by 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.
Re: Heavy error with PHP 5.1.1 and ADOB
Posted: Sat Jan 21, 2006 5:25 am
by Ted
Thanks for that. It's fixed in svn.