Adding backquotes to SQL statements

[Ruud]

I had to modify the catalog extension files in order for some update queries to work. I'm not entirely certain where the problem lies, but I had to enclose all tablenames and fields in backquotes (`a_tablename`) in order for certain SQL errors to disappear.

This came up when I tried to edit a fields maxValue after the field had been created. So I changed all UPDATE statements I could find in Catalop.php, CatalogComment.php, tl_catalog_fields.php and ModuleCatalogEdit.php.

I'm using a recent xampp version (downloaded and installed earlier this year), so that's MySQL server version 5.5.8

Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
PHP extension: mysqli

[MacKP]

Hm never had such a thing...
Did you have the error Messages?

regards

[Ruud]

Yes, it said unknown column name. I find it strange as I'd expect the queries to work without backquotes. But it seems it is best to just add them?