In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Relationship Graph View Issue ] Dependency Graph ]
related to child of duplicate of

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0001201 [In-Portal CMS] Install / Upgrages bug report always 2012-02-01 14:16 2012-07-25 05:31
Reporter Dmitry View Status public  
Assigned To alex
Priority normal Resolution fixed  
Status closed      
Summary 0001201: Fatal error during Installation on States import with MySQL in Strict Mode
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.
Additional Information 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

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker