ZC158a; PHP 8.2.4; MySQL 10.4.17-MariaDB-log
I installed Image Handler 5.3.2 on my dev system and received a fatal error
Code:
PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's canvas. Default is <strong>Center</Strong>.', 4, 1171, now(), NULL, 'zen_cf...' at line 4 :: INSERT IGNORE INTO zen_configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function)
VALUES
('IH watermark gravity', 'WATERMARK_GRAVITY', 'Center', 'Select the position for the watermark relative to the image's canvas. Default is <strong>Center</Strong>.', 4, 1171, now(), NULL, 'zen_cfg_select_option([\'Center\',\'NorthWest\',\'North\',\'NorthEast\',\'East\',\'SouthEast\',\'South\',\'SouthWest\',\'West\'],') ==> (as called by) E:\Web\zc158A_DEV_PHP8.2\admin\includes\init_includes\init_image_handler.php on line 190
the error comes from the escaped apostrophe
HTML Code:
the image\'s canvas
on line 167.
Because the installer crashed I did not have the option under Admin > Tools to uninstall image handler so I deleted the database entries based on the code in admin / image_handler_uninstall.php then recopied the files with the ofending apostrophe removed.
I have searched the net and cannot find any answer to the problem.
Is there a switch in MariaDB that disallows escaping characters such as this?
Bookmarks