[TYPO3-core] FYI24 #16155: t3lib_db::INSERTquery misses a space when generering the INSERT INTO statement

Xavier Perseguers typo3 at perseguers.ch
Thu Oct 28 15:59:43 CEST 2010


Hi,

> Problem:
> Since RFC #11813 (rev. 6203, 4.3.0 and later), a CGL cleanup on
> t3lib_db, the INSERTquery method generates a slightly non-conformant query:
>
> INSERT INTO table(field1, field2) VALUES ($value1, $value2);
>
> note the missing space after the tablename. Correct would be:
>
> INSERT INTO table (field1, field2) VALUES ($value1, $value2);
>
> While newer MySQL versions accept this silently, it might fail on pretty
> old MySQL servers.
>
> And it is not that beautiful. :)

I agree!

;-)

Xavier


More information about the TYPO3-team-core mailing list