Anonymous | Login | Signup for a new account | 2024-09-07 20:21 CDT | ![]() |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ] [ Related Changesets ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||
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 | Project Name | In-Portal CMS | ||
Assigned To | alex | Developer | |||||
Priority | normal | Resolution | fixed | Fixed in Version | 5.2.0-B2 | ||
Status | closed | Product Version | 5.1.0 | Target Version | 5.2.0 | ||
Time Estimate | No estimate | ||||||
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 |
||||||
Tags | No tags attached. | ||||||
Reference | https://groups.google.com/d/topic/in-portal-bugs/lY-iH4s5BWs/discussion | ||||||
Change Log Message | Fixed Fatal error during Installation on States import with MySQL in Strict Mode | ||||||
Estimate Points | 1 | ||||||
Attached Files |
![]() ![]() |
||||||
|
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
![]() |
|
![]() alex (manager) 2012-02-06 04:16 edited on: 2012-02-06 04:18 |
As you can see majority of STRICT MODE incompatible SQLs were added in 5.2.0-B1 version, but CountryStates SQL that is mentioned in task description was there since 5.1.0 version. I've also found, that creating VARCHAR NOT NULL column without specifying DEFAULT value would result in such error (http://forums.mysql.com/read.php?10,361859,361862#msg-361862). This problem is caused by phpMyAdmin script, that we're using, since it creates VARCHAR columns by default this way. |
![]() alex (manager) 2012-02-06 04:19 |
Will test all together later. |
![]() alex (manager) 2012-02-06 04:19 |
Fix committed to 5.2.x branch. Commit Message: Fixes 0001201: Fatal error during Installation on States import with MySQL in Strict Mode |
![]() alex (manager) 2012-02-07 08:36 |
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 (manager) 2012-07-25 05:31 |
Since 5.2.0 version was released. |
![]() |
|||
In-Portal CMS: 5.2.x r15107 Timestamp: 2012-02-07 08:33:43 Author: alex [ Details ] [ Diff ] |
Bug 0001201: Fatal error during Installation on States import with MySQL in Strict Mode 1. fixes SQL error on module approve/decline |
||
mod - /in-portal/branches/5.2.x/core/units/modules/modules_config.php | [ Diff ] [ File ] | ||
In-Portal CMS: 5.2.x r15105 Timestamp: 2012-02-06 04:19:28 Author: alex [ Details ] [ Diff ] |
Fixes 0001201: Fatal error during Installation on States import with MySQL in Strict Mode | ||
mod - /in-portal/branches/5.2.x/core/install/install_schema.sql | [ Diff ] [ File ] | ||
mod - /in-portal/branches/5.2.x/core/install/install_toolkit.php | [ Diff ] [ File ] | ||
mod - /in-portal/branches/5.2.x/core/install/upgrades.sql | [ Diff ] [ File ] | ||
mod - /in-portal/branches/5.2.x/core/units/helpers/multilanguage_helper.php | [ Diff ] [ File ] | ||
![]() |
|||
Date Modified | Username | Field | Change |
2012-07-25 05:31 | alex | Note Added: 0004978 | |
2012-07-25 05:31 | alex | Status | resolved => closed |
2012-02-07 08:36 | alex | Note Added: 0004450 | |
2012-02-07 08:33 | alex | Changeset attached | 5.2.x r15107 |
2012-02-07 08:32 | alex | File Added: invalid_integer_value_fix.patch | |
2012-02-06 04:19 | alex | Note Added: 0004447 | |
2012-02-06 04:19 | alex | Status | reviewed and tested => resolved |
2012-02-06 04:19 | alex | Fixed in Version | => 5.2.0-B2 |
2012-02-06 04:19 | alex | Resolution | open => fixed |
2012-02-06 04:19 | alex | Assigned To | !COMMUNITY => alex |
2012-02-06 04:19 | alex | Changeset attached | 5.2.x r15105 |
2012-02-06 04:19 | alex | Note Added: 0004446 | |
2012-02-06 04:19 | alex | Status | needs testing => reviewed and tested |
2012-02-06 04:18 | alex | Note Edited: 0004445 | View Revisions |
2012-02-06 04:16 | alex | Note Added: 0004445 | |
2012-02-06 04:16 | alex | Assigned To | => !COMMUNITY |
2012-02-06 04:16 | alex | Developer | => alex |
2012-02-06 04:16 | alex | Status | active => needs testing |
2012-02-06 04:15 | alex | File Added: sql_error_on_install_520b1.patch | |
2012-02-06 04:09 | alex | Relationship added | related to 0000950 |
2012-02-06 04:09 | alex | Relationship added | related to 0000107 |
2012-02-06 04:08 | alex | Relationship added | related to 0001129 |
2012-02-06 04:07 | alex | Relationship added | related to 0001126 |
2012-02-06 04:07 | alex | Relationship added | related to 0000883 |
2012-02-06 04:06 | alex | Relationship added | related to 0001050 |
2012-02-06 04:06 | alex | Relationship added | related to 0000279 |
2012-02-06 04:05 | alex | Relationship added | related to 0000058 |
2012-02-06 04:04 | alex | Relationship added | related to 0000964 |
2012-02-06 04:03 | alex | Relationship added | related to 0000645 |
2012-02-06 04:02 | alex | Estimate Points | 0 => 1 |
2012-02-06 04:02 | alex | Description Updated | View Revisions |
2012-02-06 04:02 | alex | Relationship added | related to 0000948 |
2012-02-01 14:16 | Dmitry | New Issue | |
2012-02-01 14:16 | Dmitry | Reference | => https://groups.google.com/d/topic/in-portal-bugs/lY-iH4s5BWs/discussion |
2012-02-01 14:16 | Dmitry | Change Log Message | => Fixed Fatal error during Installation on States import with MySQL in Strict Mode |
2012-02-01 14:16 | Dmitry | Estimate Points | => 0 |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic![]() In-Portal Open Source CMS |