02 Apr 2009, 21:16
#1
New Zenner
- Join Date:
- Apr 2009
- Posts:
- 1
- Plugin Contributions:
- 0
MySQL strict mode uncompliance
ZenCart 1.3.8a
Trying a fresh install on Win2008, Apache 2.2.11, PHP 5.2.9, MySQL 5.1 (not a wamp package).
cURL extension is not detected.
and then...
Error during database creation:
Reconfiguring mysql service, disabling mysql strict mode, helps to solve the problem. :yes:
However, I like strict-mode on my dev server since I don't want to be sloppy. :laugh:
Trying a fresh install on Win2008, Apache 2.2.11, PHP 5.2.9, MySQL 5.1 (not a wamp package).
cURL extension is not detected.
and then...
Error during database creation:
1366 Incorrect string value: '\xA3:&eur...' for column 'configuration_value' at row 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '£,£:€,€', 'What currency conversions do you need for Text emails?
Default = £,£:€,€', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');] Reconfiguring mysql service, disabling mysql strict mode, helps to solve the problem. :yes:
However, I like strict-mode on my dev server since I don't want to be sloppy. :laugh:
