sql-ledger-users — SQL-Ledger users

Re: Error message parser: parse error at or near "select" ** Help **

[Dieter S. <dsi...@sq...>]

You are using an old version of Postgres.

The requirements state that you need at least postgres 7.0


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 16 Jan 2002, JC Boursiquot wrote:

> Hello everyone,
> 
> I have installed everything but I seem to get parsing errors.  Here is the
> error I get:
> 
> Error!
> set DateStyle to SQL, US
> ERROR: parser: parse error at or near "sql"
> 
> I also got the following error when creating my dataset:
> 
> Error!
> insert into tax (chart_id,rate) values ((select id from chart where accno =
> 2310),0.07)
> 
> ERROR: parser: parse error at or near "select"
> 
> I am very new to Postgressql and can use any help I can receive.
> 
> Thanks in advance for your help.
> 
> 
> JC
> 
> 
> 
> 

Re: Error in AP Transaction

[Dieter S. <dsi...@sq...>]

This only happened when the date of payment was the same as the invoice
date and the amount paid was equal to the invoice amount.

There is a patch on the download page to fix this.
http://www.sql-ledger.org/source/

Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 16 Jan 2002, Peter Dabrowski wrote:

> Hi,
> I suspect that is error in posting in AP Transactions unless I do 
> something wrong.
> For example I want to record transaction and make payment of $500 and 22% 
> VAT
> Selected AP Transactions
> selected summary account
> filled the form , selected detail account and Tax account for 22% payable
> $500
> $110  22% VAT
> Filled lower fields for payment of $610  and selected chequing account
> After processing the transaction I end up in GL with entries:
> $610 Debit in summary account
> $500 Debit in detail account
> $110 Debit in Tax account
> $610 Credit in chequing account.
> 
> I've deleted transaction and redone it without payment
> later I made payment thru payment form and everything been posted 
> correctly
> 
> Later I tried to edit transaction just to check what's going to happen.
> I've open transaction and saved again without changing and everything was 
> reposted in the mane as in first example.

question regarding set up for rental items

