Hi...I'm new to ledgerSMB and during a recent install I could not log in. Here
is the error after attempted login:
'ERROR: function md5(double precision) does not exist'
I've modified the file DB.pm by changing line 160 from:
'my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'),
md5(random());");'
to:
'my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'),
md5(random()::text);");'
and this has solved the problem. For some reason, perhaps related to the
recent 64 bit version of PostgreSQL, the function random() must be explicitly
cast to a text form for use by md5().
R Summers
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
