sql-ledger-users

Re: [SL] Server error when adding new item (add part)

[Gloria A. <got...@gm...>]

Just in case anyone else encountered this problem, we've traced the
cause of the problem to apache's mod_security.

Adding the following lines to mod_security.conf fixed the problem.

<Location /sql-ledger/>
     SecFilterEngine Off
</Location>

Re: [SL] Server error when adding new item (add part)

[Jonas B. N. <jo...@io...>]

Hi Gloria,

This is quite interesting to me, since I currently have a  
dysfunctional installation of SQL-Ledger. I get internal server error  
everytime I add something to the database.

This is most unfortunate since I am have all my accounting on this  
particular installation.

What version of Apache ar you running?

jonasbn

On 18/12/2006, at 4.20, Gloria Ang wrote:

> Just in case anyone else encountered this problem, we've traced the
> cause of the problem to apache's mod_security.
>
> Adding the following lines to mod_security.conf fixed the problem.
>
> <Location /sql-ledger/>
>      SecFilterEngine Off
> </Location>
>
> ---------------------------------------------------------------------- 
> ---
> 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
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Feature Request

[Dr E. L. <el...@li...>]

Dieter,

The majority of invoices I send have three items (at least) and I thus
need to push the update button several times (with the mouse, as I
haven't yest figured out the keyboard combination for that, on the Mac
anyway).

What would it take to make the invoice come up with more than one line
on the first go, perhaps even configurable through a/the config file?

Merry Christmas,

el

Re: [SL] Feature Request

[Mel B. <be...@te...>]

Dr Eberhard Lisse wrote:

>Dieter,
>
>The majority of invoices I send have three items (at least) and I thus
>need to push the update button several times (with the mouse, as I
>haven't yest figured out the keyboard combination for that, on the Mac
>anyway).
>
>What would it take to make the invoice come up with more than one line
>on the first go, perhaps even configurable through a/the config file?
>
>Merry Christmas,
>
>el
>
>  
>
    I never use the update key. After entering the item No. I hit enter.
If I must change the quantity from the default '1' and or the price, I
do so and then hit enter again. This automatically produces a new line.
Hope this helps.

Merry Christmas also

Mel B.

Re: [SL] Feature Request

[Dr E. L. <el...@li...>]

Thank you all for helping me with finding the keys., something I was/am
not concerned about.

I want to enter three lines (at least) at a time.

el


on 12/24/06 8:02 AM Mel Broadhurst said the following:
> Dr Eberhard Lisse wrote:
> 
>> Dieter,
>>
>> The majority of invoices I send have three items (at least) and I thus
>> need to push the update button several times (with the mouse, as I
>> haven't yest figured out the keyboard combination for that, on the Mac
>> anyway).
>>
>> What would it take to make the invoice come up with more than one line
>> on the first go, perhaps even configurable through a/the config file?
>>
>> Merry Christmas,
>>
>> el
>>
>>  
>>
>     I never use the update key. After entering the item No. I hit enter.
> If I must change the quantity from the default '1' and or the price, I
> do so and then hit enter again. This automatically produces a new line.
> Hope this helps.
> 
> Merry Christmas also
> 
> Mel B.
> 
> -------------------------------------------------------------------------
> 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
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Feature Request

[Asante, E. [ING-WBK] <Emm...@bh...>]

Eberhard,

If the three items has a common character in the codes, you can enter
that character, press enter and you'll get a list of all items with that
character in. You can then select as many of those items as you want.

Emmanuel=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Dr
Eberhard Lisse
Sent: Sunday, December 24, 2006 11:33 AM
To: sql...@li...
Subject: Re: [SL] Feature Request

Thank you all for helping me with finding the keys., something I was/am
not concerned about.

I want to enter three lines (at least) at a time.

el


on 12/24/06 8:02 AM Mel Broadhurst said the following:
> Dr Eberhard Lisse wrote:
>=20
>> Dieter,
>>
>> The majority of invoices I send have three items (at least) and I=20
>> thus need to push the update button several times (with the mouse, as

>> I haven't yest figured out the keyboard combination for that, on the=20
>> Mac anyway).
>>
>> What would it take to make the invoice come up with more than one=20
>> line on the first go, perhaps even configurable through a/the config
file?
>>
>> Merry Christmas,
>>
>> el
>>
>> =20
>>
>     I never use the update key. After entering the item No. I hit
enter.
> If I must change the quantity from the default '1' and or the price, I

> do so and then hit enter again. This automatically produces a new
line.
> Hope this helps.
>=20
> Merry Christmas also
>=20
> Mel B.
>=20
> ----------------------------------------------------------------------
> --- Take Surveys. Earn Cash. Influence the Future of IT Join=20
> SourceForge.net's Techsay panel and you'll get the chance to share=20
> your opinions on IT & business topics through brief surveys - and earn

> cash=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=
=3DDEV
> DEV _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

--=20
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