[Ed W. <ew...@rh...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

We've been using sql ledger for over a year now and its truely been a stable 
and efficient accounting program.  My accounting knowledge is minimal but the 
program is simple enough to use and understand for all but one service we 
offer.  This question should probably be directed to an accountant, but I 
thought I'd give it a shot here first.

The question I have is regarding items we purchase from a vendor and then use 
as short-term rental merchandise to our customers.  Initially we had this set 
up (albeit incorrectly) by creating the vendor order and price, recieving the 
item and adding to our inventory, then billing the item out at the rental 
rate to our customers (most of the time its a daily rate below the original 
purchase price).  

The problem we are having is how do we add the item back into inventory 
without crediting the customer account once it is returned?

Thaks for Your time and help,
- -- 
Ed Wiget
Owner/Senior Network Security Consultant
RHP Studios
"Keeping Your Data Safe!"
http://www.rhpstudios.com
email: ew...@rh...
email2: sec...@rh...
Office: 606-564-0046
Toll Free: 866-G02-RHPS (866-402-7477)
Fax: 606-564-0076
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8RaE++EoLKxIs7PwRAmIxAJ4p03cVRwX9bhQc5ZN/ux22yZxsqACfQWFt
lAw9m5DyUKmKSJ7sSycxFrE=
=0c8z
-----END PGP SIGNATURE-----

Error message parser: parse error at or near "select" ** Help **

[JC B. <jc...@te...>]

Hello everyone,

I have installed everything but I seem to get parsing errors.  Here is the
error I get:

Error!
set DateStyle to SQL, US
ERROR: parser: parse error at or near "sql"

I also got the following error when creating my dataset:

Error!
insert into tax (chart_id,rate) values ((select id from chart where accno =
2310),0.07)

ERROR: parser: parse error at or near "select"

I am very new to Postgressql and can use any help I can receive.

Thanks in advance for your help.


JC

Error in AP Transaction

[Peter D. <mer...@ma...>]

Hi,
I suspect that is error in posting in AP Transactions unless I do=20
something wrong.
For example I want to record transaction and make payment of $500 and 22=
%=20
VAT
Selected AP Transactions
selected summary account
filled the form , selected detail account and Tax account for 22% payabl=
e
$500
$110  22% VAT
Filled lower fields for payment of $610  and selected chequing account
After processing the transaction I end up in GL with entries:
$610 Debit in summary account
$500 Debit in detail account
$110 Debit in Tax account
$610 Credit in chequing account.

I've deleted transaction and redone it without payment
later I made payment thru payment form and everything been posted=20
correctly

Later I tried to edit transaction just to check what's going to happen.=

I've open transaction and saved again without changing and everything wa=
s=20
reposted in the mane as in first example.

re: setup

[Peter J. P. <pjp...@sy...>]

Hi, 

Thanks for such a fast response. What I needed was to grant acces to tables 
which I did using pgacces. I got confused, because I couldn't do this with 
webmin.

Peter

Re: setup

[Sergio A. K. <ser...@ho...>]

----- Original Message -----
From: "Sergio A. Kessler" <ser...@ho...>


> iif 'apache' is the user under your web server run on:
>
> - login into your DB as postgres user
> - psql sql-ledger
> - grant all an apache to table1
> - grant all an apache to table1

duh!
"grant all on table to user"

> ...
>
> or
>
> indicate that the user connect as 'postgres' user
>
> /sergio
>
> ----- Original Message -----
> From: "Peter J. Pieczora" <pjp...@sy...>
>
>
> > Hi,
> >
> > I got it all up and running but when trying to setup accoutnts I get
> > following error
> > Error!
> >
> > SELECT accno,
> > SUM(acc_trans.amount) AS amount
> > FROM chart, acc_trans
> > WHERE chart.id = acc_trans.chart_id
> > GROUP BY accno
> > ERROR: chart: Permission denied.
> >
> > So, I guess, I have, or rather user under which webserver is running
have
> no
> > right permissions to access DB. Anyway I wonder how to get around it?
> >
> > Cheers,
> >
> > Peter
> >
> >
>
>

Re: setup

[Sergio A. K. <ser...@ho...>]

iif 'apache' is the user under your web server run on:

- login into your DB as postgres user
- psql sql-ledger
- grant all an apache to table1
- grant all an apache to table1
...

or

indicate that the user connect as 'postgres' user

/sergio

----- Original Message -----
From: "Peter J. Pieczora" <pjp...@sy...>


> Hi,
>
> I got it all up and running but when trying to setup accoutnts I get
> following error
> Error!
>
> SELECT accno,
> SUM(acc_trans.amount) AS amount
> FROM chart, acc_trans
> WHERE chart.id = acc_trans.chart_id
> GROUP BY accno
> ERROR: chart: Permission denied.
>
> So, I guess, I have, or rather user under which webserver is running have
no
> right permissions to access DB. Anyway I wonder how to get around it?
>
> Cheers,
>
> Peter
>
>

RE: setup

[Dan I. <da...@ja...>]

Perhaps you need to GRANT that user select priviliges? Soemthing like...

GRANT select ON chart TO user;

where user is the username of the postgresql user making the connection to
the db.

This can be done using the psql utility like this:


[root@host /root]# psql -d DBNAME -U postgres
Welcome to psql, the PostgreSQL interactive terminal.

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

partnership=# GRANT SELECT ON chart TO username;
CHANGE
partnership=#


You may wish to view
http://www.postgresql.org/idocs/index.php?sql-grant.html for more
information.

Hope this helps.

- Dan.


--
Dan Irwin - Systems Administrator
Jackie's Wholesale Nurseries Pty Ltd
Email: da...@ja...
Phone: 07 3888 2481
Fax: 07 3888 2530
Postal: 10 Gleeson Road Burpengary Queensland 4505
Email: in...@ja...
Web: http://www.jackies.com.au


> -----Original Message-----
> From: Peter J. Pieczora [mailto:pjp...@sy...]
> Sent: Wednesday, 16 January 2002 2:02 PM
> To: sql...@li...
> Subject: setup
> 
> 
> Hi, 
> 
> I got it all up and running but when trying to setup accoutnts I get 
> following error
> Error!
> 
> SELECT accno,
> SUM(acc_trans.amount) AS amount
> FROM chart, acc_trans
> WHERE chart.id = acc_trans.chart_id
> GROUP BY accno
> ERROR: chart: Permission denied. 
> 
> So, I guess, I have, or rather user under which webserver is 
> running have no 
> right permissions to access DB. Anyway I wonder how to get around it?
> 
> Cheers,
> 
> Peter
> 

setup

[Peter J. P. <pjp...@sy...>]

Hi, 

I got it all up and running but when trying to setup accoutnts I get 
following error
Error!

SELECT accno,
SUM(acc_trans.amount) AS amount
FROM chart, acc_trans
WHERE chart.id = acc_trans.chart_id
GROUP BY accno
ERROR: chart: Permission denied. 

So, I guess, I have, or rather user under which webserver is running have no 
right permissions to access DB. Anyway I wonder how to get around it?

Cheers,

Peter

Re: [SLE] Linux Ready for desktop -yes - Zdnet - Suse7.3 review

[Rod R. <ro...@su...>]

On Tuesday 15 January 2002 13:57, tom poe wrote:
> On Tuesday 15 January 2002 13:15, dids wrote:
> > http://news.zdnet.co.uk/story/0,,t269-s2102466,00.html

It's great to see proclamations like this from major publications.  2002 
might just be The Year of Linux.

> Hi:  Exactly!  And, when SuSE begins to include "Killer App2002",
> sql-ledger, the Open Source accounting software, in its distribution,
> watch out world! Just a thought,

I'll second that.  SL should really start taking off when enough business 
get exposure to it, and start creating their own add-ons that feed back 
into the user base.  Great work Dieter - I predict you'll be famous!

-- Rod
   http://www.sunsetsystems.com/

test

[alta <al...@al...>]

This is a test, because I have not received any sql-ledger mail in 
awhile.  Sorry for any inconvenience. - Reed

Re: [SLE] Linux Ready for desktop -yes - Zdnet - Suse7.3 review

[tom p. <to...@re...>]

On Tuesday 15 January 2002 13:15, dids wrote:
> http://news.zdnet.co.uk/story/0,,t269-s2102466,00.html

Hi:  Exactly!  And, when SuSE begins to include "Killer App2002", sql-ledger, 
the Open Source accounting software, in its distribution, watch out world!
Just a thought, 
Tom

Re: Feature Request/Lengthly Ramblings/Request for Comments

[Rob R. <ri...@me...>]

On Thu, 10 Jan 2002, David Ratte wrote:

> 1. DECIMAL PLACE DEPTH - I have a number of items that are sold in fractional 
> cents, 5000 pcs @ $0.0022 etc. I changed the sprintf %.2d to %.4d in the 
> format_amount function, but I have noticed that I get different totals when I 
> print out a form - v.s. the total indicated at the bottom of the invoice 
> screen, I don't have that one figured out yet. But anyway, it might be useful 
> to others to have in the setup screen an option for number of decimals.
> 
> Some folks have suggested in the past to change units to a larger unit (i.e. 
> pack/100), however since I manufacture a product, I have to keep UOM=1 since 
> the item is purchased and consumed in that unit.

If sql-ledger uses doubles for its quanities you may be able to 
sell by hundreds or thousands, just use .001 units sold to sell 1 pc.

Your other feature issues sound pedestrian but I don't know enough
about sql-l to comment on hacking them in.

rob                     Live the dream.

login.pl premature end of script headers

[Justin R. <ho...@ho...>]

hello -

installed on mandrake 8.2. initial install ok, postgres running, databases 
created through admin.pl. new user added with no problems.

when attempting to login, i get the following error from apache:

Can't connect(  ), no database driver specified and DBI_DSN env var not set 
at SL/User.pm line 111
Compilation failed in require at /var/www/sql-ledger/login.pl line 88.
[Fri Jan 11 17:17:26 2002] [error] [client 127.0.0.1] Premature end of 
script headers: /var/www/sql-ledger/login.pl

any help appreciated.

- justin
ho...@ho...


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Re: Win32 Installation issues

[Bryan J. S. <b.j...@ie...>]

Andrew Sharp wrote:
> Heh.  Well, no.  But close as it gets, I suppose.  Just don't
> be dim and try and edit a shortcut file directly.  But I've
> used them successfully instead of symlinks on many occassions,
> and, contrary to what some believe, they will work in cases not
> involving the UI.

Yo!  Original NT 3.1 beta-tester here ...

Microsoft delivered a "bare boned" POSIX layer in NT 3.1+.  Someone
ported the "ln" command over (along with others).  Sure enough, use
of it basically destroyed your NTFS volume very quickly (or it
became "difficult" to delete things).  Through NT 4.0, I didn't see
any improvement.  The utilities were available on the Resource Kits.

> NTFS, which is what we have to deal with going forward, doesn't
> support symlinks either, but it does have something called "juntion
> points" which is essentially a symlink to a directory.  Regular
> files don't get the priviledge yet, to my knowledge.

Man of us early NT adopters suggested that Microsoft start mounting
all fixed disk volumes into subdirectories on drive C: (with "C:"
being like /), ala UNIX-like, but maintaining driver letter
compatibility.  This was only for fixed disks -- e.g., floppy would
stay A:, CD could be whatever, etc...  Microsoft said it would just
"confuse people" and they believed the combination of "shared
volumes" and shortcuts would do the same.

Of course they didn't seem to be on the same page as the rest of us.

After years of supporting NT (1992-1999), I finally chucked it on
all the networks I support, just because I find UNIX/Linux much
easier to manage (Linux has been "desktop ready" since 1999 IMHO). 
I _refuse_ to use it as a server, and _barely_ support it as a
workstation.  So, I haven't done much NT hacking since late 1998**. 
If you have any info on "junction points," I'd like to hear more
about them.

-- Bryan
   
**NOTE:  I've been a 100% Linux guy for almost 3 years, but I have
started running Windows XP Professional at home for 2 programs (both
games).  So if you know how to use "junction points" under XP,
please let me know.  I consider Windows XP Professional to be "one
step forward" (more reliabile than DOS-based Win9x/ME, but nearly as
application compatible), and "one step back" (less secure than
NT-based WinNT/2000, because of the Win9x/ME application
compatibility's "NT kernel hacks").

-- 
Bryan J. Smith, Engineer        mailto:b.j...@ie...   
AbsoluteValue Systems, Inc.     http://www.linux-wlan.org
SmithConcepts, Inc.          http://www.SmithConcepts.com

Update to Problems with Installation

[Adam B. <co...@vi...>]

I've gotten a little farther along thanks to some help I received, but
once again I'm stuck.  I've gotten the database setup and a user
created.  Now, I'm trying to log in as that user, but I keep getting
this error in my apache log.  Hopefully someone can help me out with
it.

[Fri Jan 11 13:09:10 2002] [error] Undefined subroutine
&Apache::ROOTledger_2einternationalluthiers_2ecom::login_2epl::continue
called at bin/mozilla/login.pl line 46.

Thanks in advance for any assistance.

--
Adam Brown

Re: Win32 Installation issues

[Andrew S. <an...@ne...>]

Eric Mercer wrote:
> 
> Andrew Sharp wrote:
> >
> > "Sergio A. Kessler" wrote:
> > >
> > > but AFAIK win32 doesn't support symlinks...
> >
> > Sure it does, they just call them "shortcuts" (because they are
> > morons).
> >
> 
> Not exactly the same thing ;-)

