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!

Viewing Issue Advanced Details Jump to Notes ] Wiki ]  Related Changesets ] View Simple ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000011 [In-Portal CMS] Install / Upgrages bug report always 2009-05-18 09:59 2010-01-11 22:05
Reporter Dmitry View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority critical Resolution fixed Platform
Status closed   OS Windows XP
  OS Version
ETA none Fixed in Version 5.0.2 Product Version 5.0.0
  Target Version 5.0.2 Product Build
Time Estimate3 hours total (3 hours remaining)
Summary 0000011: Installation Fails with MySQL in Strict mode
Description Installation Fails on Step1 with MySQL in Strict mode.

See SQL errors below.
Steps To Reproduce
Additional Information SQL query:

INSERT INTO `Category` ( `l1_Name` , `Filename` , `AutomaticFilename` , `l1_Description` , `Status` )
VALUES (
'Content', 'Content', '0', 'Content', '4'
)

MySQL said: Documentation
0001364 - Field 'CachedTemplate' doesn't have a default value
Tags No tags attached.
Reference
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to 0000211closed (5.0.2)alex Make all fields, that contain dates NULL with NULL default value 

-  Notes
User avatar (0000525)
alex (manager)
2009-09-23 13:07

Plan:
1. There no way to detect what fields are incorrectly declared without installing In-Portal on MySQL server with strict mode on, so only approximate quote here.
2. Uncomment DBG_SQL_MODE option in debug.php to enable strict mode on any MySQL server.
User avatar (0000589)
alex (manager)
2009-09-29 12:04

Fix committed to 5.0.x branch. Commit Message:

Fixes 0000011: Installation Fails with MySQL in Strict mode
User avatar (0001338)
Dmitry (manager)
2010-01-11 22:05

Closing completed tasks.

- Related Changesets
Modules :: In-Commerce: 5.0.x r12878
Timestamp: 2009-11-03 14:47:17
Author: alex
Details ] Diff ]
1. Bug 0000011: Installation Fails with MySQL in Strict mode
2. Unable to create new product in strict mode (clean install only), tells that PackageContent column could not be null.
mod - /w/in-commerce/branches/5.0.x/in-commerce/install/install_schema.sql Diff ] File ]
In-Portal CMS: 5.0.x r12641
Timestamp: 2009-09-29 12:04:12
Author: alex
Details ] Diff ]
Fixes 0000011: Installation Fails with MySQL in Strict mode
mod - /in-portal/branches/5.0.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.0.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.0.x/core/units/helpers/language_import_helper.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2010-01-11 22:05 Dmitry Note Added: 0001338
2010-01-11 22:05 Dmitry Status resolved => closed
2009-11-03 14:49 alex Relationship added related to 0000211
2009-11-03 14:47 alex Changeset attached 5.0.x r12878
2009-10-03 07:43 administrator Priority normal => critical
2009-09-29 12:04 alex Patch Status => Not Used
2009-09-29 12:04 alex Fixed in Version => 5.0.2
2009-09-29 12:04 alex Note Added: 0000589
2009-09-29 12:04 alex Status active => resolved
2009-09-29 12:04 alex Resolution open => fixed
2009-09-29 12:04 alex Assigned To => alex
2009-09-29 12:04 alex Changeset attached 5.0.x r12641
2009-09-23 13:07 alex Time Estimate Added 3
2009-09-23 13:07 alex Note Added: 0000525
2009-09-20 15:11 alex Target Version 5.1.0 => 5.0.2
2009-08-03 16:03 Dmitry Target Version 5.0.1 => 5.1.0
2009-05-18 09:59 Dmitry New Issue



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

Powered by Mantis Bugtracker