From: Wong L. W. <won...@ya...> - 2001-07-14 01:48:05
|
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. |