[INP-173] Make all fields, that contain dates NULL with NULL default value - In-Portal Issue Tracker

XML

Word

Printable

Details

Type: Bug Report
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 5.0.0
Fix Version/s: 5.0.2
Component/s: Data Management
Labels:
- multi-project-commit

External issue URL:
http://tracker.in-portal.org/view.php?id=211
Additional information:

Hide

See "Last Used On" field for coupons.

Show
See "Last Used On" field for coupons.
External issue ID:
211
Copy Issue Key:
Patch Instructions:
Patches must be submitted through Phabricator.
- To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial
- To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial

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.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

date+fields+made+null_v2.patch
168 kB
10/Oct/09 10:19 AM
date fields made null.patch
167 kB
04/Oct/09 8:09 AM

Issue Links

relates to

INP-6 Installation Fails with MySQL in Strict mode

Closed

Activity

People

Assignee:

Alex

Reporter:

Alex

Votes:

0 Vote for this issue

Watchers:

0 Start watching this issue

Dates

Created:

08/Aug/09 2:27 AM

Updated:

22/Sep/15 3:44 PM

Resolved:

11/Jan/10 10:05 PM