Anonymous | Login | Signup for a new account | 2021-01-18 16:28 GMT | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0000887 | SiT! | other | public | 2009-08-19 11:21 | 2011-06-07 19:25 | ||||
Reporter | paulh | ||||||||
Assigned To | paulh | ||||||||
Priority | normal | Severity | tweak | Reproducibility | always | ||||
Status | resolved | Resolution | fixed | ||||||
Platform | OS | OS Version | |||||||
Product Version | |||||||||
Target Version | 3.90beta1 | Fixed in Version | Current GIT | ||||||
Summary | 0000887: db definition of sites and contacts | ||||||||
Description | Both these tables have lots of fields (including address) which are set as NOT NULL which doesn't make sense these should allow NULL | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | |||||||||
![]() |
|||||||||||
|
![]() |
|
ivan (administrator) 2009-08-19 11:42 |
The not null fields do have defaults, the default is blank '' (an empty string) |
paulh (administrator) 2011-06-06 19:20 |
b9ca60d2869e79a54f7d3a9ae33890203551130b resolves |
ivan (administrator) 2011-06-07 09:01 |
When adding a contact I now get an error that address2 cannot be null. |
paulh (administrator) 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? |
ivan (administrator) 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. |
![]() |
|||
Date Modified | Username | Field | Change |
2009-08-19 11:21 | paulh | New Issue | |
2009-08-19 11:42 | ivan | Note Added: 0001780 | |
2010-02-20 19:59 | ivan | Status | new => confirmed |
2010-02-20 20:00 | ivan | Target Version | => 4.0 |
2010-09-26 18:54 | paulh | Relationship added | related to 0001403 |
2011-02-14 13:25 | ivan | Target Version | 4.0 => 3.90beta1 |
2011-05-27 20:07 | paulh | Assigned To | => paulh |
2011-05-27 20:07 | paulh | Status | confirmed => assigned |
2011-06-03 22:49 | ivan | Severity | minor => tweak |
2011-06-06 19:20 | paulh | Note Added: 0003871 | |
2011-06-06 19:20 | paulh | Fixed in Version | => Current GIT |
2011-06-06 19:25 | paulh | Status | assigned => resolved |
2011-06-06 19:25 | paulh | Resolution | open => fixed |
2011-06-07 09:01 | ivan | Note Added: 0003874 | |
2011-06-07 19:09 | paulh | Note Added: 0003880 | |
2011-06-07 19:25 | ivan | Note Added: 0003883 | |
2011-07-02 20:08 | Tomse | Relationship added | related to 0001635 |
Copyright © 2000 - 2021 MantisBT Team |