I upgraded my sql-ledger version1.4.5 to 1.4.11. I have no problem in login
but with problem in the report part of the program. When I click on Balance
Sheet, Income Statement and trial balance report I get this message below :
Error!
ERROR: No such attribute or function 'chart_id' SELECT chart.accno,
description, type, SUM(CASE WHEN amount < 0 THEN -amount ELSE 0 END) AS
debit, SUM(CASE WHEN amount > 0 THEN amount ELSE 0 END) AS credit FROM
chart, acc_trans WHERE chart.id = acc_trans.chart_id AND true GROUP BY
chart.accno, description, type UNION SELECT chart.accno, description, type,
0.0 as debit, 0.0 as credit FROM chart, acc_trans WHERE chart.type = 'H'
ORDER BY chart.accno
In my httpd directory's log file, the error log show this message :
[Sat Jul 14 08:55:17 2001] [notice] Apache-AdvancedExtranetServer/1.3.19
(Linux-Mandrake/3mdk) mod_ssl/2.8.2 OpenSSL/0.9.6 configured -- resuming
normal operations [Sat Jul 14 09:04:29 2001] [error] [client 127.0.0.1] File
does not exist: /var/www/html/favicon.ico [Sat Jul 14 09:04:30 2001] [error]
[client 127.0.0.1] file permissions deny server execution:
/var/www/cgi-bin/sql-ledger/sql-ledger.gif DBD::Pg::st execute failed:
ERROR: No such attribute or function 'chart_id' Died at SL/Form.pm line
107.
Compilation failed in require at /var/www/cgi-bin/sql-ledger/rp.pl line 65.
DBD::Pg::st execute failed: ERROR: No such attribute or function 'chart_id'
Died at SL/Form.pm line 107.
Compilation failed in require at /var/www/cgi-bin/sql-ledger/rp.pl line 65.
Database handle destroyed without explicit disconnect.
Is that something wrong in my setting?
Please help.
Thank You.
|
