bugphpGroupWare - Bugs: bug #4745, install on postgresql 7.3.2...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #4745: install on postgresql 7.3.2 defaults to columns set to NOT NULL unless specified

Submitter:  None
Submitted:  Thu 14 Aug 2003 07:51:59 PM UTC
   
 
Category:  API - phpGroupware API Item Group:  0.9.16 pre RC
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  None Open/Closed:  Open
Component Version:  SVN Operating System:  GNU/Linux - RedHat/Fedora
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Thu 14 Aug 2003 07:51:59 PM UTC, 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



Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by skwashd (Updated the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2010-03-06 skwashd Assigned toskwashd None
    2003-08-29 skwashd Assigned toNone None

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code