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.
Linda
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvang www: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Thu, Feb 16, 2012 at 11:38 AM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>
> On Wed, Feb 15, 2012 at 11:25 PM, Linda Ursin <li...@heksebua.com> 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: li...@heksebua.com
>>
>> Org: NO 995 578 107
>>
>>
>> On Thu, Feb 16, 2012 at 12:54 AM, Chris Travers
>> <chris.trav...@gmail.com>wrote:
>>
>>>
>>>
>>> On Wed, Feb 15, 2012 at 8:35 AM, Linda Ursin <li...@heksebua.com> wrote:
>>>
>>>> Finally found it. When I ran it I got this:
>>>>
>>>> postgres@lur:/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
>>> Ledger-smb-users@lists.sourceforge.net
>>> 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
>> Ledger-smb-users@lists.sourceforge.net
>> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
