Fixed
Details
Details
Priority
Assignee
Alex
AlexReporter
Dmitry Andrejev
Dmitry AndrejevDeveloper
Alex
AlexChange Log Message
Fixed Fatal error during Installation on States import with MySQL in Strict Mode
External issue ID
1201
External issue URL
Story Points
1
Fix versions
Affects versions
Patch Instructions
Patches must be submitted through Phabricator.
To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial.
To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial.
Created February 1, 2012 at 8:16 PM
Updated December 29, 2024 at 9:06 PM
Resolved July 25, 2012 at 10:31 AM
On 2nd Installation STEP SQL error due to MySQL being in Strict Mode (default in Windows)
" Error: (1364) Field 'l1_Name' doesn't have a default value
Last Database Query:
INSERT INTO CountryStates (CountryStateId, Type, StateCountryId,
IsoCode, ShortIsoCode) VALUES
(1, 1, NULL, 'AFG', 'AF'),
(2, 1, NULL, 'ALB', 'AL'),
(3, 1, NULL, 'DZA', 'DZ'),
(4, 1, NULL, 'ASM', 'AS'),
(5, 1, NULL, 'AND', 'AD'),
(6, 1, NULL, 'AGO', 'AO'),
(7, 1, NULL, 'AIA', 'AI'),
(8, 1, NULL, 'ATA', 'AQ'),
(9, 1, NULL, 'ATG', 'AG'),
(10, 1, NULL, 'ARG', 'AR'),
(11, 1, NULL, 'ARM', 'AM'),
(12, 1, NULL, 'ABW', 'AW'),
(13, 1, NULL, 'AUS', 'AU'),
(14, 1, NULL, 'AUT', 'AT'),
(15, 1, NULL, 'AZE', 'AZ'),
.....
(308, 2, 225, 'AZ', NULL),
(307, 2, 225, 'AK', NULL),
(306, 2, 225, 'AL', NULL)
Additionally, all developers agreed to enable MYSQL STRICT mode by default via DBG during project development.