postgres=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres
public | postgres
(5 rows)
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
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:31 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>
> 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
>
>
------------------------------------------------------------------------------
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
