SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001403SiT!otherpublic2010-09-26 18:542012-01-24 12:44
Reporterpaulh 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusconfirmedResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0001403: We should store NULL rather than a empty string when as don't have the information
DescriptionIn several places we insert an empty string rather than NULL when we don't have the details

contacts.telephone is an example

We should consistent this way we can write more efficient ocde and more easily use IF in SQL
TagsNo tags attached.
Attached Files

- Relationships
related to 0000887resolvedpaulh db definition of sites and contacts 
related to 0000958resolvedpaulh contact's and site's phones 
related to 0001635resolvedpaulh Can't create site without department field 
related to 0001755resolvedpaulh Inconsistencies in "setup-schema.php" can cause an upgrade to fail 
related to 0001743confirmed Inconsistencies in DB model 

-  Notes
User avatar (0003422)
paulh (administrator)
2010-09-26 18:58

git b9e96ff comes across this problem
User avatar (0003431)
ivan (administrator)
2010-10-12 18:30

We should, but we don't currently. So any change to this would mean we need a process to alter existing data.

- Issue History
Date Modified Username Field Change
2010-09-26 18:54 paulh New Issue
2010-09-26 18:54 paulh Relationship added related to 0000887
2010-09-26 18:58 paulh Relationship added related to 0000958
2010-09-26 18:58 paulh Note Added: 0003422
2010-10-12 18:30 ivan Note Added: 0003431
2011-07-02 20:09 Tomse Relationship added related to 0001635
2012-01-07 12:36 Tomse Relationship added child of 0001755
2012-01-07 12:37 Tomse Relationship deleted child of 0001755
2012-01-07 12:37 Tomse Relationship added related to 0001755
2012-01-07 12:38 Tomse Relationship added related to 0001743
2012-01-24 12:44 ivan Status new => confirmed


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker