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] Best Wishes, Chris Travers On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > > > > > Ok, testing in 1.2.0rc4 > > > > > > > > On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: > > > > > Chris, > > > > > > > > > > I am running > > > > > Version 1.2.0 Release Candidate 1 > > > > > > > > > > Thanks, > > > > > Matt > > > > > > > > > > > > > > > > > > > > On 3/15/07, Chris Travers < [EMAIL PROTECTED]> wrote: > > > > > > Hi Matt; > > > > > > Which version are you running? > > > > > > > > > > > > Best Wishes, > > > > > > Chris Travers > > > > > > > > > > > > On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> 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 < > > > > > > > [EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > > > > 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 > > > > > > > > [email protected] > > > > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > [email protected] > > > > > > > > > > > > > > > > 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 > > > > > > [email protected] > > > > > > > > > > > > > > > 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 > > > > > [email protected] > > > > > > > > > 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 > > > > [email protected] > > > > > > > > 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 > > > [email protected] > > > > 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 > > [email protected] > > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
