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

Submitted by:  None
Submitted on:  Thu 14 Aug 2003 07:51:59 PM UTC  
 
Item Group: 0.9.16 pre RCCategory: API - phpGroupware API
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: SVNOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned 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

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 2 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sat 06 Mar 2010 02:24:52 AM UTCskwashdAssigned toskwashd=>None
    Fri 29 Aug 2003 05:24:33 AM UTCskwashdAssigned toNone=>NA

    Back to the top


    Powered by Savane 3.1-cleanup1