phpGroupWare - 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: |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
Carbon-Copy List
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 to | skwashd | None | |
2003-08-29 | skwashd | Assigned to | None | None |
Powered by Savane 3.13-02a9.
Corresponding source code
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