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

[Sebastian Fischer]

Am 28.10.2010 15:14, schrieb Ernesto Baschny [cron IT]:
> Hi,
>
> This is a SVN patch, which will be commited in 24h if nobody opposes.
>
> Type: Minor
>
> BT reference: http://bugs.typo3.org/view.php?id=16155
>
> Branches: trunk, TYPO3_4-4, TYPO3_4-3
>
> 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. :)
>
> Solution:
> Add the missing space.
>
>
> Cheers,
> Ernesto
>

+1 by reading