i am new to FA and when i used it first time i found 2 bugs
1.when creating invoice or quotation
while entering the product from drop down list after selecting product cant change the product untill product code is deleted and enter is pressed.
2.Sales/Reports and Analysis/Print Statements
when the display print is clicked it will print a blank page .only when show also allocated is selected to yes will it print statement.
dont know if these two have been resolved or not.
Cheers
Rida
Janusz
]]>In fact it is pertinent to quote the solution link for FA dev records:
Monday, December 7, 2009
MySQL: Error 1305 - Function xxx does not exist
I ran into an odd issue on a project I updated awhile ago. I updated an existing sql statement to include IFNULL for an exclusion check. It worked fine on my dev machine, but caused an issue on the production machine.
The version of MySQL on my dev machine was a little bit newer than production so the issue never came up. Here is the error the sql server returned:
#1305 - FUNCTION [DATABASE_NAME].ifnull does not exist
Here is a little bit of the sql that caused the error:
AND IFNULL ( `tbl_category_admin`.`admin_key_id` =5, true )
The problem was caused by the space between IFNULL and (. Changing it to IFNULL( solved the problem. If you run into an issue where MySQL returns an error saying a given function does not exist look for spaces between the function and the "(".
The affected file in the Repo can be browsed here (see second IFNULL in lines 69-71).
Unfortunately, only Joe Hunt and Janusz (@itronics) have commit (write) rights to the core Hg Repo. Their reason being that the project would only then have tight control of the code and these seem to have been gleaned from the experiences in the upstream WebERP and some other projects. It seems to have worked well so far.
Since the Official Git Mirror has not been updated in a while, I have now synched the Hg with my personal GitHub repo and included your fix as well.
After several months of it's existence, only now has one active fork (of the 11 present) begun to provide code pulls to enhance FA.
Patch attached for Joe / Janusz to update the HG repo.
]]>Thanks for your response. I have followed your steps and now know which file will trigger the following error:
Databasefout : query for bank transaction
error code : 1305
error message : FUNCTION frontaccounting.IFNULL does not exist
sql that failed was : SELECT bt.*, act.*, IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount, IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate, IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_curr FROM 12_bank_trans bt LEFT JOIN 12_debtor_trans dt ON dt.type=bt.type AND dt.trans_no=bt.trans_no LEFT JOIN 12_debtors_master debtor ON debtor.debtor_no = dt.debtor_no LEFT JOIN 12_supp_trans st ON st.type=bt.type AND st.trans_no=bt.trans_no LEFT JOIN 12_suppliers supplier ON supplier.supplier_id = st.supplier_id, 12_bank_accounts act WHERE act.id=bt.bank_act AND bt.type='2' AND bt.trans_no = '1' ORDER BY trans_date, bt.id
The 1305 error is triggered by the changed file /gl/includes/db/gl_db_bank_trans.inc
I have googled a bit on the error code and found this post: http://blog.152.org/2009/12/mysql-error … s-not.html
According to this instruction I have removed several spaces between IFNULL and the ( character in the file /gl/includes/db/gl_db_bank_trans.inc (1 space on each line in 69-71, so 3 in total).
Original code (extract)
IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount,
IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate,
IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_currChanged code (extract)
IFNULL(abs(dt.ov_amount), IFNULL(abs(st.ov_amount), bt.amount)) settled_amount,
IFNULL(abs(dt.ov_amount/bt.amount), IFNULL(abs(st.ov_amount/bt.amount), 1)) settle_rate,
IFNULL(debtor.curr_code, IFNULL(supplier.curr_code, act.bank_curr_code)) settle_currI understand this error doesn't occur on all MySQL versions. But I think other user might have this issue to. So can this fix sent to the repo?
]]>All you have to do is step from one commit to the other in the HG Repo (red dot stable version commits only) and see where it fails.
Install v2.3.18 and make sure your error does not arise.
Start with fixes from the HG Repo at:
0002430: Order Status Listing Report shows invoiced in heading rather than delivered. Fixed.
and go on till the last one at:
Payments, Deposits: fixed false error when payment is made in customer/supplier currency.
If you can provide the sequence of menu clicks that got you the error, it will be easy to zero in to the issue.
]]>After updating to 2.3.19 I receive a database error in Banking and General Ledger > Journal Inquiry when pressing on the link in column "Trans #" to view the transaction details. The error doesn't occurs in all transaction type views. The error occurs for example with bank deposit, bank payment and fund transfer. But with "Sales Invoice" I don't receive the error.
Tested on my live environment and on a clean install.
]]>/Elax
]]>I use this for comparing my personal changes against the official core and have the files from the fa extensions repo as well for any fixes in the interim that may come about.
]]>/Elax
]]>The Official Git Repo mirror of the main Hg Repo on SF is managed by Janusz and has not been updated in more than 10 days.
Upgrade from FA v2.3.18 to v2.3.19 can be done by uploading the changed files attached in this post.
Post release fixes are in the Mercurial repo.
]]>