On Thu, Feb 16, 2012 at 3:16 AM, Linda Ursin <li...@heksebua.com> 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: 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
>
>
------------------------------------------------------------------------------
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
