[Phpgroupware-tracker] [Bug #3056] PGSQL errors after upgrade; database not recognized by app after upgrade

[nobody]

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

Changes by: Ralf Becker <address@hidden>
Date: Thu 04/03/2003 at 11:35 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Category | None                      | API - Setup
          Resolution | None                      | Fixed
         Assigned to | None                      | ralfbecker
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This problem is solved in 0.9.16. I fixed it for 0.9.14.002 by commenting out 
the transaction's. Please update from cvs (within the Version-0_9_14-branch):
cd /path/to/phpgroupware
cvs update

or locate the transaction start and end statements and comment them out by 
putting 2 slashes in front of the lines 55 and 138.



=================== BUG #3056: FULL BUG SNAPSHOT ===================


Submitted by: fredbox                 Project: phpGroupWare                 
Submitted on: Wed 04/02/2003 at 22:06
Category:  API - Setup                Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  High                       
Resolution:  Fixed                    Assigned to:  ralfbecker              
Status:  Closed                       Component Version:  CVS               
Platform Version:  BSD                Reproducibility:  Every Time          

Summary:  PGSQL errors after upgrade; database not recognized by app after 
upgrade

Original Submission:  Having cvs'd to 0.9.14.002 and upgraded the database thru 
setup, any attempt to log in causes pgsql to throw an error and the login 
screen to claim the database is not created.

pgsql error: 
ERROR:  Cannot insert a duplicate key into unique index lang_pkey
ERROR:  current transaction is aborted, queries ignored until end of 
transaction block

php gw message:
Fatal Error: It appears that you have not created the database tables for 
phpGroupWare. Click here to run setup.

This is after the database was upgraded from 0.9.14.001 to 0.9.14.002.

The setup sometimes correctly recognizes the database and application versions, 
sometimes claims  Your Database is not working!
Make sure that your database is created and the account permissions are set.

I have dumped and reloaded the database contents with the same results.

FreeBSD-4.7 in a chrooted virtual host
Apache-2.0.44
PHP-4.3.1
postgresql-7.3.2

Follow-up Comments
*******************

-------------------------------------------------------
Date: Thu 04/03/2003 at 11:35       By: ralfbecker
This problem is solved in 0.9.16. I fixed it for 0.9.14.002 by commenting out 
the transaction's. Please update from cvs (within the Version-0_9_14-branch):
cd /path/to/phpgroupware
cvs update

or locate the transaction start and end statements and comment them out by 
putting 2 slashes in front of the lines 55 and 138.


CC list is empty


No files currently attached


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