#25 Food_Service: account setup

v4.5.0.1
open
nobody
5
2012-09-14
2009-08-20
os4ed developers
No

the account setup screen in the student info page should synchronize and use the student ID number it does not .
It also errors with Error

Date:

08/20/2009 02:36:45

Failure Notice:

DB Execute Failed.

SQL: SELECT s.STUDENT_ID,CONCAT(s.FIRST_NAME,' ',s.LAST_NAME) AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE fssa.ACCOUNT_ID= AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!=1
Traceback: /srv/www/opensis/modules/Food_Service/Students/Accounts.php at 42
Additional Information: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!=1' at line 1

after choosing a student

Discussion

  • kajal shaikh
    kajal shaikh
    2009-08-21

    I Have fixed this error . By mistake the page has been not commited along with other updated page.I will be commit the page on monday