Heh.  Well, no.  But close as it gets, I suppose.  Just don't be dim
and try and edit a shortcut file directly.  But I've used them
successfully instead of symlinks on many occassions, and, contrary
to what some believe, they will work in cases not involving the UI.

NTFS, which is what we have to deal with going forward, doesn't
support symlinks either, but it does have something called "juntion
points" which is essentially a symlink to a directory.  Regular
files don't get the priviledge yet, to my knowledge.

a

Re: Win32 Installation issues

[Eric M. <em...@ra...>]

Andrew Sharp wrote:
> 
> "Sergio A. Kessler" wrote:
> >
> > but AFAIK win32 doesn't support symlinks...
> 
> Sure it does, they just call them "shortcuts" (because they are
> morons).
> 

Not exactly the same thing ;-)

Re: Win32 Installation issues

[Jesper K. P. <jk...@so...>]

> "Sergio A. Kessler" wrote:
> > 
> > there IS a ./sql-ledger/admin.pl, but is a symlink
> > to ./sql-ledger/bin/mozilla/admin.pl
> > but AFAIK win32 doesn't support symlinks...
> 
> Sure it does, they just call them "shortcuts" (because they are
> morons).
> 

It is funny you use the word "morons" as Microsoft Windows do 
NOT support symlinks. What they do support is shortcuts - which 
is not to be mistaken for a symlink.
I would like to see you do a command like "edit 
short_cut_file.lnk" and compare that to a "edit short_cut_file" 
that isnt a link. Short cuts are just that - a shortcut for the 
Microsoft Windows desktop enviroment to let the user have "easy" 
access to files.

