[TYPO3-shop] createUser = 1 creates fe_user entry with quotes around values in DB

Jochen Rieger j.rieger at connecta.ag
Wed Jul 5 11:12:51 CEST 2006


Hi all,

using tt_products 2.4.11 and TYPO3 4.0 I ran into the following issue:

When setting createUser = 1 an fe user is created after entering the
address data in the basket section.

But in the DB each field's value is embraced by quotes:

'myUserName at email.com'

Debugging showed that indeed the values are brought as follows into the
SQL query:

'\'myStringValue\''

In lib/class.tx_ttproducts_order.php values are processed by
fullQuoteStr() before passing them to exec_INSERTquery().

A quick look into TYPO3's API showed this description of the function
argument $field_values of exec_INSERTquery():

<quoteFromAPI>
Field values as key=>value pairs. Values will be escaped internally. ...
</quoteFromAPI>

So, I think the processing through fullQuoteStr() could be removed. At
least on my system the default behaviour led to problems as values seem 
to be quoted and escaped too much.

Anyone else that already ran into this problem?

Regards,
Jochen



More information about the TYPO3-project-tt-products mailing list