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

[nobody]

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

Changes by: Dave Hall <address@hidden>
Date: Fri 08/29/03 at 15:24 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | skwashd




=================== BUG #4745: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Fri 08/15/03 at 05:51
Category:  API - phpGWapi             Bug Group:  0.9.16 pre RC             
Severity:  5 - Major                  Priority:  Immediate                  
Resolution:  None                     Assigned to:  skwashd                 
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/