Re: [SL] upgrade problem & solved

[Adam V. M. <amv...@gm...>]

Yes, and the upgrade docs say you must unlock again if you see that error
after attempting to login.  There is a more detailed explanation on the
forum, and perhaps in the mailing list archive.  Suffice it to say there is
a reason, and it's not supposed to happen again (except for the scenario I
stated earlier).

On 6/6/07, Adrian Blake <adr...@ie...> wrote:
>
> Thanks,
>
> I did unlock before login but the process must have locked again and thus
> required a second unlock operation.
>
> This does not explain the error.
>
> All appears to be working now.
>
> Adam Vande More wrote:
> > Read the upgrade docs.  You must unlock the system again.  As an
> additional
> > note, you'll have to repeat this process for every dataset you have.
> >
> > On 6/6/07, Adrian Blake <adr...@ie...> wrote:
> >> I just upgraded from 2.8.2 to 2.8.5, then login ->  Upgrading   then an
> >> error, " dropped trigger .....??..." Tried to login again,
> >> error message " Login disabled!"
> >>
> >> from httpd/error.log
> >>
> >> [Thu Jun 07 09:19:28 2007] [error] [client 127.0.0.1] DBD::Pg::st
> execute
> >> failed: ERROR:  trigger "del_recurring" for table "oe"
> >> does not exist, referer: http://localhost/sql-ledger/login.pl
> >> [root@adios httpd]#
> >>
> >> Sadness
> >>
> >>
> >> Adrian
> >> --
> >> Adrian Blake
> >> Molonglo Radio Observatory
> >> University of Sydney
> >> 1152 Hoskinstown Rd
> >> Bungendore 2621
> >> ph. 02 80042212  mobile 0407 232 978
> >>
> >> http://150.101.125.30/pics
> >>
> >>
> -------------------------------------------------------------------------
> >> This SF.net email is sponsored by DB2 Express
> >> Download DB2 Express C - the FREE version of DB2 express and take
> >> control of your XML. No limits. Just data. Click to get it now.
> >> http://sourceforge.net/powerbar/db2/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >
> >
> >
>
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>
> http://150.101.125.30/pics
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales