-
Type: Bug Report
-
Status: Closed
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 5.1.0
-
Fix Version/s: 5.2.0-B2
-
Component/s: Install / Upgrages
-
Labels:None
-
External issue URL:
-
Additional information:
-
Change Log Message:Fixed Fatal error during Installation on States import with MySQL in Strict Mode
-
Story Points:1
-
External issue ID:1201
-
Copy Issue Key:
-
Patch Instructions:
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.
- relates to
-
INP-6 Installation Fails with MySQL in Strict mode
- Closed
-
INP-48 Add Timezone Field to User record
- Closed
-
INP-88 Implement "MemCached" functionality
- Closed
-
INP-235 Phrases of state and country names
- Closed
-
INP-509 User / Group Access restriction by IP
- Closed
-
INP-713 Site domain-based agents
- Closed
-
INP-762 Change in "Forgot Password" logic
- Closed
-
INP-764 Log CURL requests to database table instead of file
- Closed
-
INP-778 Improvements to user Login field
- Closed
-
INP-851 Ability to access Disabled Section with Direct Link
- Closed
-
INP-923 Report Review
- Closed
-
INP-1652 Create smart filters functionality for item lists on Front-End
- Closed
- mentioned in
-
Wiki Page Loading...