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

[nobody]

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

Submitted by: fredbox                 Project: phpGroupWare                 
Submitted on: Wed 04/02/03 at 11:06
Category:  None                       Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  None                    
Status:  Open                         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



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=3056&group_id=509