Re: Upgrade problem

On Thu, Feb 16, 2012 at 12:31 PM, Chris Travers <..hidden..> wrote:

On Thu, Feb 16, 2012 at 3:16 AM, Linda Ursin <..hidden..> wrote:
Hi

There's nothing from that time in the postgresql log.

postgres=# \dt defaults
No matching relations found.
postgres=# \dt users
No matching relations found.

postgres=# \dt users_conf
No matching relations found.

Ok, so:

\dn

Best Wishes,
Chris Travers

Linda

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse: Tlf:    (+47) 402 40 767
Solvang www:    http://heksebua.com
7288 Soknedal E-post: ..hidden..

Org: NO 995 578 107

On Thu, Feb 16, 2012 at 11:38 AM, Chris Travers <..hidden..> wrote:

On Wed, Feb 15, 2012 at 11:25 PM, Linda Ursin <..hidden..> wrote:
Hi

So the data has been moved back now?

It suggests that it was.

Can you check your PostgreSQL log as well?

In the mean time, also log into your db in psql and:

\dt defaults
\dt users
\dt users_conf

Best Wishes,
Chris Travers

There are no more lines for the specific time in the error log.

[Thu Feb 16 08:53:05 2012] [error] [client 193.69.154.79] Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/share/perl5/Class/Std.pm line 523., referer: http://lur.aitel.hist.no/regnskap/login.pl

[Thu Feb 16 08:53:05 2012] [error] [client 193.69.154.79] Can't call method "prepare" on an undefined value at LedgerSMB/User.pm line 51., referer: http://lur.aitel.hist.no/regnskap/login.pl

[Thu Feb 16 08:53:05 2012] [error] [client 193.69.154.79] Compilation failed in require at /usr/share/ledgersmb/login.pl line 92., referer: http://lur.aitel.hist.no/regnskap/login.pl

[Thu Feb 16 08:53:05 2012] [error] [client 193.69.154.79] Premature end of script headers: login.pl, referer: http://lur.aitel.hist.no/regnskap/login.pl

Linda

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse: Tlf:    (+47) 402 40 767
Solvang www:    http://heksebua.com
7288 Soknedal E-post: ..hidden..

Org: NO 995 578 107

On Thu, Feb 16, 2012 at 12:54 AM, Chris Travers <..hidden..> wrote:

On Wed, Feb 15, 2012 at 8:35 AM, Linda Ursin <..hidden..> wrote:
Finally found it. When I ran it I got this:

..hidden..:/home/lur/ledgersmb/sql/upgrade$ psql heksebua < /home/lur/ledgersmb/sql/upgrade/1.3-1.2.sql
BEGIN
ALTER SCHEMA

ALTER SCHEMA
COMMIT
BEGIN
ERROR: column "entity_id" of relation "vendor" does not exist
ERROR: current transaction is aborted, commands ignored until end of transaction block

ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block

ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ROLLBACK

Does any of this matter?

Ok, this is sounding like the entire upgrade failed with the exception of the moving of the old data out of the way. The commands are in the transactions they are to address that possibility. This should be ok at this point.

Regarding your 500 error, are there more log lines then that? That really sounds like a connection failure for some reason. 1.2 is supposed to throw an error "No GlobalDBH Configured or Could not Connect" when that connection fails. Can you double check and see if there are more log lines associated with this http request?

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users