sql-ledger-users

[SL] Upgrade dataset error

[Reverso <re...@o2...>]

I'm trying upgrade backup of my accounting data (I don't remember SL
version) to the latest version (2.8.20)

Routine:
1. run admin.pl and log in
2. select my Pg Database Administration
3. insert database data and click Update Dataset
4. select my dataset and click Continue
5. got Internal Server Error

There is relevant apache error.log below:

Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1257., 
referer: http://omnibook/sql-ledger/admin.pl
Compilation failed in require at /usr/share/sql-ledger/admin.pl line 
85., referer: http://omnibook/sql-ledger/admin.pl
Premature end of script headers: admin.pl, referer: 
http://omnibook/sql-ledger/admin.pl

I try on another system (mac). The result is the same.

Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1256., 
referer: http://localhost/sql-ledger/admin.pl
Compilation failed in require at 
/Library/WebServer/Documents/sql-ledger/admin.pl line 84., referer: 
http://localhost/sql-ledger
/admin.pl
Premature end of script headers: admin.pl, referer: 
http://localhost/sql-ledger/admin.pl

Any ideas how to cope with that?

Re: [SL] Upgrade dataset error

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

The version of the backup data is mostly in the name of the backup file.
Like companyname-2.8.14-2008-12-31.sql.gz

Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
and run those on the database before opening admin.pl

Should do the trick.

2009/1/31 Reverso <re...@o2...>

> I'm trying upgrade backup of my accounting data (I don't remember SL
> version) to the latest version (2.8.20)
>
> Routine:
> 1. run admin.pl and log in
> 2. select my Pg Database Administration
> 3. insert database data and click Update Dataset
> 4. select my dataset and click Continue
> 5. got Internal Server Error
>
> There is relevant apache error.log below:
>
> Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1257.,
> referer: http://omnibook/sql-ledger/admin.pl
> Compilation failed in require at /usr/share/sql-ledger/admin.pl line
> 85., referer: http://omnibook/sql-ledger/admin.pl
> Premature end of script headers: admin.pl, referer:
> http://omnibook/sql-ledger/admin.pl
>
> I try on another system (mac). The result is the same.
>
> Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1256.,
> referer: http://localhost/sql-ledger/admin.pl
> Compilation failed in require at
> /Library/WebServer/Documents/sql-ledger/admin.pl line 84., referer:
> http://localhost/sql-ledger
> /admin.pl <http://localhost/sql-ledger%0A/admin.pl>
> Premature end of script headers: admin.pl, referer:
> http://localhost/sql-ledger/admin.pl
>
> Any ideas how to cope with that?
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Upgrade dataset error

[Reverso <re...@o2...>]

Paul Tammes pisze:
> The version of the backup data is mostly in the name of the backup file.
> Like companyname-2.8.14-2008-12-31.sql.gz
> 
> Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
> and run those on the database before opening admin.pl

Unfortunately my backup name in not self explained. Just "data.sql"
Maybe is there a version information in tables?

Re: [SL] Upgrade dataset error

[Wallace R. C. <wrc...@gm...>]

On Sun, Feb 1, 2009 at 2:40 AM, Reverso <re...@o2...> wrote:
> Paul Tammes pisze:
>> The version of the backup data is mostly in the name of the backup file.
>> Like companyname-2.8.14-2008-12-31.sql.gz
>>
>> Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
>> and run those on the database before opening admin.pl
>
> Unfortunately my backup name in not self explained. Just "data.sql"
> Maybe is there a version information in tables?

Check the comments at the very beginning of your data.sql file.

-- 
Best Regards,
Wallace

Re: [SL] Upgrade dataset error - SOLVED

[Reverso <re...@o2...>]

Wallace Roberts Consulting pisze:

> 
> Check the comments at the very beginning of your data.sql file.
> 

Not so easy :-)
My backup was done out of sql-ledger mechanizm.

But ... the dataset version number was in table: defaults (field: version)
Then, as Paul wrote, I applied apropriate sql scripts and that's all.

Thanks guys

Re: [SL] Upgrade dataset error

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

Open it with a text editor like Kate ,notepad or whatrever, it will say
something in or just below line one iirc

2009/2/1 Reverso <re...@o2...>

> Paul Tammes pisze:
> > The version of the backup data is mostly in the name of the backup file.
> > Like companyname-2.8.14-2008-12-31.sql.gz
> >
> > Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
> > and run those on the database before opening admin.pl
>
> Unfortunately my backup name in not self explained. Just "data.sql"
> Maybe is there a version information in tables?
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>