[TYPO3-dev] sql insert... what happen ??? !!!

Gregory Loichot gloichot at cross-systems.com
Fri Feb 11 13:18:45 CET 2011


Hello,
I'm using TYPO3 4.4.6 and I'm doing a simple thing :

$aQ = array (	'date' 	=> time(),
		'action'=> $action,
		'username'=> $username,
		'rubicsid' 	=> $rubicsid,
		'email'		=> $email,
		'service' 	=> $service);
		$GLOBALS['TYPO3_DB']->exec_INSERTquery('tx_cr', $aQ);

The executed query is..... :

INSERT INTO tx_cr (date,action,username,rubicsid,email,service) VALUES 
('','echec signin unknown','','','xxx at yopmail.com','global');

Question : why "date" field is empty ?
I inspect into class.t3lib_db.php, in fullQuoteArray function. Before 
the foreach, we have $arr :
Array
(
     [date] => 1297426187
     [action] => echec signin unknown
     [username] =>
     [rubicsid] =>
     [email] => xxx at yopmail.com
     [service] => global
)

and AFTER :

Array
(
     [date] => ''
     [action] => 'echec signin unknown'
     [username] => ''
     [rubicsid] => ''
     [email] => 'xxx at yopmail.com'
     [service] => 'global'
)

Any ideas ?




More information about the TYPO3-dev mailing list