From: Armaghan S. <sa...@le...> - 2008-01-13 10:53:22
|
Luke wrote: > When I am logged into admin.pl, and I attempt to add or delete a user, > the http connection hangs until it times out (several minutes), and I > am presented with a 500 internal server error. > > The Apache2 logs say nothing. I have tried Postgresql versions 8.2 > and 8.1. > Are other things working fine? Can you login and run the application using previously created users etc. > I recently upgraded from 2.6.8, by doing a progressive upgrade through > the intermediary versions. > > While doing this, I ran into an error about a missing function which > the upgrade script was trying to drop. Several of them actually, as I > removed one from the SQL file, another would come up. Same for some > other attempts to drop triggers, a problem which the lock/unlock > solution wouldn't solve. The upgrade was seemingly successful after I > removed the things that had already been dropped. > > I don't know if this is some how causing my problem now, but any > advice would be appreciated. This missing procedures error can be some upgrade bug and can be ignored in my experience. The latest sql-ledger version does not install/use server side procedures (like procedures and triggers). Everything is now handled through the application. (so you dont need plpgsql in the database now). Regards -- Armaghan Saqib SQL-Ledger Hosting - Reliable, fast, secure http://www.ledger123.com/ |