/
MySql Strict Mode. Incorrect SQLs

MySql Strict Mode. Incorrect SQLs

Owned by Vjacheslav Vishnjakov
Jan 29, 2011

Imported From: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/c0f8be8fe4f9be58#

Problem instalation if hosting use  sql-
mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Error: (1364) Field 'l1_Name' doesn't have a default value

Last Database Query:
INSERT INTO bs_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'), .....