------------------------------------------------------------------------
-
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=3Djoin.php&p=3Dsourceforge&CID=
=3DDEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


This message and any attached files may contain information that is=
 confidential and/or subject of legal privilege intended only for use by=
 the intended recipient. If you are not the intended recipient or the=
 person responsible for delivering the message to the intended recipient,=
 be advised that you have received this message in error and that any=
 dissemination, copying or use of this message or attachment is strictly=
 forbidden, as is the disclosure of the information therein. If you have=
 received this message in error please notify the sender immediately and=
 delete the message.

Re: [SL] Feature Request

[Dr E. W L. <el...@li...>]

Thanks,

but only two of them have (most of the time), one is different always.

el

Asante, Emmanuel [ING-WBK] wrote:
> Eberhard,
> 
> If the three items has a common character in the codes, you can enter
> that character, press enter and you'll get a list of all items with that
> character in. You can then select as many of those items as you want.
> 
> Emmanuel 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Dr
> Eberhard Lisse
> Sent: Sunday, December 24, 2006 11:33 AM
> To: sql...@li...
> Subject: Re: [SL] Feature Request
> 
> Thank you all for helping me with finding the keys., something I was/am
> not concerned about.
> 
> I want to enter three lines (at least) at a time.
> 
> el
> 
> 
> on 12/24/06 8:02 AM Mel Broadhurst said the following:
>> Dr Eberhard Lisse wrote:
>>
>>> Dieter,
>>>
>>> The majority of invoices I send have three items (at least) and I 
>>> thus need to push the update button several times (with the mouse, as
> 
>>> I haven't yest figured out the keyboard combination for that, on the 
>>> Mac anyway).
>>>
>>> What would it take to make the invoice come up with more than one 
>>> line on the first go, perhaps even configurable through a/the config
> file?
>>> Merry Christmas,
>>>
>>> el
>>>
>>>  
>>>
>>     I never use the update key. After entering the item No. I hit
> enter.
>> If I must change the quantity from the default '1' and or the price, I
> 
>> do so and then hit enter again. This automatically produces a new
> line.
>> Hope this helps.
>>
>> Merry Christmas also
>>
>> Mel B.
>>
>> ----------------------------------------------------------------------
>> --- 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=DEV
>> DEV _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

[SL] upgrade problem

[Omar B. <ob...@ab...>]

Hi All,
when I want to upgrade from version 2.4 to 2.6,
I get the following error when I try to update the data set the first time

Error!
create table recurring (id int, reference text, startdate date, nextdate date, 
enddate date, repeat int2, unit varchar(6), howmany int, payment bool 
default 'f')
ERROR: relation "recurring" already exists


and then when I try to upgrade the dataset again I get the following error

Error!
alter table ar add ponumber text
ERROR: column "ponumber" of relation "ar" already exists


best regards
omar
-- 
-

______________________________________________________________________
This information transmitted is only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of this information, or
taking of any action in reliance upon this information,by person or entities
other than the intended recipient is prohibited. If you received this in
error, please contact the sender and delete the material from any computer.
______________________________________________________________________

Re: [SL] Feature Request

[Stroller <lin...@my...>]

On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
>
> The majority of invoices I send have three items (at least) and I thus
> need to push the update button several times ... I
> haven't yest figured out the keyboard combination for that, on the Mac
> anyway...

Ummm... the keyboard combination is "enter".

Stroller.

Re: [SL] Feature Request

[Erkki E. <er...@it...>]

Isn't it "alt-u" ?

=C3=9Chel kenal p=C3=A4eval, P, 2006-12-24 kell 00:07, kirjutas Stroller:
> On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
> >
> > The majority of invoices I send have three items (at least) and I thu=
s
> > need to push the update button several times ... I
> > haven't yest figured out the keyboard combination for that, on the Ma=
c
> > anyway...
>=20
> Ummm... the keyboard combination is "enter".
>=20
> Stroller.
>=20
> -----------------------------------------------------------------------=
--
> 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--=20
Erkki Eilonen <er...@it...>
iTech Solutions

Re: [SL] Feature Request

[Stroller <lin...@my...>]

On 24 Dec 2006, at 00:24, Erkki Eilonen wrote:
> =DChel kenal p=E4eval, P, 2006-12-24 kell 00:07, kirjutas Stroller:
>> On 23 Dec 2006, at 05:04, Dr Eberhard Lisse wrote:
>>>
>>> The majority of invoices I send have three items (at least) and I =20=

>>> thus
>>> need to push the update button several times ... I
>>> haven't yest figured out the keyboard combination for that, on =20
>>> the Mac
>>> anyway...
>>
>> Ummm... the keyboard combination is "enter".
>
> Isn't it "alt-u" ?

All I know is that I type "ab" in the box for part number & hit enter =20=

& I get a list of parts ab001, ab002 ... ab999 to choose from. Even =20
if I type ab in the part number field and then press tab until I'm in =20=

the quantity field, then press 3 and enter, the same thing happens.

Stroller.=