Hi Guys,
I've just been doing an upgrade to a Zen 1.3.7 site to V1.5.1, and have run into a problem I've not experienced before even though I've done many of these.
The problem is with when I install IH4 I can no longer log into the admin of the site. Greeted with 'an error occurred please refresh the page'.
The log files reveal:
[20-Feb-2013 00:36:53] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ' 1001, now(), now(), NULL,
'zen_cfg_select_option(array(''yes'',''no''),')' at line 1 :: INSERT INTO zen_configuration (configuration_id,
configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id,
sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'IH resize images', 'IH_RESIZE',
'no', 'Select either -no- which is old Zen-Cart behaviour or -yes- to activate automatic resizing and caching of images.
--Note: If you select -no-, all of the Image Handler specific image settings will be unavailable including: image filetype
selection, background colors, compression, image hover, and watermarking-- If you want to use ImageMagick you have to
specify the location of the <strong>convert</strong> binary in <em>includes/extra_configures/bmz_image_handler_conf.php
</em>.', , 1001, now(), now(), NULL, 'zen_cfg_select_option(array(''yes'',''no''),') in
/home/spotty/public_html_dev/includes/classes/db/mysql/query_factory.php on line 120
Any ideas what would cause this? Its been bugging me for several hours and need to call it a night. Hopefully with some fresh ideas in the morning.
Cheers
Rod