bugphpGroupWare - Bugs: bug #3056, PGSQL errors after upgrade;...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #3056: PGSQL errors after upgrade; database not recognized by app after upgrade

Submitted by:  Frederick J Polsky v1.0 <fredbox>
Submitted on:  Wed 02 Apr 2003 08:06:57 PM UTC  
 
Item Group: 0.9.14.002 releaseCategory: API - Setup
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Invalid User ID <Invalid User ID>Open/Closed: Closed
Component Version: SVNOperating System: *BSD
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Wed 02 Apr 2003 08:06:57 PM UTC, 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

Frederick J Polsky v1.0 <fredbox>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

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):

 

 

No Changes Have Been Made to This Item

Back to the top


Powered by Savane 3.1-cleanup1