Issue Bug Closed

#23861t3lib_db::INSERTquery misses a space when generering the INSERT INTO statement

Ernesto Baschny 10/28/10, 15:12 updated 10/02/18, 12:22

Description

Since #20947 (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. :)

(issue imported from #M16155)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.