From: Armaghan S. <sa...@le...> - 2008-01-10 05:17:07
|
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/ |