Programming wise there is a huge difference in how to 
handle "Microsoft shortcuts" compared to how we handle symlinks.

Just my two cents worth
Best regards
Jesper K. Pedersen
SolNet Data Service

PS. Great work with the SQL-Ledger guys.

Re: Win32 Installation issues

[Andrew S. <an...@ne...>]

"Sergio A. Kessler" wrote:
> 
> there IS a ./sql-ledger/admin.pl, but is a symlink
> to ./sql-ledger/bin/mozilla/admin.pl
> but AFAIK win32 doesn't support symlinks...

Sure it does, they just call them "shortcuts" (because they are
morons).

> anyway, I don't think you will get a reliable & robust
> sql-ledger system on win32...

Sure you can.  You just have to want it real bad.  but I don't
condone such activities.

> my best advice would be to install a linux distro
> like mandrake or redhat that are easy to install
> and come with all the software sql-ledger needs.
> (ie. redhat 7.2 come with pgsql, perl-DBI, perl-DBD-Pg,
> apache & perl)

a

Re: Win32 Installation issues

[Andrew N. <ane...@ya...>]

Sorry Sergio, accidentally sent to Sergio only by
mistake. resent here.

--- "Sergio A. Kessler" <ser...@ho...>
wrote:
> there IS a ./sql-ledger/admin.pl, but is a symlink
> to ./sql-ledger/bin/mozilla/admin.pl
> but AFAIK win32 doesn't support symlinks...
> 
> anyway, I don't think you will get a reliable &
> robust
> sql-ledger system on win32...
>

