In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
11 [In-Portal CMS] Install / Upgrages bug report always 2009-05-18 09:59 2010-01-11 22:05
Reporter: Dmitry Platform:  
Assigned To: alex OS: Windows XP  
Priority: critical OS Version:  
Status: closed Product Version: 5.0.0  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.0.2  
Reference:
Change Log Message:
Estimate Points: 0
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
Relationships
related to 0000211closed  (5.0.2)alex Make all fields, that contain dates NULL with NULL default value 
Attached Files:
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

Notes
(0000525)
alex   
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.
(0000589)
alex   
2009-09-29 12:04   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000011: Installation Fails with MySQL in Strict mode
(0001338)
Dmitry   
2010-01-11 22:05   
Closing completed tasks.