--- Begin Message ---
|
Subject: |
[Bug #3056] PGSQL errors after upgrade; database not recognized by app after upgrade |
|
Date: |
Thu, 03 Apr 2003 04:35:17 -0500 |
=================== 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
--- End Message ---