In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
909 [In-Portal CMS] Data Management bug report always 2010-10-29 11:22 2010-11-30 12:48
Dmitry  
alex  
normal  
closed 5.1.1-B2  
fixed  
 
none 5.1.1-RC1  
http://groups.google.com/group/in-portal-dev/browse_thread/thread/3492f22f4dd92e88
Corrections in PortalUser table fields
0
0000909: Corrections in PortalUser table fields
Corrections in PortalUser table fields:

1. Increase the length of Phone and City DB fields for User prefix.

Currently pone field is 20 characters, while it's 255 for Fax. 255 makes more sense because, for example, 555-555-5555 ext. 555 phone number doesn't fit.

2. Adjust field types and NULL state based on todays rules:

When NULL value has special meaning and it's not the same as empty string
for code using it, then NOT NULL should be used.

This minor bug should be applied to 5.1.1 RC1 in order to escape issues with code conflicts in Upgrades.sql possible if patch is left for future releases.
patch Corrections-in-PortalUser-table-fields.patch (7,318) 2010-10-29 13:29
http://tracker.in-portal.org/file_download.php?file_id=824&type=bug
Issue History
2010-11-30 12:48 Dmitry Note Added: 0003003
2010-11-30 12:48 Dmitry Status resolved => closed
2010-11-01 15:48 alex Note Added: 0002947
2010-11-01 15:48 alex Status reviewed and tested => resolved
2010-11-01 15:48 alex Fixed in Version => 5.1.1-RC1
2010-11-01 15:48 alex Resolution open => fixed
2010-11-01 15:48 alex Assigned To !COMMUNITY => alex
2010-11-01 15:48 alex Changeset attached 5.1.x r14029
2010-11-01 15:47 alex Note Added: 0002946
2010-11-01 15:47 alex Assigned To alex => !COMMUNITY
2010-11-01 15:47 alex Status needs testing => reviewed and tested
2010-10-31 10:45 Dmitry Note Added: 0002931
2010-10-31 10:45 Dmitry Assigned To !COMMUNITY => alex
2010-10-29 13:48 Dmitry Assigned To Dmitry => !COMMUNITY
2010-10-29 13:47 Dmitry Status needs work => needs testing
2010-10-29 13:47 Dmitry Status needs testing => needs work
2010-10-29 13:47 Dmitry Assigned To !COMMUNITY => Dmitry
2010-10-29 13:29 Dmitry Note Added: 0002929
2010-10-29 13:29 Dmitry Assigned To Dmitry => !COMMUNITY
2010-10-29 13:29 Dmitry Developer => Dmitry
2010-10-29 13:29 Dmitry Status needs work => needs testing
2010-10-29 13:29 Dmitry File Added: Corrections-in-PortalUser-table-fields.patch
2010-10-29 13:27 Dmitry Change Log Message Increased length of Phone and City DB fields for User prefix => Corrections in PortalUser table fields
2010-10-29 13:27 Dmitry Assigned To => Dmitry
2010-10-29 13:27 Dmitry Status active => needs work
2010-10-29 13:27 Dmitry Summary Increase length of Phone and City DB fields for User prefix => Corrections in PortalUser table fields
2010-10-29 13:27 Dmitry Description Updated bug_revision_view_page.php?rev_id=593#r593
2010-10-29 11:22 Dmitry New Issue
2010-10-29 11:22 Dmitry Reference => http://groups.google.com/group/in-portal-dev/browse_thread/thread/3492f22f4dd92e88
2010-10-29 11:22 Dmitry Change Log Message => Increased length of Phone and City DB fields for User prefix

Notes
(0002929)
Dmitry   
2010-10-29 13:29   
Please review and test.
(0002931)
Dmitry   
2010-10-31 10:45   
Reminder sent to: alex

Please test when you have a chance.
(0002946)
alex   
2010-11-01 15:47   
ok
(0002947)
alex   
2010-11-01 15:48   
Fix committed to 5.1.x branch. Commit Message:

1. Fixes 0000909: Corrections in PortalUser table fields
2. Commit on behalf of Dmitry
(0003003)
Dmitry   
2010-11-30 12:48   
Closing released 5.1.1 task.