[Phpgroupware-tracker] [bug #4745] install on postgresql 7.3.2 defaults to columns set to NOT NULL unless specified

[nobody]

=================== BUG #4745: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=4745&group_id=509

Submitted by: None                    Project: phpGroupWare                 
Submitted on: Thu 08/14/2003 at 15:51
Category:  API - phpGWapi             Bug Group:  0.9.16 pre RC             
Severity:  5 - Major                  Priority:  Immediate                  
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  install on postgresql 7.3.2 defaults to columns set to NOT NULL 
unless specified

Original Submission:  I got errors related to the columns in phpgw_accounts as 
specified in function phpgwapi_upgrade0_9_13_005() within 
phpgwapi/setup/tables.update.inc.php from these columns:
'account_permissions' => array('type' => 'text'),
                                'account_groups' => array('type' => 'varchar', 
'precision' => 30),
                                'account_lastlogin' => array('type' => 'int', 
'precision' => 4),
                                'account_lastloginfrom' => array('type' => 
'varchar', 'precision' => 255),
                                'account_lastpwd_change' => array('type' => 
'int', 'precision' => 4),

Errors were encountered when creating admin and demo accounts on totally new 
.16 install from cvs

Errors were fixed by doing:
ALTER TABLE phpgw_accounts ALTER COLUMN account_permissions DROP NOT NULL;
ALTER TABLE phpgw_accounts ALTER COLUMN account_groups DROP NOT NULL;
ALTER TABLE phpgw_accounts ALTER COLUMN account_lastlogin DROP NOT NULL;
ALTER TABLE phpgw_accounts ALTER COLUMN account_lastloginfrom DROP NOT NULL;
ALTER TABLE phpgw_accounts ALTER COLUMN account_lastpwd_change DROP NOT NULL;

Must be code somewhere that creates unspecified columns as NOT NULL






No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=4745&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/