sql-ledger-users

[SL] 2.8.5 forex problems

[Peter M. <pe...@sy...>]

Hi All

I'm having major forex issues with 2.8.5 :-(

Case 1 (partial success):

- Enter POS
- change to non-default currency and set exchange rate
- add part & price is correctly shown in forex
- change currency to default currency and price shown is NOT changed to 
local currency :-(

Case 2 (total failure - matches last part of Case 1):
- Enter POS
- add part (local currency)
- change to foreign currency and part still shown at local price even 
though now in foreign currency :-(

Forex is a major issue since we will switch from MTL to EUR on 1st Jan 
next year.

I have tested this on a standard upgrade from 2.8.4 and also with a fresh 
install with data imported after schema cration.

Anyone seen anything similar or have any ideas where I may have slipped 
up?

R.
PeteM

[SL] 2.8.5 Install Problems

[<man...@ao...>]

Hi All,
I'm experiencing problems in installing SQL Ledger. I'm successfully
doing all steps mentioned in the installation manual. Yet, after
initializing dataset, i m getting problems. The error is "Error 500
Apache Internal Error". Upon checking the error log of Apache Web Server
it is mentioned that error was due to premature end of script. I'm using
Windows XP SP2, Active Perl 5.6, Apache 2.0 & Postgres 8.0. I even did
the installation of components on other PC with fresh Windows XP SP2
install, but same problem is there. Even with getting latest versions of
Postgres, Apache the problem is not solved. I not good at PERL at all so
i have no clue why am i getting this error.

Mandeep Singh.

[SL] Basic configuration problem

[Bob G. <bo...@rc...>]

I manage to do things several times until I get them 'right'.

At the moment, I am wondering why the system user of 'sql-ledger' has a
hyphen in the middle. Might sqlledger be better?

template1=# DROP USER sql-ledger;
ERROR:  syntax error at or near "-" at character 14
LINE 1: DROP USER sql-ledger;
                     ^

Re: [SL] Basic configuration problem - solved

[Bob G. <bo...@rc...>]

OK, got it

template1=# DROP ROLE "sql-ledger";
DROP ROLE
template1=#



On Wed, 2007-05-23 at 07:30 -0500, Bob Gustafson wrote:
> I manage to do things several times until I get them 'right'.
> 
> At the moment, I am wondering why the system user of 'sql-ledger' has a
> hyphen in the middle. Might sqlledger be better?
> 
> template1=# DROP USER sql-ledger;
> ERROR:  syntax error at or near "-" at character 14
> LINE 1: DROP USER sql-ledger;
>                      ^
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] What client encoding goes with what chart of accounts?

[Bob G. <bo...@rc...>]

This is probably a dumb question, but here I am an english
speaker/writer trying to create a german language database.

This error occurred after attempting to create the sql-ledger database
with the Germany-DATEV-SKR03 chart of accounts.

No multibyte encoding was selected.

Error!
INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand
Gesch=EF=BF=BDftsbetrieb')
ERROR: invalid byte sequence for encoding "UTF8": 0xe46674
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by
"client_encoding".

--------

Next step...

I went back to the datasete creation screen and selected Unicode UTF-8
from the drop down menu.

Clicking continue, I get:

Error!
CREATE SEQUENCE id start 10000
ERROR: relation "id" already exists


---------

Going back to the beginning (my usual mode of operation), with:

template1=3D# DROP DATABASE "sql-ledger";
DROP DATABASE
template1=3D#=20

I then have to go back two steps to the create database screen.

But, alas, I get:

Error!

FATAL: database "sql-ledger" does not exist


Of course it does not exist. I am trying to create it. Why the error..

Re: [SL] What client encoding goes with what chart of accounts?

[Bob G. <bo...@rc...>]

On Wed, 2007-05-23 at 08:49 -0500, Bob Gustafson wrote:
> This is probably a dumb question, but here I am an english
> speaker/writer trying to create a german language database.
>=20
> This error occurred after attempting to create the sql-ledger database
> with the Germany-DATEV-SKR03 chart of accounts.
>=20
> No multibyte encoding was selected.
>=20
> Error!
> INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand
> Gesch=EF=BF=BDftsbetrieb')
> ERROR: invalid byte sequence for encoding "UTF8": 0xe46674
> HINT: This error can also happen if the byte sequence does not match th=
e
> encoding expected by the server, which is controlled by
> "client_encoding".
>=20
> --------
>=20
> Next step...
>=20
> I went back to the datasete creation screen and selected Unicode UTF-8
> from the drop down menu.
>=20
> Clicking continue, I get:
>=20
> Error!
> CREATE SEQUENCE id start 10000
> ERROR: relation "id" already exists
>=20
>=20
> ---------
>=20
> Going back to the beginning (my usual mode of operation), with:
>=20
> template1=3D# DROP DATABASE "sql-ledger";
> DROP DATABASE
> template1=3D#=20
>=20
> I then have to go back two steps to the create database screen.
>=20
> But, alas, I get:
>=20
> Error!
>=20
> FATAL: database "sql-ledger" does not exist
>=20
>=20
> Of course it does not exist. I am trying to create it. Why the error..
>=20
>=20

Continuing on from where I left off:

Clicking the 'Delete Dataset' button on the admin.pl page gives:
Error!
Nothing to delete!

At least now sql-ledger knows there is no database.

Now, click on the 'Create Dataset' button:

I get the expected page - so far so good.

Filling in the blanks - sql-ledger, Unicode (UTF-8), and select
'Germany-DATEV-SKR03'; click 'Continue'

The disk buzzes, and.. I get:
Error!
INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand
Gesch=EF=BF=BDftsbetrieb')
ERROR: invalid byte sequence for encoding "UTF8": 0xe46674
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by
"client_encoding".

I think I have been here before..

Re: [SL] What client encoding goes with what chart of accounts? - solved

[Bob G. <bo...@rc...>]

On Thu, 2007-05-24 at 17:00 -0500, Bob Gustafson wrote:
> On Wed, 2007-05-23 at 08:49 -0500, Bob Gustafson wrote:
> > This is probably a dumb question, but here I am an english
> > speaker/writer trying to create a german language database.
> >=20
> > This error occurred after attempting to create the sql-ledger databas=
e
> > with the Germany-DATEV-SKR03 chart of accounts.
> >=20
> > No multibyte encoding was selected.
> >=20
> > Error!
> > INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand
> > Gesch=EF=BF=BDftsbetrieb')
> > ERROR: invalid byte sequence for encoding "UTF8": 0xe46674
> > HINT: This error can also happen if the byte sequence does not match =
the
> > encoding expected by the server, which is controlled by
> > "client_encoding".
> >=20
> > --------
> >=20
> > Next step...
> >=20
> > I went back to the datasete creation screen and selected Unicode UTF-=
8
> > from the drop down menu.
> >=20
> > Clicking continue, I get:
> >=20
> > Error!
> > CREATE SEQUENCE id start 10000
> > ERROR: relation "id" already exists
> >=20
> >=20
> > ---------
> >=20
> > Going back to the beginning (my usual mode of operation), with:
> >=20
> > template1=3D# DROP DATABASE "sql-ledger";
> > DROP DATABASE
> > template1=3D#=20
> >=20
> > I then have to go back two steps to the create database screen.
> >=20
> > But, alas, I get:
> >=20
> > Error!
> >=20
> > FATAL: database "sql-ledger" does not exist
> >=20
> >=20
> > Of course it does not exist. I am trying to create it. Why the error.=
.
> >=20
> >=20
>=20
> Continuing on from where I left off:
>=20
> Clicking the 'Delete Dataset' button on the admin.pl page gives:
> Error!
> Nothing to delete!
>=20
> At least now sql-ledger knows there is no database.
>=20
> Now, click on the 'Create Dataset' button:
>=20
> I get the expected page - so far so good.
>=20
> Filling in the blanks - sql-ledger, Unicode (UTF-8), and select
> 'Germany-DATEV-SKR03'; click 'Continue'
>=20
> The disk buzzes, and.. I get:
> Error!
> INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand
> Gesch=EF=BF=BDftsbetrieb')
> ERROR: invalid byte sequence for encoding "UTF8": 0xe46674
> HINT: This error can also happen if the byte sequence does not match th=
e
> encoding expected by the server, which is controlled by
> "client_encoding".
>=20
> I think I have been here before..
>=20

The Chart of Accounts files in sql/ are raw ISO_8859 and need to be
converted to UTF-8 files before they can be inserted into the database.

To convert all of the files starting with German* I used the commands:

mkdir iout
mkdir iin
cp sql/German* iin
# ls iin
cd iin
# ls -1=20
ls -1 | xargs -i iconv -f ISO_8859-1 -t UTF-8 {} -o ../iout/{}
# ls -l ../iout

Once the converted files are in directory iout, they can be pumped into
the database by:

psql sql-ledger

sql-ledger=3D# \i /usr/local/sql-ledger/sql/Germany-SKR03-chart.sql
sql-ledger=3D# \i /usr/local/sql-ledger/sql/Germany-SKR03-gifi.sql


Now I do see listings in the Chart of Accounts, but still have sql
errors when I try to insert data. (I don't know what to put in all of
the text entries, so I leave some blank. Maybe this is the problem).

I do have the Manual, but it is like many other technical manuals. You
have to read it a couple of times from page 1 to page 284, then remember
what you have read. Then attempt to install and populate the database.

[SL] Continual page refresh on mouseover

[Bob G. <bo...@rc...>]

I am seeing my window blink at a rate of about 1 per second whenever I
hover the mouse over a colored menu item.

It also happens when hovering over the (colored) names of businesses in
the page 'Type of Business'. (Also, it seems ANY colored item)

This is even after slicing out all 'onmouseover' routines in
bin/mozilla/all.pl  When I 'View Frame Source' and search for
'onmouseover', there are none. (dumped cache too)

Window still blinks.

This is a problem because it takes several clicks on menu items to get
to the desired form.

Also, if I hover over colored menu items down further on the menu, when
the frame refreshes, the top of the menu is displayed. The line I
hovered over is below the scroll cutoff then.

A serious problem.

I am using Firefox 1.5.0.10

Re: [SL] Continual page refresh on mouseover - solved

[Bob G. <bo...@rc...>]

Going to a Mac running Firefox 2.0.0.3 cures the problem. (although
still on a code base without 'onmouseover')

On Sat, 2007-05-26 at 10:46 -0500, Bob Gustafson wrote:
> I am seeing my window blink at a rate of about 1 per second whenever I
> hover the mouse over a colored menu item.
> 
> It also happens when hovering over the (colored) names of businesses in
> the page 'Type of Business'. (Also, it seems ANY colored item)
> 
> This is even after slicing out all 'onmouseover' routines in
> bin/mozilla/all.pl  When I 'View Frame Source' and search for
> 'onmouseover', there are none. (dumped cache too)
> 
> Window still blinks.
> 
> This is a problem because it takes several clicks on menu items to get
> to the desired form.
> 
> Also, if I hover over colored menu items down further on the menu, when
> the frame refreshes, the top of the menu is displayed. The line I
> hovered over is below the scroll cutoff then.
> 
> A serious problem.
> 
> I am using Firefox 1.5.0.10
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Continual page refresh on mouseover - solved - NOT

[Bob G. <bo...@rc...>]

Switching to Firefox 2.0.0.3 on Fedora6 does NOT cure the problem.
Blinky pages, when hovering over colored menu and page words, is still
there and is there whether 'onmouseover' is in bin/mozilla/menu.pl or
not.

Works fine with Firefox 2.0.0.3 on MacOS 10.4 with or without
'onmouseover'

On Sat, 2007-05-26 at 11:40 -0500, Bob Gustafson wrote:
> Going to a Mac running Firefox 2.0.0.3 cures the problem. (although
> still on a code base without 'onmouseover')
> 
> On Sat, 2007-05-26 at 10:46 -0500, Bob Gustafson wrote:
> > I am seeing my window blink at a rate of about 1 per second whenever I
> > hover the mouse over a colored menu item.
> > 
> > It also happens when hovering over the (colored) names of businesses in
> > the page 'Type of Business'. (Also, it seems ANY colored item)
> > 
> > This is even after slicing out all 'onmouseover' routines in
> > bin/mozilla/all.pl  When I 'View Frame Source' and search for
> > 'onmouseover', there are none. (dumped cache too)
> > 
> > Window still blinks.
> > 
> > This is a problem because it takes several clicks on menu items to get
> > to the desired form.
> > 
> > Also, if I hover over colored menu items down further on the menu, when
> > the frame refreshes, the top of the menu is displayed. The line I
> > hovered over is below the scroll cutoff then.
> > 
> > A serious problem.
> > 
> > I am using Firefox 1.5.0.10
> > 
> > -------------------------------------------------------------------------

Re: [SL] Continual page refresh on mouseover - solved - NOT

[Bob G. <bo...@rc...>]

Trying on Windows XP with Firefox 2.0.0.3 works fine too.

Only Fedora6 has a problem with blinky pages.. Fedora7 is out on May31.
I wonder if I should just wait.

On Sat, 2007-05-26 at 12:39 -0500, Bob Gustafson wrote:
> Switching to Firefox 2.0.0.3 on Fedora6 does NOT cure the problem.
> Blinky pages, when hovering over colored menu and page words, is still
> there and is there whether 'onmouseover' is in bin/mozilla/menu.pl or
> not.
> 
> Works fine with Firefox 2.0.0.3 on MacOS 10.4 with or without
> 'onmouseover'
> 
> On Sat, 2007-05-26 at 11:40 -0500, Bob Gustafson wrote:
> > Going to a Mac running Firefox 2.0.0.3 cures the problem. (although
> > still on a code base without 'onmouseover')
> > 
> > On Sat, 2007-05-26 at 10:46 -0500, Bob Gustafson wrote:
> > > I am seeing my window blink at a rate of about 1 per second whenever I
> > > hover the mouse over a colored menu item.
> > > 
> > > It also happens when hovering over the (colored) names of businesses in
> > > the page 'Type of Business'. (Also, it seems ANY colored item)
> > > 
> > > This is even after slicing out all 'onmouseover' routines in
> > > bin/mozilla/all.pl  When I 'View Frame Source' and search for
> > > 'onmouseover', there are none. (dumped cache too)
> > > 
> > > Window still blinks.
> > > 
> > > This is a problem because it takes several clicks on menu items to get
> > > to the desired form.
> > > 
> > > Also, if I hover over colored menu items down further on the menu, when
> > > the frame refreshes, the top of the menu is displayed. The line I
> > > hovered over is below the scroll cutoff then.
> > > 
> > > A serious problem.
> > > 
> > > I am using Firefox 1.5.0.10
> > > 
> > > -------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Continual page refresh on mouseover - solved - YES

[Bob G. <bo...@rc...>]

The problem was iReader v 1.0.8
This is an 'add-on' to Firefox and this version had a bug.
v 1.0.10, which I just installed and enabled, does not have the refresh
loop problem.

On Sat, 2007-05-26 at 13:11 -0500, Bob Gustafson wrote:
> Trying on Windows XP with Firefox 2.0.0.3 works fine too.
> 
> Only Fedora6 has a problem with blinky pages.. Fedora7 is out on May31.
> I wonder if I should just wait.
> 
> On Sat, 2007-05-26 at 12:39 -0500, Bob Gustafson wrote:
> > Switching to Firefox 2.0.0.3 on Fedora6 does NOT cure the problem.
> > Blinky pages, when hovering over colored menu and page words, is still
> > there and is there whether 'onmouseover' is in bin/mozilla/menu.pl or
> > not.
> > 
> > Works fine with Firefox 2.0.0.3 on MacOS 10.4 with or without
> > 'onmouseover'
> > 
> > On Sat, 2007-05-26 at 11:40 -0500, Bob Gustafson wrote:
> > > Going to a Mac running Firefox 2.0.0.3 cures the problem. (although
> > > still on a code base without 'onmouseover')
> > > 
> > > On Sat, 2007-05-26 at 10:46 -0500, Bob Gustafson wrote:
> > > > I am seeing my window blink at a rate of about 1 per second whenever I
> > > > hover the mouse over a colored menu item.
> > > > 
> > > > It also happens when hovering over the (colored) names of businesses in
> > > > the page 'Type of Business'. (Also, it seems ANY colored item)
> > > > 
> > > > This is even after slicing out all 'onmouseover' routines in
> > > > bin/mozilla/all.pl  When I 'View Frame Source' and search for
> > > > 'onmouseover', there are none. (dumped cache too)
> > > > 
> > > > Window still blinks.
> > > > 
> > > > This is a problem because it takes several clicks on menu items to get
> > > > to the desired form.
> > > > 
> > > > Also, if I hover over colored menu items down further on the menu, when
> > > > the frame refreshes, the top of the menu is displayed. The line I
> > > > hovered over is below the scroll cutoff then.
> > > > 
> > > > A serious problem.
> > > > 
> > > > I am using Firefox 1.5.0.10
> > > > 
> > > > -------------------------------------------------------------------------
> > 
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users