In-Portal Issue Tracker - In-Portal CMS
|
Viewing Issue Advanced Details |
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
211 |
[In-Portal CMS] Data Management |
bug report |
always |
2009-08-08 02:27 |
2010-01-11 22:05 |
|
Reporter:
|
alex |
Platform:
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
Priority:
|
normal |
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:
|
0000211: Make all fields, that contain dates NULL with NULL default value |
Description:
|
Currently, for new records we have "01/01/1970 3:00:00 AM" in date fields. This happens because of:
1. field is marked as "NOT NULL" in database
2. field's default value is 0
We need all date fields in system and fix them to solve mentioned above problem. |
Steps To Reproduce:
|
|
Additional Information:
|
See "Last Used On" field for coupons. |
Relationships | related to | 0000011 | closed (5.0.2) | alex | Installation Fails with MySQL in Strict mode |
|
Attached Files:
|
date fields made null.patch (171,003) 2009-10-04 08:09 http://tracker.in-portal.org/file_download.php?file_id=62&type=bug date+fields+made+null_v2.patch (172,382) 2009-10-10 10:19 http://tracker.in-portal.org/file_download.php?file_id=92&type=bug |
|
Issue History |
Date Modified |
Username |
Field |
Change |
2010-01-11 22:05 |
Dmitry |
Note Added: 0001375 |
|
2010-01-11 22:05 |
Dmitry |
Status |
resolved => closed |
2009-11-03 14:49 |
alex |
Relationship added |
related to 0000011 |
2009-11-03 14:48 |
alex |
Changeset attached |
5.0.x r12878 |
2009-10-20 03:17 |
alex |
Note Added: 0000929 |
|
2009-10-20 03:17 |
alex |
Status |
reviewed and tested => resolved |
2009-10-20 03:17 |
alex |
Fixed in Version |
=> 5.0.2 |
2009-10-20 03:17 |
alex |
Resolution |
open => fixed |
2009-10-20 03:17 |
alex |
Changeset attached |
5.0.x r12703 |
2009-10-20 03:14 |
alex |
Changeset attached |
1.0.x r12702 |
2009-10-20 03:10 |
alex |
Changeset attached |
5.0.x r12701 |
2009-10-20 03:09 |
alex |
Changeset attached |
5.0.x r12700 |
2009-10-20 03:09 |
alex |
Changeset attached |
5.0.x r12699 |
2009-10-20 03:07 |
alex |
Changeset attached |
5.0.x r12698 |
2009-10-20 03:05 |
alex |
Changeset attached |
5.0.x r12697 |
2009-10-18 02:55 |
Dmitry |
Note Added: 0000926 |
|
2009-10-18 02:55 |
Dmitry |
Assigned To |
!COMMUNITY => alex |
2009-10-18 02:55 |
Dmitry |
Status |
needs testing => reviewed and tested |
2009-10-10 10:21 |
alex |
Note Added: 0000870 |
|
2009-10-10 10:21 |
alex |
Assigned To |
alex => !COMMUNITY |
2009-10-10 10:21 |
alex |
Status |
needs work => needs testing |
2009-10-10 10:19 |
alex |
File Added: date+fields+made+null_v2.patch |
|
2009-10-08 18:49 |
Dmitry |
Note Added: 0000859 |
|
2009-10-08 18:49 |
Dmitry |
Assigned To |
!COMMUNITY => alex |
2009-10-08 18:49 |
Dmitry |
Status |
needs testing => needs work |
2009-10-04 08:10 |
alex |
Time Estimate Removed |
3 => |
2009-10-04 08:10 |
alex |
Assigned To |
alex => !COMMUNITY |
2009-10-04 08:10 |
alex |
Status |
active => needs testing |
2009-10-04 08:09 |
alex |
File Added: date fields made null.patch |
|
2009-10-03 07:52 |
administrator |
Status |
reviewed and tested => active |
2009-09-30 06:59 |
alex |
Assigned To |
andrew => alex |
2009-09-30 06:58 |
alex |
Status |
active => reviewed and tested |
2009-09-30 06:58 |
alex |
Assigned To |
=> andrew |
2009-09-23 13:24 |
alex |
Time Estimate Added |
3 |
2009-09-23 13:24 |
alex |
Note Added: 0000535 |
|
2009-09-21 03:21 |
alex |
Target Version |
=> 5.0.2 |
2009-08-08 02:27 |
alex |
New Issue |
|
Notes |
|
(0000535)
|
alex
|
2009-09-23 13:24
|
|
Plan:
1. detect such field by usage of kDateFormatter in unit configs
2. made appropriate changes in database and install/upgrade scripts. |
|
|
(0000859)
|
Dmitry
|
2009-10-08 18:49
|
|
NEW INSTALLATION:
1. This is SQL syntax error within in-auction/install/install_schema.sql
================
ALTER TABLE Products
ADD LastListingId INT(11) NOT NULL DEFAULT '0',
ADD ScheduleId INT(11) NOT NULL DEFAULT '0';
ADD INDEX ( ScheduleId );
================
UPGRADE - NOTE TESTED YET. |
|
|
(0000870)
|
alex
|
2009-10-10 10:21
|
|
Because of problem with products_config.php file (see 0000370) it wasn't included in first patch. Now all is ok, install/upgrade tested for no errors in sql at least. Needs to be tested, that admin console looks/works the same after clean install/upgrade. |
|
|
(0000926)
|
Dmitry
|
2009-10-18 02:55
|
|
Installation and Admin tested ok. |
|
|
(0000929)
|
alex
|
2009-10-20 03:17
|
|
Fix committed to 5.0.x branch. Commit Message:
Fixes 0000211: Make all fields, that contain dates NULL with NULL default value |
|
|
(0001375)
|
Dmitry
|
2010-01-11 22:05
|
|
|