[Fixed] DB Execute Failed ERROR: column "file_attached" does not exist (update)

This site is best viewed in a modern browser with JavaScript enabled.

[Fixed] DB Execute Failed ERROR: column "file_attached" does not exist (update)

dzung

Hi - I get this error when I select "Student Billing" > Payment

10/07/2022 15:01:01
Date
DB Execute Failed. ERROR: column "file_attached" does not exist LINE 2: AMOUNT,PAYMENT_DATE,COMMENTS,LUNCH_PAYMENT,FILE_ATTACHED ^
Failure Notice

SELECT '' AS REMOVE,ID,REFUNDED_PAYMENT_ID,
AMOUNT,PAYMENT_DATE,COMMENTS,LUNCH_PAYMENT,FILE_ATTACHED
FROM billing_payments
WHERE STUDENT_ID='159'
AND SYEAR='2022'
AND (REFUNDED_PAYMENT_ID IS NULL OR REFUNDED_PAYMENT_ID=NULL) ORDER BY ID

SQL query

I'm lost here. Hope someone encountered this before and point me to the right direction.

Thank you.

francoisjacquet

Hello dzung

The FILE_ATTACHED column was added to the billing_payments table in version 8.3, see https://gitlab.com/francoisjacquet/rosariosis/-/commit/0227024cad276433a827ccbcf08b51807c90fb62

If you have upgraded RosarioSIS the right way, this error should not happen due to the database update routine.
Some have reported the error when upgrading the Student_Billing/ folder only. The Student Billing module being a core module, it cannot be upgraded separately.

dzung

Not doing anything out of the ordinary. I just perform a git pull on the repo.

I did a clean git clone of rosariosis repo and compare Student_Billing/ between newly cloned directory and mine and everything is same.

francoisjacquet

dzung I must admit I do not know what happened then.
What about the Accounting > Incomes program, do you also have an SQL error?

dzungdo

Accounting > Income is ok. It shows:

Total from Incomes: 	$0.00
Less: Total from Expenses: 	$0.00
Balance: 	$0.00
Total from Incomes: 	$0.00
& Total from Student Payments: 	$0.00
Less: Total from Expenses: 	$0.00
& Total from Staff Payments: 	$0.00
General Balance: 	$0.00

But "Accounting > Expenses" failed with same error as "Student Billing > Payment":

10/08/2022 15:10:26
Date
DB Execute Failed. ERROR: column "file_attached" does not exist LINE 1: ...LECT '' AS REMOVE,ID,AMOUNT,PAYMENT_DATE,COMMENTS,FILE_ATTAC... ^
Failure Notice

SELECT '' AS REMOVE,ID,AMOUNT,PAYMENT_DATE,COMMENTS,FILE_ATTACHED
FROM accounting_payments
WHERE SYEAR='2022'
AND STAFF_ID IS NULL
AND SCHOOL_ID='1'
ORDER BY ID

SQL query
```

dzungdo

Going to "Student Billing > Payment", pgsql log shows:

ERROR:  column "file_attached" does not exist at character 90
STATEMENT:  SELECT '' AS REMOVE,ID,REFUNDED_PAYMENT_ID,
                        AMOUNT,PAYMENT_DATE,COMMENTS,LUNCH_PAYMENT,FILE_ATTACHED
                        FROM billing_payments
                        WHERE STUDENT_ID='218'
                        AND SYEAR='2022'
                        AND (REFUNDED_PAYMENT_ID IS NULL OR REFUNDED_PAYMENT_ID=NULL) ORDER BY ID

For "Accounting > Expenses", pgsql log shows:

ERROR:  column "file_attached" does not exist at character 53
STATEMENT:  SELECT '' AS REMOVE,ID,AMOUNT,PAYMENT_DATE,COMMENTS,FILE_ATTACHED
                        FROM accounting_payments
                        WHERE SYEAR='2022'
                        AND STAFF_ID IS NULL
                        AND SCHOOL_ID='1'
                        ORDER BY ID

francoisjacquet

Hello dzungdo

Thank you for your answer.

So, somehow, DB updates for 8.3 only were not executed. Because the DB update for 8.4 and accounting_incomes seems OK.

What you can do is manually run the 8.3 SQL update queries against your database:

ALTER TABLE ONLY accounting_payments
			ADD COLUMN file_attached text;
ALTER TABLE ONLY billing_payments
			ADD COLUMN file_attached text;

dzung

That fixed the error!

Thank you for your guidance.