sql-ledger-users

[SL] upgrade problem

[Adrian B. <adr...@ie...>]

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

[SL] upgrade problem

[JMC S. <in...@jm...>]

Hi

Having trouble upgrading 2.6.27 to 2.8.5

I keep getting errors

*create table cargo (id int not null, trans_id int not null, package
text, netweight float4, grossweight float4, volume float4)
ERROR: relation "cargo" already exists

*I drop the table and goto a few more of the same errors droping tables
br, vr, etc

Anybody got this upgrade to work and how did they do it.

Any help appreciated.

Joe*
*

Re: [SL] upgrade problem

[Bob G. <bo...@rc...>]

Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
2.8.5 to 2.8.6) you would have better results.

(Those versions are just for example - they may not be the best, or even
available..)

On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> Hi
> 
> Having trouble upgrading 2.6.27 to 2.8.5
> 
> I keep getting errors
> 
> *create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: relation "cargo" already exists
> 
> *I drop the table and goto a few more of the same errors droping tables
> br, vr, etc
> 
> Anybody got this upgrade to work and how did they do it.
> 
> Any help appreciated.
> 
> Joe*
> *
> 
> -------------------------------------------------------------------------
> 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

Re: [SL] upgrade problem

[Chad J. [L. Consultants] <ch...@lj...>]

I agree that this would be the right solution to this type of problem. I
would also follow this upgrade path if there was place that I could download
the missing versions, since my last upgrade. Is there an archive of all
versions somewhere that is accessible.



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Bob
Gustafson
Sent: 19 July 2007 08:57 AM
To: sql...@li...
Subject: Re: [SL] upgrade problem

Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
2.8.5 to 2.8.6) you would have better results.

(Those versions are just for example - they may not be the best, or even
available..)

On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> Hi
> 
> Having trouble upgrading 2.6.27 to 2.8.5
> 
> I keep getting errors
> 
> *create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: relation "cargo" already exists
> 
> *I drop the table and goto a few more of the same errors droping tables
> br, vr, etc
> 
> Anybody got this upgrade to work and how did they do it.
> 
> Any help appreciated.
> 
> Joe*
> *
> 
> -------------------------------------------------------------------------
> 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

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

Re: [SL] upgrade problem

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

There's documentation on it somewhere...I think perhaps you replace
the url of current d/l with the version number you're trying to get.
However, I'm not quite sure what this will help with since it runs the
same upgrade scripts either way.  IIRC, there is something borked on a
some of these upgrades and it either requires editing the script(s),
or the db.

On 7/23/07, Chad Jackson [LJNet Consultants] <ch...@lj...> wrote:
> I agree that this would be the right solution to this type of problem. I
> would also follow this upgrade path if there was place that I could download
> the missing versions, since my last upgrade. Is there an archive of all
> versions somewhere that is accessible.
>
>
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Bob
> Gustafson
> Sent: 19 July 2007 08:57 AM
> To: sql...@li...
> Subject: Re: [SL] upgrade problem
>
> Maybe if you take small update steps (i.e., 2.6.27 to 2.7.1 to 2.8.1 to
> 2.8.5 to 2.8.6) you would have better results.
>
> (Those versions are just for example - they may not be the best, or even
> available..)
>
> On Tue, 2007-07-17 at 13:57 +0100, JMC SOFTWARE wrote:
> > Hi
> >
> > Having trouble upgrading 2.6.27 to 2.8.5
> >
> > I keep getting errors
> >
> > *create table cargo (id int not null, trans_id int not null, package
> > text, netweight float4, grossweight float4, volume float4)
> > ERROR: relation "cargo" already exists
> >
> > *I drop the table and goto a few more of the same errors droping tables
> > br, vr, etc
> >
> > Anybody got this upgrade to work and how did they do it.
> >
> > Any help appreciated.
> >
> > Joe*
> > *
> >
> > -------------------------------------------------------------------------
> > 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
>
> -------------------------------------------------------------------------
> 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
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

Re: [SL] upgrade problem

[Paul T. <pt...@wa...>]

Adam Vande More schreef:
> There's documentation on it somewhere...I think perhaps you replace
> the url of current d/l with the version number you're trying to get.
> However, I'm not quite sure what this will help with since it runs the
> same upgrade scripts either way.  IIRC, there is something borked on a
> some of these upgrades and it either requires editing the script(s),
> or the db.
>   
How about reading the docs in the download itself?
There are upgrade insructions on the download page of SQL-Ledger.

*Upgrading from any version > 1.2.7 to the latest version* Upgrading is 
easy. Load setup.pl from the sql-ledger root directory and select 
Upgrade. The script will lock everyone out and install the new code over 
top. The only thing left to do is to log in to upgrade a dataset.

To upgrade manually load admin.pl and Lock the system. Download the new 
code and untar over top and fix the permissions according to the UPGRADE 
<http://www.sql-ledger.com/source/upgrade/> file in the doc directory. 
Most of the time there is nothing else to be done. Load admin.pl and 
Unlock the system. When a user logs in the Dataset is upgraded 
automatically, you do not have to do anything. If other steps are 
required, i.e template modifications, they will be listed in the UPGRADE 
file.
You *DO NOT* have to install intermediate versions to upgrade to the 
latest version! Intermediate upgrades are done for you.


Almost foolproof it would seem?

Re: [SL] upgrade problem

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

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
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

Re: [SL] upgrade problem & solved

[Adrian B. <adr...@ie...>]

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

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