General developer forum

• line 1092 of \lib\dml\mysqli_native_moodle_database.php: dml_write_exception thrown
• line 1131 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
• line 129 of \attendance\attendentry.php: call to mysqli_native_moodle_database->insert_record()

Im also attaching the code. please help me

<script language="javascript">
function sveatt()
{
document.list.saveatt.value="saveatt";
document.list.submit();
}
     function fill10(obj)
{

//a=document.list.mcnt.value;
a=obj;
//alert(a);
//alert(document.list.mcnt.value);
clsstr=document.list.mcnt.value-1;
  //  alert(clsstr);
  //   alert(document.list.ab1.value);
    for (i = 1; i <= clsstr; i++)
    {
    
                     
    eval("document.list.ab"+i+".value='A'");
            //document.list.a"+i+".value"="A";
            //field[i].value = "A";
        
        }
        }   
    
     function fill11(obj)
{

//a=document.list.mcnt.value;
a=obj;
//alert(a);
//alert(document.list.mcnt.value);
clsstr=document.list.mcnt.value-1;
  //  alert(clsstr);
  //   alert(document.list.ab1.value);
    for (i = 1; i <= clsstr; i++)
    {
    
                     
    eval("document.list.ab"+i+".value='P'");
            //document.list.a"+i+".value"="A";
            //field[i].value = "A";
        
        }
        }   

</script>
<script language="JavaScript" src="calendar_eu.js"></script>
<link rel="stylesheet" href="calendar.css">
<script language="JavaScript" src="hints.js"></script>
<script language="JavaScript" src="hints_cfg.js"></script>

<form method=post  name=list>

<?php
       require_once('../config.php'); //this assumes your page is in a sub dir.
       
       require_once $CFG->dirroot . '/user/profile/lib.php';
       require_once($CFG->libdir.'/csvlib.class.php');
       if($USER->id == 0)
    header('Location: /login/index.php');
    $PAGE->set_title("My Courses");
$PAGE->set_heading($SITE->fullname);
             global $USER, $CFG, $DB;
echo $OUTPUT->header();           //Show the moodle header
             $attendance = new stdClass();
//$sql = "SELECT mdl_role_assignments.userid, mdl_user.username, mdl_user.firstname
//FROM (((mdl_role INNER JOIN mdl_enrol ON mdl_role.ID = mdl_enrol.roleid) INNER JOIN mdl_course ON mdl_enrol.courseid = mdl_course.ID) INNER JOIN mdl_role_assignments ON mdl_role.ID = mdl_role_assignments.roleid) INNER JOIN mdl_user ON mdl_role_assignments.userid = mdl_user.ID
//where mdl_course.id='" . $_SESSION['views'] . "'  GROUP BY mdl_role_assignments.userid, mdl_user.username, mdl_user.firstname, mdl_role.ID, mdl_course.ID, mdl_course.idnumber, mdl_course.fullname";
$sql="SELECT mdl_role_assignments.userid, mdl_user.username, mdl_user.firstname, mdl_role.ID, mdl_course.ID, mdl_course.idnumber, mdl_course.fullname
FROM ((((mdl_role INNER JOIN mdl_enrol ON mdl_role.id = mdl_enrol.roleid) INNER JOIN mdl_role_assignments ON mdl_role.id = mdl_role_assignments.roleid) INNER JOIN mdl_course ON mdl_enrol.courseid = mdl_course.id) INNER JOIN mdl_user ON mdl_role_assignments.userid = mdl_user.id) INNER JOIN mdl_user_enrolments ON (mdl_enrol.id = mdl_user_enrolments.enrolid) AND (mdl_role_assignments.userid = mdl_user_enrolments.userid)
GROUP BY mdl_role_assignments.userid, mdl_user.username, mdl_user.firstname, mdl_role.ID, mdl_course.ID, mdl_course.idnumber, mdl_course.fullname
HAVING (((mdl_course.ID)='" . $_SESSION['views'] . "'))";



echo $sql;
              $res1 = $DB->get_records_sql($sql);
                        
              ?>
              <center>
              <table><tr><td><input type=text name="d1" readonly size="9" >
              
              <script language="JavaScript">
    new tcal ({
        // form name
        'formname': 'list',
        // input name
        'controlname': 'd1'
    });

    </script>    
</td></tr></table>
              
            <table width=60% border=1>
            <tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=center >
 
<font face="Verdana" size="2" ><b><a href=# title="All Absent" onclick="fill10('ab')" >A's</a>
<a href=# onclick="fill11('ab')" title="All Present">P's</a>

</b>
</td>
</tr>
            <tr><td width=10%><center><b>Sno</td><td width=10%><center><b>ID</td>
                                <td width=80%><center><b>Name</td>
                                <td width=10%><center><b>Attend</td></tr>    
             <?php
             $i=1;
foreach($res1 as $abc1){
                    $ab="ab".$i;
                    
?>

                        <tr>        
                                <?php
                                
echo "<td > <font color='black' face=verdana size=2 color='#000000'><center>".$i."</td>" ;
echo "<td > <font color='black' face=verdana size=2 color='#000000'><center>".$abc1->username."</td>";
echo "<td > <font color='black' face=verdana size=2 color='#000000'><left>".$abc1->firstname."</td>";
echo "<td > <font color='black' face=verdana size=2 color='#000000'><center><input type=text  name='$ab' size=1></td>";
               if(isset($_REQUEST['saveatt']) && $_REQUEST["saveatt"]=='saveatt')
              {
             
              //echo "In Save Mode";
             $attendance->enrol = $abc1->username;
             $attendance->name = $abc1->firstname;
                     $DB->insert_record('attendance2',$attendance);
                
              }
 $i++;
}
   ?>
   <input type="hidden" name="saveatt">
   <input type="hidden" id="mcnt" name="mcnt" value="<?php echo $i; ?>">
    <input type="hidden" id="enrol" name="enrol" value="<?php echo $abc1->username; ?>">
   <input type="hidden" id="fname" name="fname" value="<?php echo $abc1->firstname; ?>">
  </tr></table>
   <table><tr><td><input type=button name='sve' value='Save' onclick='sveatt()'></td></tr></table>

              <?php
              //echo "aaa".$_POST["saveatt"];
                
             
              
             
 echo $OUTPUT->footer();                //show the moodle footer.
?>