#30 Adding student contact info

v4.5.0.1
open
nobody
Students (13)
9
2012-09-14
2009-08-26
os4ed developers
No

when trying to add student contact info I got this error in Dev box 08/26/2009 10:32:57

Failure Notice:

DB Execute Failed.

SQL: INSERT INTO ADDRESS (ADDRESS_ID,STUDENT_ID,MAIL_ADDRESS,MAIL_STREET,MAIL_CITY,MAIL_STATE,MAIL_ZIPCODE,PRIM_ADDRESS,PRIM_STREET,PRIM_CITY,PRIM_STATE,PRIM_ZIPCODE,SEC_ADDRESS,SEC_STREET,SEC_CITY,SEC_STATE,SEC_ZIPCODE,ADDRESS,CITY,STATE,ZIPCODE,BUS_NO,PRIM_STUDENT_RELATION,PRI_FIRST_NAME,PRI_LAST_NAME,HOME_PHONE,WORK_PHONE,SEC_STUDENT_RELATION,SEC_FIRST_NAME,SEC_LAST_NAME,SEC_HOME_PHONE) values('1','7','1 winter st',NULL,'Anytown','Ga','30010','1 winter st',NULL,'Anytown','Ga','30010','1 winter st',NULL,'Anytown','Ga','30010','1 winter st','Anytown','Ga','30010','1','Mother','Mom','Student','843-321-9122','843-321-9122','Father','Dad','Student','843-321-9122')
Traceback: /srv/www/opensis/modules/Students/includes/Address.inc.php at 131
Additional Information: Duplicate entry '1' for key 1

Discussion