i am getting this error when signed in as parent in windows 10 php 7.3 postgres latest version
07/16/2019 11:17:04
Date
DB Execute Failed. ERROR: invalid input syntax for type numeric: "" LINE 9: AND fsa.BALANCE<'' ORDER BY s.LAST_NAME,s.FIRST_NAME ^
Failure Notice
SELECT s.FIRST_NAME||coalesce(' '||s.MIDDLE_NAME||' ',' ')||s.LAST_NAME AS FULL_NAME,s.LAST_NAME,s.FIRST_NAME,s.MIDDLE_NAME,s.STUDENT_ID,ssm.SCHOOL_ID,ssm.GRADE_ID ,fssa.STATUS,fsa.ACCOUNT_ID,fsa.BALANCE AS BALANCE,-fsa.BALANCE AS DEPOSIT FROM STUDENTS s JOIN STUDENT_ENROLLMENT ssm ON (ssm.STUDENT_ID=s.STUDENT_ID
AND ssm.SYEAR='2019'
AND ssm.SCHOOL_ID='1'
AND ('2019-07-16'>=ssm.START_DATE
AND (ssm.END_DATE IS NULL OR '2019-07-16'<=ssm.END_DATE))
AND s.STUDENT_ID IN (SELECT STUDENT_ID FROM STUDENTS_JOIN_USERS WHERE STAFF_ID='3')),FOOD_SERVICE_ACCOUNTS fsa,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE TRUE AND fssa.STUDENT_ID=s.STUDENT_ID
AND fsa.ACCOUNT_ID=fssa.ACCOUNT_ID
AND fssa.STATUS IS NULL
AND fsa.BALANCE<'' ORDER BY s.LAST_NAME,s.FIRST_NAME