SiT! Bugs - SiT!
View Issue Details
0000887SiT!otherpublic2009-08-19 11:212011-06-07 19:25
paulh 
paulh 
normaltweakalways
resolvedfixed 
 
3.90beta1Current GIT 
0000887: db definition of sites and contacts
Both these tables have lots of fields (including address) which are set as NOT NULL which doesn't make sense these should allow NULL
No tags attached.
related to 0001403confirmed  We should store NULL rather than a empty string when as don't have the information 
related to 0001635resolved paulh Can't create site without department field 
Issue History
2009-08-19 11:21paulhNew Issue
2009-08-19 11:42ivanNote Added: 0001780
2010-02-20 19:59ivanStatusnew => confirmed
2010-02-20 20:00ivanTarget Version => 4.0
2010-09-26 18:54paulhRelationship addedrelated to 0001403
2011-02-14 13:25ivanTarget Version4.0 => 3.90beta1
2011-05-27 20:07paulhAssigned To => paulh
2011-05-27 20:07paulhStatusconfirmed => assigned
2011-06-03 22:49ivanSeverityminor => tweak
2011-06-06 19:20paulhNote Added: 0003871
2011-06-06 19:20paulhFixed in Version => Current GIT
2011-06-06 19:25paulhStatusassigned => resolved
2011-06-06 19:25paulhResolutionopen => fixed
2011-06-07 09:01ivanNote Added: 0003874
2011-06-07 19:09paulhNote Added: 0003880
2011-06-07 19:25ivanNote Added: 0003883
2011-07-02 20:08TomseRelationship addedrelated to 0001635

Notes
(0001780)
ivan   
2009-08-19 11:42   
The not null fields do have defaults, the default is blank '' (an empty string)
(0003871)
paulh   
2011-06-06 19:20   
b9ca60d2869e79a54f7d3a9ae33890203551130b resolves
(0003874)
ivan   
2011-06-07 09:01   
When adding a contact I now get an error that address2 cannot be null.
(0003880)
paulh   
2011-06-07 19:09   
Did you update your schema? Double checked the schema and its defined and defined and updated as not null.

I did have a conflict on this file when I merged so perhaps gits screwed it up?
(0003883)
ivan   
2011-06-07 19:25   
ah, apologies it works now. I don't think my git was fully up to date when i reset my DB.