The web page for sql-ledger says nothing of this. It
indicates Win32 is a viable target platform. If anyone
can confirm this is incorrect, I'll stop right now and
waste no more of our time.

I am reasonably experienced with Linux, and Perl (on
Unix and Win32) with DBI and CGI. But I seek a system
that will work on both platforms.
 
> my best advice would be to install a linux distro
> like mandrake or redhat that are easy to install
> and come with all the software sql-ledger needs.
> (ie. redhat 7.2 come with pgsql, perl-DBI,
> perl-DBD-Pg,
> apache & perl)
> 

I CAN do Linux. I run Mandrake 8.0 at home with
postgres and Apache. I WANT to do Win32.

TIA for any advice

Andrew

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

Re: Win32 Installation issues

[Sergio A. K. <ser...@ho...>]

there IS a ./sql-ledger/admin.pl, but is a symlink
to ./sql-ledger/bin/mozilla/admin.pl
but AFAIK win32 doesn't support symlinks...

anyway, I don't think you will get a reliable & robust
sql-ledger system on win32...

my best advice would be to install a linux distro
like mandrake or redhat that are easy to install
and come with all the software sql-ledger needs.
(ie. redhat 7.2 come with pgsql, perl-DBI, perl-DBD-Pg,
apache & perl)

/sergio

----- Original Message ----- 
From: "Andrew Nerlich" <ane...@ya...>


