--
-- Host: localhost    Database: sdcs
-- ------------------------------------------------------


--
-- Table structure for table `report_problem`
--

CREATE TABLE `report_problem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `desc` longtext NOT NULL,
  `status` int(11) NOT NULL,
  `attachment` varchar(100) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  `username` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_problem`
--

INSERT INTO `report_problem` VALUES (1,'Grade 10 Nomination for Lae Christian Academy','Except for Candidate 1001the rest of the students from 1002 to 1018 are not registered and thus cannot electronically input their grade 9 marks. please help!',0,'','1620775891','laechristianacademy'),(2,'Grade 9 Marks input','PD marks for some students cannot be inputed on SDCS please check Telefomin Secondary and Assist in for subjects that cannot accept inpit. It is giving only 1',0,'','1622084150','telefominss'),(3,'Grade 9 Internal Marks','Grade 10 nomination was in place of Grade 9 internal marks. Can you kindly delete from your database so we can upload the correct new file. See the screen shot attached below.',0,'','1622605043','madangchristianacademy'),(4,'grade9 internal marks - MCA 2021','4 students with 1 appearing instead of their grade 9 internal marks',0,'','1623374339','madangchristianacademy'),(5,'Downloaded grade9 internalmarks entry- problem page','the file was uploaded with marks but when viewed, 4 students had 1 as their marks for English and Maths. their marks are highlighted.',0,'','1623374608','madangchristianacademy'),(6,'Downloaded grade9 internalmarks entry- problem page','the file was uploaded with marks but when viewed, 4 students had 1 as their marks for English and Maths. their marks are highlighted.',0,'','1623374608','madangchristianacademy'),(7,'Downloaded grade9 internalmarks entry- problem page','the file was uploaded with marks but when viewed, 4 students had 1 as their marks for English and Maths. their marks are highlighted.',0,'','1623374609','madangchristianacademy'),(8,'GRADE 12 Nomination List Upload fails','We tried uploading the GR12 Nomination List but failed due to an error. See attachment. Error message saying M/F for Gender. However, we entered all  required information including gender.\nCould you please varify the problem and inform us on email. mapriksecondary601@gmail.com or 72441880. Call for Deputy Principal Academic Mr Molland Saluali',0,'','1623975117','maprikss'),(9,'Grade 11 300 marks','I already uploaded the 300 marks for Grade 11 but when I want to view uploaded data, it says results not found. What shall I do?',0,'','1624619859','wawinnhs'),(10,'GRADE NINE INTERNAL MARKS CORRECTIONS','Candidate 1042 is taking Arts 290 not IT, candidate 1049 is taking IT 326 not Arts and candidate 1050 does not have any marks in his elective; he is taking Arts with 174. Thank you!',0,'','1625262417','naskohs'),(83,'Grade 10 Internal Marks','Error in uploading',0,'','1755050091','gerehuss'),(84,'Grade 10 internal marks','Did not multiply the grade 10 AP3 raw marks by 2 and just upload ...this is the correct raw marks\nthank you',0,'','1755143389','anditalehs'),(16,'Grade 10 internal marks entry','marks cannot be saved as some marks given to some students already.',0,'','1629427944','madangchristianacademy'),(17,'GR9/11 ESTIMATED MARKS','its not reading the estimated marks for grade 9 and 11 especially mathematic /AMX/GMX and English/L',0,'','1629628320','papitalaiss'),(18,'grade 9 internal marks','invalid score for the following students.',0,'','1630299105','madangchristianacademy'),(19,'Grade 10 internal marks entry','marks cannot save successfully as a score of 1 was already given for  Sawera Lachlan',0,'','1630299250','madangchristianacademy'),(20,'Norminations Format','blocked/unable to download',0,'','1630635079','kimbeinternational'),(21,'SLF not accessible','SLF not accessible- please enable access.',0,'','1631064482','hldschristiangrammar'),(22,'Name Editing','Unable to edit spelling of 2 names. #1. CANDIDATE 1002 AISA #2. CANDIDATE 1026 G. DICK',0,'','1632776203','redscarhs'),(23,'Grade 9 internal marks entry','PD and PS marks not entered correctly for each student',0,'','1633179007','lihirss'),(25,'Michael Kumi, Deputy Pricipal-Academic, Tambul Sec','can not be able to upload the gr 10',0,'','1635142255','tambulss'),(26,'2022 grade 9 marks entry format','There is a format to upload the grade 9 marks for the grade 10 students. Last was active so the format was downloaded and then marks entered and uploaded again. But for this year, there was no format for 2022, or may be there is a problem so tried several times but to no avail. please inform when 2022 format is ready so that the marks can be entered online as well. Thankyou patiently waiting for your reply.',0,'','1649912115','sirunkihs'),(27,'Marianville Secondary','problem with up loading grade 12 nomination form.',0,'','1657677413','marianvilless'),(28,'Unable to upload data .','I am at Marianville Secondary school. I have collated the grade 10 and 12 internal marks but am unable to upload, why is that? \n2. The year has not changed it still has 2021 online why and how could I change it?',0,'','1661823382','marianvilless'),(29,'Problem with excel sheet','Please could you  let me know what is wrong about  the excel sheet and how can I fix it or could you do something about it? Thanks',0,'','1661825488','marianvilless'),(30,'Grade 9  400 marks','1. CANDIDATE # 1009 PD IS 282..  2, CANDIDATE # 1011 ENGLISH IS 275, MATHS IS 218, PD IS 287.',0,'','1664860479','redscarhs'),(31,'Grade 10 Nomination','Having problem with uploading of grade 10 nominations (exel) and rearranging the candidate number, especially 1004.',0,'','1692789170','holyspiritss'),(32,'Grade 11 Internal marks for grade 12-2023','Please check grade 11 marks for candidates, 111,112,113,114,121,122,123. Marks are not related to the subjects taken. See attachment. Thanks',0,'','1692789718','holyspiritss'),(33,'Submission of the incorrect Nominations data for grade 12','The nominations data for the grade 12 that has been uploaded was the wrong format. And the attachment is the correct one. Please help us out with that.',0,'','1694558996','laechristianintegrateds'),(34,'Deputy Principal','Not able to edit/update Admin Profile',0,'','1697426748','kimbeinternational'),(35,'Deputy Principal','there is no clear option to upload Photos and signatures of students',0,'','1697426825','kimbeinternational'),(54,'Logout','How can we logout from the account using mobile phone',0,'','1742891971','helatechnicalhs'),(55,'Logout','How can we logout from the account using mobile phone',0,'','1742891977','helatechnicalhs'),(56,'Year Template (2025)','The year template does not show 2025. nominations for this year are rejected. Nominations are rejected as 2025 is not updated on SDCS.',0,'','1743161331','korobass'),(38,'Wrong nominations of subject electives','Two grade 10 students were nominated for TIA however, they are taking IT. They are Cand. 1124 Konop Crystal and Cand. 1126 Kopie Lisley.\n\nI have edited the changes on the grade 10 nomination form and uploaded. See attachment.\nPlease update the changes as I am restricted from doing that.\nThank you,\nMiss Lepon\nMarianville Secondary',0,'','1722051755','marianvilless'),(39,'STEVEN AWAPE - SDCS-HELA','REQUESTING TO DISCARD ERROR UPLOADED DATA (Gr.12 Nominations-Gr.11 Marks-Gr12. Marks entry) AND REPLACE WITH ATTACHMENT SENT...Gr12.Candidate No:101-ALBEN AUGUSTINE was missed on the nominations uploaded and this causes the problem. He is missed on the uploaded date.',0,'','1722510780','korobass'),(40,'STEVEN AWAPE-SDCS-HELA','DISCARD UPLOADED Gr12. DATA AND REPLACE.\nAs per SIBS, Candidate No: 101: ALBEN AUGUSTINE was missed on the Nominations. This causes an error on the   \nGr.11',0,'','1722511491','korobass'),(41,'STEVEN AWAPE - SDCS-HELA','CADIDATE NUMBER:101 -ALBEN AUGUSTINE was missed on the uploaded data as per SIBS. This is causing a problem in the Gr11',0,'','1722512011','korobass'),(42,'Request for Deletion of Incorrectly Uploaded Grade 12 Internal Marks','Subject: Request for Deletion of Incorrectly Uploaded Grade 12 Internal Marks\n\nDear System Administrator,\n\nI am writing to request the deletion of the Grade 12 internal marks that were recently uploaded for Maprik Secondary School. Unfortunately, I realized that the uploaded marks contain decimal numbers, which were inadvertently included during the copy-pasting process from our SASS spreadsheets. \n\nTo ensure accuracy and compliance with the marking standards, I need to re-upload the corrected marks without decimal values. Therefore, I kindly ask that you delete the currently uploaded data to allow me to submit the revised marks.\n\nThank you for your prompt assistance in resolving this matter.\n\nSincerely,  \n\nMolland Saluali  \nDeputy Principal Academic  \nMaprik Secondary School',0,'','1731370211','maprikss'),(43,'Update the School Profile','Could you please update the School Profile. The Information there is outdated in 2021. We have a new Administration and new Contact Details. I tried changing it but its not being updated as of now',0,'','1731370626','maprikss'),(44,'Grade 10 Data for 2024','There seems to be duplication of 198 appearing twice in the nomination. The initial number is 353.',0,'','1731456250','paglumadventistss'),(47,'Mr. Steven Awape _ OIC - SDCS Hela','There are several errors been oversighted in the first nomination uploaded for grade 12. The errors were identified and corrected in the brief report uploaded. Please, need your help to edit our nominations from your end using the correct information provided or else remove the first uploads containing errors and will upload again the corrected nomination excels.  Made silly errors due to being new to this excel.\nThank you for your kind understanding. \nMr. Males – DPC\nCell Phone: 72275500',0,'','1732601073','hoiebiass'),(48,'Mr. Steven Awape - OIC - SDCS Hela','There are several errors been oversighted in the first nomination uploaded for grade 10. The errors were identified and corrected in the brief report uploaded. Please, need your help to edit our nominations from your end using the correct information provided or else remove the first uploads containing errors and will upload again the corrected nomination excels.  Made silly errors due to being new to this excel.\nThank you for your kind understanding. \nMr. Males – DPC\nCell Phone: 72275500',0,'','1732601202','hoiebiass'),(49,'Mr. Steven Awape - OIC - SDCS Hela','Need your help to upload for us from your end the corrected and error free grade 12 subject nominated excel provided, please.',0,'','1732601524','hoiebiass'),(50,'Mr. Steven Awape _ OIC - SDCS Hela','Need your help to upload for us from your end the corrected and error free grade 10 subject nominated excel provided, please.',0,'','1732601633','hoiebiass'),(52,'GRADE 10  EXAM MARKS','GRADE EXAM MARKS NOT IN RIGHT COLUMNS, READJUSTMENT NEEDED. THANKS',0,'','1733713293','stconradpurenihs'),(53,'2025 SDCS','Please reset and update our schools SDCS system so we start working on our Gr 10 and 12 SIB. ASAP',0,'','1739913433','malahangtechnicalhs'),(57,'ATEVEN AWAPE - SDCS - HELA','THE YEAR - 2025 IS NOT UPDATED ON THE SDCS YEAR TEMPOLATE...AS SUCH NOMINATIONS ARE BEING DELAYED. PLESASE UPDATE THE YEAR ON THE SYSTEM.\nTHANKYOU - MR. EMMANUEL KOME - DPC/KOROBA SECONDARY-HELA',0,'','1743337774','korobass'),(58,'ADMISSION YEAR','ERROR ON ADMISSION YEAR 2025',0,'','1745320405','kuhs'),(59,'SCHOOL CODE','INCORRECT SCHOOL CODE:\n901 is WRONG -  613 is CORRECT',0,'','1745342408','professorschindlerhs'),(60,'SCHOOL CODE 901 - ERROR','Our Correct school code is 163 and not 901',0,'','1746059407','professorschindlerhs'),(61,'grade 10 nomination format','Can not download nomination format',0,'','1749807296','kagulvalleyhs'),(62,'Cannot upload grade 11 internal  marks','as I try to upload grade 11 internal marks the notification given is Error found.Marks already given for some students.As I view data for grade 11 internal marks only students subject nomination given under grade 11 internal marks,1 for subject taken and 0 for subjject not taken.If this can be verified and fixed so that i can upload tomorrow before the due date.Mr Kalu,Deputy Principal academic Kiriwina secondary school.My contact is 79396683 and my wattsapp number is 79569274.',0,'','1750233247','kiriwinahs'),(63,'Cannot upload grade 11 internal  marks','as I try to upload grade 11 internal marks the notification given is Error found.Marks already given for some students.As I view data for grade 11 internal marks only students subject nomination given under grade 11 internal marks,1 for subject taken and 0 for subjject not taken.If this can be verified and fixed so that i can upload tomorrow before the due date.Mr Kalu,Deputy Principal academic Kiriwina secondary school.My contact is 79396683 and my wattsapp number is 79569274.',0,'','1750233248','kiriwinahs'),(64,'Cannot upload grade 11 internal  marks','as I try to upload grade 11 internal marks the notification given is Error found.Marks already given for some students.As I view data for grade 11 internal marks only students subject nomination given under grade 11 internal marks,1 for subject taken and 0 for subjject not taken.If this can be verified and fixed so that i can upload tomorrow before the due date.Mr Kalu,Deputy Principal academic Kiriwina secondary school.My contact is 79396683 and my wattsapp number is 79569274.',0,'','1750233249','kiriwinahs'),(65,'Cannot upload grade 11 internal  marks','as I try to upload grade 11 internal marks the notification given is Error found.Marks already given for some students.As I view data for grade 11 internal marks only students subject nomination given under grade 11 internal marks,1 for subject taken and 0 for subjject not taken.If this can be verified and fixed so that i can upload tomorrow before the due date.Mr Kalu,Deputy Principal academic Kiriwina secondary school.My contact is 79396683 and my wattsapp number is 79569274.',0,'','1750233249','kiriwinahs'),(66,'Gr-10-Normination-James Chamers High School-Suau-2025','Error in uploading',0,'','1750302437','jamechalmerssuauhs'),(67,'Gr 9 Internal marks','Hi there\nWe kindly request the Admin to delete every information on our account so that we can upload new and correct one.\nthank you\nAssessment Coordinator\nUsino Technical Secondary',0,'','1750304900','usinotechnicalhs'),(68,'Gr 9 Internal Marks Entry-James Chalmers Memorial High-Suau','Error in uploading',0,'','1750308811','jamechalmerssuauhs'),(69,'Upload Data Issue','We face several issuse when trying to upload data. Log in is successful, but the following problems persist;\n1. can not select school name from the grade 10 data upload feature to filter, upload and save data\n2. cant access grade 12 features, when clicking Grade 12, the tab is blocked.',0,'','1750374077','banzlutheranhs'),(71,'Misima Secondary school grade 12 internal marks','When the spreadsheet was downloaded today it contains names of students that are not from Misima secondary school and also checked photos upload it has names and photos that are not Misima secondary. I guess the information is for Kiriwina secondary school',0,'','1751599996','misimahs'),(72,'grade 9 marks','trying to upload the edited format but the system said the first copy has been accepted thus indicating me not to add new white updated white page. please let me know if this is accepted.\nmiddle sepik high school \nheadmaster\nmr. KELEP Maingili',0,'','1751610331','middlesepikhs'),(75,'Grade 11 Marks','Uploaded the grade 11 marks, but the one showing is not the one I uploaded.',0,'','1752208500','poninicathagtechhs'),(76,'Student profile pictures','how can i upload.\nNeed your Assisstance',0,'','1752217865','jamechalmerssuauhs'),(77,'Grade 10 internal marks out of 400','I cannot upload the grade 10 internal marks since grade 9 internal marks were also uploaded there',0,'','1752644888','brigittihs'),(78,'OSCAR WUNDIA','MISTAKE WAS DONE WHILE NOMINATING STUDENTS AND THIS ISSUE IS PREVENTING AMRKS AND OTHER INFORMATION TO BE COMPLETED FOR UPLOADING.\nTHIS IS THE PROBLEM, INCOMPLETE GRADE 12 NOMINATION WAS UPLOADED TO GRADE 10 AND THIS IS REALLY CREATING A BIG PROBLEM FOR ENTRIES OF INFORMATION FOR BOTH GRADES.\nHOW CAN THIS ISSUE BE RESOLVED BACK TO NORMAL FOR ENTRIES.\nPLEASE, ASSIST',0,'','1753462421','greenriverss'),(79,'principal','Grade 9 Internal Marks Faulty Entry - not shown as entered\nGrade 10 Students candidate Numbers not shown as entered',0,'','1753771794','instituteofchristianacademy'),(80,'Grade 10 Science Practical Marks','I made a mistake, another student marks is uploaded on another student. How can      I correct this. I tried several times to edit but       it kept back to the incorrect entry.',0,'','1753932787','yangoruss'),(81,'Wrong Date of Birth for nominated students','Some students have their DOB in 1900 which is not correct. The correct DOB was done on the format and after been uploaded it showed the incorrect DOB. Please see attached the correct DOB',0,'','1754400935','balimoacademy'),(82,'grade 9 internal marks','errors reuploading',0,'','1754476486','tabagahs'),(85,'Grade 10 raw mark entry','Just upload the wrong marks \nPlease assist me to re upload the correct marks',0,'','1755145422','anditalehs'),(86,'MSD required students nomination form needed.','Send are copies of students nomination list for grades 10 and 12 at st francis secondary school .\nif the forms used are incorrect, can i be issued with a proper one please?',0,'','1755303298','stfrancisnukuhs'),(87,'Forms Used','This is the forms used to make students nomination.',0,'','1755303911','stfrancisnukuhs'),(88,'Deputy Principal','Admin details does not update despite several attempts',0,'','1755673993','kimbeinternational'),(89,'Gr10 Sci Practical Marks','I am unable to upload the Gr10 Sci Practical marks.',0,'','1755902162','songurahigh'),(90,'Gr10 Sci Practical Marks','can not upload the marks',0,'','1756075569','songurahigh'),(91,'FIND HARD TO UPLOAD GR.10 AND 12 INTERNAL MARKS','WHAT CAN i DO WITH WITHDRAWAL STUDENTS? SHOULD i ENTER 0 IN THEIR COLUMN. NEED CLEARITY. IT ALWAYS GIVES ME NUMERICAL ERRO ONCE I UPLOAD DATA; THANKS',0,'','1756132124','kiripiass'),(92,'FIND HARD TO UPLOAD GR.10 AND 12 INTERNAL MARKS','WHAT CAN i DO WITH WITHDRAWAL STUDENTS? SHOULD i ENTER 0 IN THEIR COLUMN. NEED CLEARITY. IT ALWAYS GIVES ME NUMERICAL ERRO ONCE I UPLOAD DATA; THANKS',0,'','1756132126','kiripiass'),(93,'Remove the admin profile','Edward Sakara had resigned from teaching.\nMeroln Mulavasa is not longer the DP Curriculum in 2025. David Mack Mondo had replace her.',0,'','1756268008','angoramss'),(94,'DECIMAL MARKS APPEARED','PLEASE REMOVE THE UPLOADED MARKS OF GRADE 12 2025 THAT I UPLOADED SO THAT I CAN RE-UPLOAD AGAIN. THIS TIME WILL BE WITHOUT DECIMAL NUMBERS',0,'','1756301946','holynamedogurass'),(95,'grade 11 estimate marks for LL','After I entered the estimate marks for candidate 172 and 173 in LL and GMX its not saving them.',0,'','1756338441','papitalaiss'),(96,'Marks already entered for some students','Cannot upload the others that have being done offline.Would you please rectify this problem and enable me to upload the other students marks for Gr9 AP1',0,'','1756367046','duauhs'),(97,'Marks already entered for some students','Cannot upload the others that have being done offline.Would you please rectify this problem and enable me to upload the other students marks for Gr9 AP1',0,'','1756367046','duauhs'),(98,'2025 Angoram Secondary School marks submission','2025 marks submitted are:\n1. Gr.12 marks\n2. Gr 10 marks\n3. Gr. 10 Sci Practical',0,'','1756649218','angoramss'),(100,'Unable to Edit','Unable to edit stds names and status for withdraws',0,'','1758257081','muainass'),(101,'Estimated Marks Not Saved','Gr12 estimated marks for repeats/transfers unable to safe for the science group',0,'','1758257188','muainass'),(102,'SDCS GRADE 10 MISSING DATA','The Grade 10 Nomination Data is not showing up.\n\nPlease response ASAP because we need to fixed and re-submit or re-upload.',0,'','1758854189','malagunatechnicalss'),(103,'Grade 11 Estimate Marks for Student VARKIA SECKRY','Please we need update on the issue updating Student Grade 11 Estimate marks for L',0,'','1758854528','malagunatechnicalss'),(104,'GRADE 10 SLF needs access on the Portal','Our Grade 10 SLF is ready for upload. Can you give access on our Portal Account so we can upload the files?',0,'','1758854713','malagunatechnicalss'),(110,'NOAS invitation letter','Currently the school have not received the student invitation letter and we are few days remaining before the grade 12 sit for their national examination. Please do update ASAP.',0,'','1759314457','kandrianhs'),(111,'NOAS workbook','Populating DAT and CES for students',0,'','1759369794','jimiss'),(115,'Subject Combination Error','I, the principal Mr. Esso Orekavala from Okapa Secondary School. I send the up to date and accurate information on the school data with students nomination and SASS already. But we have a problem on Subject combination for all my students with thier Noas account is mixed up with subject combination which subjects that is taken and not taken.\n\nPlease consider helping my school\n\nThank You,\n\nEsso Orekavala',0,'','1759736922','okapass'),(117,'Profile Photos','We are unable to upload either because there is no template available or restricted. Feedback keep popping up &quot; we are currently restricted..thanks.',0,'','1759892613','boanalutheranhigh'),(116,'Gr 12 internal marks entry 2025','Marks uploaded but says marks already been given to some students and from the NOAS checklist Grade 12 marks are ticked. Why?',0,'','1759844271','mainohanass'),(118,'GR 12 AP3 MARKS ENTERED NOT SAVED SUCCESSFULLY','Gr12 Internal Marks for 9 of our students were not successfully saved. We have tried entering and saving several times, but the marks were not saved. How can we solve this before SDCS closes?',0,'','1760012045','Guest'),(119,'SUBJECT COMBINATION','DEAR SIR/MADAM\nOUR GRADE 12 SUBJECT COMBINATION DIDNT APPEAR FOR DOING CHOICE\nPLEASE HELP',0,'','1761121488','rintebelutheranss'),(120,'username and password','forgot my username and password',0,'','1761268607','simbilangahs'),(121,'grade 10 exam marks','upload error',0,'','1762584988','daruss');


