Monday, September 19, 2011

front accounting errors messages

DATABASE ERROR : The customer details could not be retrieved
error code : 1054
error message : Unknown column 'trans.type' in 'field list'
sql that failed was : SELECT 0_debtors_master.name,

0_debtors_master.curr_code, 0_payment_terms.terms,

0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,

0_credit_status.reason_description,

Sum(IFNULL(IFNULL(IF(trans.type=11 OR trans.type=12 OR

trans.type=2, -1, 1) * (trans.ov_amount + trans.ov_gst +

trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Balance, Sum(IF

((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,

trans.due_date, trans.tran_date))) >= 0,IFNULL(IF(trans.type=11 OR

trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +

trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Due, Sum(IF ((TO_DAYS('2011-09-18') -

TO_DAYS(IF (trans.type=10, trans.due_date, trans.tran_date))) >=

30,IFNULL(IF(trans.type=11 OR trans.type=12 OR trans.type=2, -1,

1) * (trans.ov_amount + trans.ov_gst + trans.ov_freight +

trans.ov_freight_tax + trans.ov_discount),0),0)) AS Overdue1,

Sum(IF ((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,

trans.due_date, trans.tran_date))) >= 60,IFNULL(IF(trans.type=11

OR trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +

trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +

trans.ov_discount),0),0)) AS Overdue2 FROM 0_debtors_master LEFT

JOIN 0_debtor_trans trans ON trans.tran_date <= '2011-09-18' AND 0_debtors_master.debtor_no = trans.debtor_no AND trans.type <> 13

, 0_payment_terms, 0_credit_status WHERE

0_debtors_master.payment_terms = 0_payment_terms.terms_indicator

AND 0_debtors_master.credit_status = 0_credit_status.id AND

0_debtors_master.debtor_no = '' GROUP BY 0_debtors_master.name,

0_payment_terms.terms, 0_payment_terms.days_before_due,

0_payment_terms.day_in_following_month,

0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,

0_credit_status.reason_description


Seems that system upgrade to version 2.1 has been performed for

this company already.
If something has gone wrong and you want to retry upgrade process

you MUST perform database restore from last backup file

first.Database upgrade to version 2.1 failed for company

'Windrolinx'.
You should restore company database from latest backup fileSQL

script execution failed in line 54: Table 'acc2.0_company' doesn't

existDatabase upgrade to version 2.3 failed for company

'Windrolinx'.
You should restore company database from latest backup file

SQL script execution failed in line 54: Table 'acc2.0_company'

doesn't existDatabase upgrade to version 2.3 failed for company

'Windrolinx'.
You should restore company database from latest backup file


System is blocked after source upgrade until database is updated

on System/Software Upgrade page

My Famous Blog List