errors on login and adding a vendor invoice

[john <..hidden..>]

When i try to log in (either as admin or as a user) i get the following
error:



Error!
LedgerSMB/Session/DB.pm:188: Fetch sequence id: 
ERROR: function md5(double precision) does not exist
LINE 1: SELECT nextval('session_session_id_seq'), md5(random());
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.



i have tried PostgreSQL 8.2 and 8.3 both with LSMB 1.2.10, 1.2.11, and
1.2.12.  All give me the same issues.

i can login (both as admin and a regular user) if i hardcode the admin
password in DB.pl but this is obviously not the most elegant solution.

Once logged in as a regular user i ended up with some errors when trying
to add a vendor invoice.  This leads me to think that there may be a
(several?) problem(s) with the installation overall.

The error i get when trying to add a vendor invoice is as follows:


DBD::Pg::st execute failed: ERROR: operator does not exist: integer =
text
LINE 3: WHERE c.id = (SELECT value FROM defaults 
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.


Error!

SELECT (select c.accno FROM chart c 
WHERE c.id = (SELECT value FROM defaults 
WHERE setting_key = 
'inventory_accno_id'))
AS inventory_accno,

(SELECT c.accno FROM chart c
WHERE c.id = (SELECT value FROM defaults
WHERE setting_key =
'income_accno_id'))
AS income_accno,

(SELECT c.accno FROM chart c
WHERE c.id = (SELECT value FROM defaults
WHERE setting_key =
'expense_accno_id'))
AS expense_accno,

(SELECT c.accno FROM chart c
WHERE c.id = (SELECT value FROM defaults
WHERE setting_key =
'fxgain_accno_id'))
AS fxgain_accno,

(SELECT c.accno FROM chart c
WHERE c.id = (SELECT value FROM defaults
WHERE setting_key =
'fxloss_accno_id'))
AS fxloss_accno, 
(SELECT value FROM defaults
WHERE setting_key = 'curr') AS currencies,
current_date AS transdate
ERROR: operator does not exist: integer = text
LINE 3: WHERE c.id = (SELECT value FROM defaults 
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.



i am using the following on a Debian system (unstable repositories):
- PostgreSQL 8.3
- Perl v5.8.8
- Apache 2.2.6
- LedgerSMB 1.2.12 from source


i searched and was not able to find anything that referenced the
specific problems i am having, so apologies if they have been addressed
already.

Many thanks in advance for any help!

john