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
Bookmarks