> I am attempting to install SQL Ledger 1.8.1 on Win32.
> 
> Cygwin, Postgres, Apache all seem OK.
> 
> The instructions tell me to access
> 
> .../sql-ledger/admin.pl to connect to a database.
> 
> However, admin.pl does not exist in the sql-ledger/
> directory. Only scripts there are login.pl and am.pl.
> 
> there is an admin.pl in .../mozilla/bin, but this has
> no #! on the first line and thus does not appear to be
> coded to be called directly.
> 
> I had to modify login.pl as it does not seem to parse
> Win32 paths correctly, and this may have prevented it
> from calling /mozilla/bin/admin.pl, but I may be
> totally off base with this.
> 
> I can't log in. I could set up the members file by
> hand if I could work out its format, but I'd prefer to
> avoid working backward from the Perl code if possible.
> 
> Can someone please explain - or possibly post an
> example members file so that I can set up manually.
> 
> Does anyone have any good web resources on using
> DBD::Pg with Cygwin and ActivePerl? I'm getting "file
> not found" errors on the postgres socket connect when
> I try to connect to my SQL-ledger DB with my own
> program.
> 
> TIA

Re: Win32 Installation issues

[Martin L. <ma...@li...>]

=DChel kenal p=E4eval (reede, 11. jaanuar 2002 02:22) kirjutasid sa:
> I am attempting to install SQL Ledger 1.8.1 on Win32.
>
> Cygwin, Postgres, Apache all seem OK.
>
> The instructions tell me to access
>
> .../sql-ledger/admin.pl to connect to a database.
>
> However, admin.pl does not exist in the sql-ledger/
> directory. Only scripts there are login.pl and am.pl.
>
> there is an admin.pl in .../mozilla/bin, but this has
> no #! on the first line and thus does not appear to be
> coded to be called directly.

you must just fix paths issue and change #!/usr/bin/perl to eq.=20
#!c:/perl/bin/perl.exe in am.pl and copy am.pl in place of all symlinks.=20

> I had to modify login.pl as it does not seem to parse
> Win32 paths correctly, and this may have prevented it
> from calling /mozilla/bin/admin.pl, but I may be
> totally off base with this.

yes, i think you'll need to call mozilla\bin\admin.pl instead.

I've written small guide about setting up sql-ledger in w2k. It was writt=
en=20
for some 1.4.x version, but most of it should still apply:

http://lillepuu.com/txt/sql-ledger_win2k.txt

--=20
Martin Lillepuu | e-mail: ma...@li... | gsm: +372 515 6450

Navigation Enhancements for Customer/Invoice

[alta <al...@al...>]

This will be of special interest to sql-ledger 1.8 users with large 
numbers of customers.  It will speed data entry for fewer 
customers, as well.  The modifications do not interfere with other 
functionality.

Here's the concept.  When I add a new customer, I like to be able to 
jump to the invoice form without searching for the new customer in a 
4000-customer drop-down list.  Similarly, if I have a recurring 
customer, I like to look at customer data (to verify accuracy) before 
doing the invoice.  After verification, I like to do the invoice 
without dealing with the 4000-customer drop-down list.  Data entry 
speed and accuracy are important for me.

The solution:

I added a "Create Invoice" link to both the Edit Customer and Add 
Customer forms.  When done with the customer, the user can jump 
directly to the Invoice form, and the proper customer will be waiting.

The solution is implemented using Dieter's new customization hooks.  
Original sql-ledger 1.8 code is not modified.  Just add a couple new 
files to the sql-ledger/bin/mozilla directory.  And almost like 
magic, it's ready to go.  (Thanks Dieter!)

Installation:

1. Copy the following files to your sql-ledger/bin/mozilla directory:

     www.alta-research.com/custom_ct.txt
     www.alta-research.com/custom_is.txt

2. In sql-ledger/bin/mozilla, change the .txt suffixes to .pl :

     mv custom_ct.txt custom_ct.pl
     mv custom_is.txt custom_is.pl

3. Verify that permissions are the same as other files.

You're done.

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...