Fatal error during Installation on States import with MySQL in Strict Mode

Components

Labels

Description

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.

Context Information

None

Additional information (do not use)

My System is:
In-Portal version: in-portal_5_2_0_B1
MySQL Server version: 5.1.45
MySQL client version: 5.1.11
OS: Windows web Server2008
IIS: 6.0 SP1
PHP version: php-5.2.6-nts-Win32

Attachments

2

Activity

Alex 
February 11, 2013 at 3:56 PM

Reference found in associated topic page comments.

Alex 
July 25, 2012 at 10:31 AM

Since 5.2.0 version was released.

Alex 
February 7, 2012 at 2:36 PM

Patch "invalid_integer_value_fix.patch" fixes SQL error on module approve/decline because ID field in Modules table is string, while MasterId field in ChangeLogs table, where it was inserted is integer.

Alex 
February 6, 2012 at 10:19 AM

Fix committed to [b]5.2.x branch/b. Commit Message:

Fixes #0001201: Fatal error during Installation on States import with MySQL in Strict Mode

Alex 
February 6, 2012 at 10:19 AM

Will test all together later.

Fixed

Details

Priority

Assignee

Reporter

Developer

Change Log Message

External issue ID

External issue URL

Story Points

Fix versions

Affects versions

Patch Instructions

Patches must be submitted through Phabricator.

Created February 1, 2012 at 8:16 PM
Updated December 29, 2024 at 9:06 PM
Resolved July 25, 2012 at 10:31 AM