[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Ugh...deleting a Vendor Invoice



I must be cursed:

..hidden..:/home/mythtv$ psql -U ledger-smb ledger-smb
Welcome to psql 8.1.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

ledger-smb=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
ERROR:  relation "defaults" does not exist


..hidden..:/home/mythtv$ psql -U postgres ledger-smb
Welcome to psql 8.1.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

ledger-smb=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
ERROR:  relation "defaults" does not exist


Any ideas? I thought I named my dataset ledger-smb and my username was ledger-smb...that is what I used thru the install process...

- Matt


On 3/15/07, Joshua D. Drake <..hidden..> wrote:
Chris Travers wrote:
> You are not connected to the right database ;-) The prompt below
> suggests you omitted the dbname and connected to the "postgres"
> database.
>
> psql -U postgres [dbname]

psql -U postgres [dataset name] :)

J


>
> Best Wishes,
> Chris Travers
>
> On 3/15/07, Matt Jackson <..hidden.. > wrote:
>> Chris,
>>
>> Tried it and got:
>>
>> postgres=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
>> ERROR:  relation "defaults" does not exist
>>
>> Any idea why?
>>
>> - Matt
>>
>>
>>
>> On 3/15/07, Chris Travers <..hidden..> wrote:
>>> In 1.2.0rc4, the problem does not appear to occur.  It may be a but
>>> with saving the appropriate setting (this part of the software got
>>> some serious work done on it in 1.2).  If you are using the debian
>>> package, we expect to have an rc4 package available soon. otherwise,
>>> you can upgrade and see if the problem goes away.
>>>
>>> Otherwise you may try (in psql):
>>> UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
>>>
>>> Best Wishes,
>>> Chris Travers
>>>
>>>
>>> On 3/15/07, Matt Jackson <..hidden.. > wrote:
>>>> Will be interested to see what you find. Everything else seems to work
>> fine.
>>>> So frustrating not being able to delete an invoice lol, especially for
>>>> someone learning. :)
>>>>
>>>> Thanks!!
>>>>
>>>> - Matt
>>>>
>>>>
>>>>
>>>>
>>>>  On 3/15/07, Chris Travers < ..hidden..> wrote:
>>>>> Ok, testing in 1.2.0rc4
>>>>>
>>>>> On 3/15/07, Matt Jackson < ..hidden..> wrote:
>>>>>> Chris,
>>>>>>
>>>>>> I am running
>>>>>> Version 1.2.0 Release Candidate 1
>>>>>>
>>>>>> Thanks,
>>>>>> Matt
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 3/15/07, Chris Travers < ..hidden..> wrote:
>>>>>>> Hi Matt;
>>>>>>> Which version are you running?
>>>>>>>
>>>>>>> Best Wishes,
>>>>>>> Chris Travers
>>>>>>>
>>>>>>> On 3/15/07, Matt Jackson <..hidden..> wrote:
>>>>>>>> Hmmm!
>>>>>>>>
>>>>>>>> When I try to set "Enforce Transaction Reversals for all dates"
>> to
>>>> "No,"
>>>>>> it
>>>>>>>> just pops back to Yes when I check it again...it doesn't stay
>> set!
>>>>>> However,
>>>>>>>> when I switch Activate Audit Trail to Yes or No, those stick!
>>>>>>>>
>>>>>>>> lol...that seems to be my problem...any idea on how to fix that?
>>>>>>>>
>>>>>>>> - Matt
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 3/15/07, Ashley J Gittins <
>>>>>>>> ..hidden..> wrote:
>>>>>>>>> On Thu, 15 Mar 2007, Matt Jackson wrote:
>>>>>>>>>> All I see on my buttons is "Post as New" which then
>> duplicates
>>>> it
>>>>>>>> modified
>>>>>>>>>> in the system.
>>>>>>>>>>
>>>>>>>>>> Any ideas?
>>>>>>>>> Hi Matt,
>>>>>>>>>         If you have reversal enforced (system menu I think)
>> then
>>>> there
>>>>>>>> will be
>>>>>>>>> a "delete" button at the bottom.
>>>>>>>>>
>>>>>>>>> To do a reversal, open the original invoice, change the qty's
>> and
>>>>>> invoice
>>>>>>>>> number as described, update (always update if in doubt) then
>> "post
>>>> as
>>>>>>>> new".
>>>>>>>>> --
>>>>>>>>> Regards,
>>>>>>>>>         Ashley J Gittins
>>>>>>>>>         web:
>> http://www.purple.dropbear.id.au
>>>>>>>>>         jabber: ..hidden..
>>>>>>>>>
>>>>>>>>>
>> -------------------------------------------------------------------------
>>>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>>>>>>> Join SourceForge.net's Techsay panel and you'll get the chance
>> to
>>>>>> share
>>>>>>>> your
>>>>>>>>> opinions on IT & business topics through brief surveys-and
>> earn
>>>> cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>>>>>>>>> Ledger-smb-users mailing list
>>>>>>>>> ..hidden..
>>>>>>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Matt
>>>>>>>>
>> -------------------------------------------------------------------------
>>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>>>>>> Join SourceForge.net 's Techsay panel and you'll get the chance
>> to
>>>> share
>>>>>> your
>>>>>>>> opinions on IT & business topics through brief surveys-and earn
>> cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>>>>>> _______________________________________________
>>>>>>>> Ledger-smb-users mailing list
>>>>>>>> ..hidden..
>>>>>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>>>>>
>>>>>>>
>> -------------------------------------------------------------------------
>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>>>>> Join SourceForge.net's Techsay panel and you'll get the chance to
>>>> share
>>>>>> your
>>>>>>> opinions on IT & business topics through brief surveys-and earn
>> cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>>>>> _______________________________________________
>>>>>>> Ledger-smb-users mailing list
>>>>>>> ..hidden..
>>>>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Matt
>>>>>>
>> -------------------------------------------------------------------------
>>>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>>>> Join SourceForge.net 's Techsay panel and you'll get the chance to
>> share
>>>> your
>>>>>> opinions on IT & business topics through brief surveys-and earn cash
>>>>>>
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>>>> _______________________________________________
>>>>>> Ledger-smb-users mailing list
>>>>>> ..hidden..
>>>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>>>
>>>>>
>> -------------------------------------------------------------------------
>>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>>> Join SourceForge.net's Techsay panel and you'll get the chance to
>> share
>>>> your
>>>>> opinions on IT & business topics through brief surveys-and earn cash
>>>>>
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>>> _______________________________________________
>>>>> Ledger-smb-users mailing list
>>>>> ..hidden..
>>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Matt
>>>>
>> -------------------------------------------------------------------------
>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>> Join SourceForge.net 's Techsay panel and you'll get the chance to share
>> your
>>>> opinions on IT & business topics through brief surveys-and earn cash
>>>>
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>> _______________________________________________
>>>> Ledger-smb-users mailing list
>>>> ..hidden..
>>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>
>>>
>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>>
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> Ledger-smb-users mailing list
>>> ..hidden..
>>>
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>> --
>> Regards,
>> Matt
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Ledger-smb-users mailing list
>> ..hidden..
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Regards,
Matt