title: SQLSTATE[HY000]: General error: 1364 Field
body: <pre><code>public function index()
  {
     $students = Student::all()-&gt;toArray();
     return view('student.index', compact('students'));   
  }
  
  /**
   * Show the form for creating a new resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function create()
  {
      return view('student.create');//
  }
  
  /**
   * Store a newly created resource in storage.
   *
   * @param  \Illuminate\Http\Request  $request
   * @return \Illuminate\Http\Response
   */
  public function store(Request $request)
  {
      $this-&gt;validate($request, [
          'first_name'            =&gt; 'required',
          'last_name'             =&gt; 'required',
          'Age'                   =&gt; 'required',
          'Address'               =&gt; 'required',
          'Grade_Level'           =&gt; 'required',
          'mothers_first_name'    =&gt; 'required',
          'mothers_last_name'     =&gt; 'required',
          'mothers_age'           =&gt; 'required',
          'fathers_first_name'    =&gt; 'required',
          'fathers_last_name'     =&gt; 'required',
          'fathers_age'           =&gt; 'required'
      ]);
  
      $student = new Student([
          'first_name'            =&gt; $request-&gt;get('first_name'),
          'last_name'             =&gt; $request-&gt;get('last_name'),
          'Age'                   =&gt; $request-&gt;get('Age'),
          'Address'               =&gt; $request-&gt;get('Address'),
          'Grade_Level'           =&gt; $request-&gt;get('Grade_Level'),
          'mothers_first_name'    =&gt; $request-&gt;get('mothers_first_name'),
          'mothers_last_name'     =&gt; $request-&gt;get('mothers_last_name'),
          'mothers_age'           =&gt; $request-&gt;get('mothers_age'),
          'fathers_first_name'    =&gt; $request-&gt;get('fathers_first_name'),
          'fathers_last_name'     =&gt; $request-&gt;get('fathers_last_name'),
          'fathers_age'           =&gt; $request-&gt;get('fathers_age')
      ]);
      $student-&gt;save();
      return redirect()-&gt;route('student.index')-&gt;with('success', 'New teacher data successfully added');
  }
  
  /**
   * Display the specified resource.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function show($id)
  {
      //
  }
  
  /**
   * Show the form for editing the specified resource.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function edit($id)
  {
  
      $student = Student::find($id);
      return view('student.edit', compact('student', 'id'));
  }
  
  /**
   * Update the specified resource in storage.
   *
   * @param  \Illuminate\Http\Request  $request
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function update(Request $request, $id)
  {
      $this-&gt;validate($request, [
          'first_name'            =&gt;  'required',
          'last_name'             =&gt;  'required',
          'Age'                   =&gt;  'required',
          'Address'               =&gt;  'required',
          'Grade_Level'           =&gt;  'required'
      ]);
  
      $student = Student::find($id);
      $student-&gt;first_name        = $request-&gt;get('first_name');
      $student-&gt;last_name         = $request-&gt;get('last_name');
      $student-&gt;Age               = $request-&gt;get('Age');
      $student-&gt;Address           = $request-&gt;get('Address');
      $student-&gt;Grade_Level       = $request-&gt;get('Grade_Level');
      $student-&gt;save();
      return redirect()-&gt;route('student.index')-&gt;with('success', 'Student data successfully updated');
  }
  
  /**
   * Remove the specified resource from storage.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function destroy($id)
  {
     $student = Student::find($id);
     $student-&gt;delete();
     return redirect()-&gt;route('student.index')-&gt;with('success', 'Data successfully deleted');
  }
  </code></pre>
  
  <p>This is my Controller i dont know why im getting error, i have also other controller with the same function but it works fine. i just recently add this mothers name, age etc part but before it was just name,age address, etc and it works fine but after i add more fillable area's im getting this error </p>
  
  <p><a href="https://i.stack.imgur.com/CakRB.jpg" rel="nofollow noreferrer">and this is the error im getting</a></p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;div class="alert alert-danger"&gt;
    &lt;button type="button" class="close" data-dismiss="alert"&gt;&amp;times;&lt;/button&gt;
    &lt;ul&gt;
     @foreach($errors-&gt;all() as $error)
      &lt;li&gt;{{$error}}&lt;/li&gt;
     @endforeach
    &lt;/ul&gt;
   &lt;/div&gt;
   @endif
   @if(\Session::has('success'))
   &lt;div class="alert alert-success"&gt;
    &lt;button type="button" class="close" data-dismiss="alert"&gt;&amp;times;&lt;/button&gt;
    &lt;p&gt;&lt;strong&gt;{{\Session::get('success')}}&lt;/strong&gt;&lt;/p&gt;
   &lt;/div&gt;
   @endif
   &lt;div class="carousel"&gt;
    &lt;div class="carousel-inner"&gt;
     &lt;img class="data-img" src="{{asset('img/adddata.png')}}"&gt;
    &lt;/div&gt;
   &lt;/div&gt;
  &lt;div class="container student-create"&gt;
   &lt;div class="students-info"&gt;
   &lt;h3&gt;Student's Personal Info&lt;/h3&gt;
   &lt;form method="post" action="{{url('student')}}"&gt;
    {{csrf_field()}}
    &lt;div class="form-group"&gt;
     &lt;div class="col-sm"&gt;
          &lt;label for="Inputfirstname"&gt;First Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="first_name" placeholder="Enter First Name"&gt;
        &lt;/div&gt;
        &lt;div class="col-sm"&gt;
          &lt;label for="Inputlastname"&gt;Last Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="last_name" placeholder="Enter Last Name"&gt;
        &lt;/div&gt;
        &lt;div class="col-sm"&gt;
          &lt;label for="Inputlastname"&gt;Age&lt;/label&gt;
          &lt;input type="number" class="form-control" name="Age" placeholder="Enter Last Name"&gt;
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
     &lt;div class="col-sm"&gt;
      &lt;label for="InputAddress"&gt;Address&lt;/label&gt;
      &lt;input type="text" class="form-control" name="Address" placeholder="Enter Address"&gt;
     &lt;/div&gt;
     &lt;div class="col-sm"&gt;
      &lt;label for="InputAddress"&gt;Grade Level/College Level&lt;/label&gt;
      &lt;select class="custom-select" name="Grade_Level"&gt;
           &lt;option selected=""&gt;Select Grade Level&lt;/option&gt;
           &lt;option&gt;Day Care 1&lt;/option&gt;
           &lt;option&gt;Day Care 2&lt;/option&gt;
           &lt;option&gt;Kinder Garten 1&lt;/option&gt;
           &lt;option&gt;Kinder Garten 2&lt;/option&gt;
           &lt;option&gt;Elementary 1&lt;/option&gt;
           &lt;option&gt;Elementary 2&lt;/option&gt;
           &lt;option&gt;Elementary 3&lt;/option&gt;
           &lt;option&gt;Elementary 4&lt;/option&gt;
           &lt;option&gt;Elementary 5&lt;/option&gt;
           &lt;option&gt;Elementary 6&lt;/option&gt;
           &lt;option&gt;Junior Highschool 1&lt;/option&gt;
           &lt;option&gt;Junior Highschool 2&lt;/option&gt;
           &lt;option&gt;Junior Highschool 3&lt;/option&gt;
           &lt;option&gt;Junior Highschool 4&lt;/option&gt;
           &lt;option&gt;Senior Highschool 1&lt;/option&gt;
           &lt;option&gt;Senior Highschool 2&lt;/option&gt;
           &lt;option&gt;College Level Information Technology 1&lt;/option&gt;
           &lt;option&gt;College Level Information Technology 2&lt;/option&gt;
           &lt;option&gt;College Level Information Technology 3&lt;/option&gt;
           &lt;option&gt;College Level Information Technology 4&lt;/option&gt;
         &lt;/select&gt;
     &lt;/div&gt;
    &lt;/div&gt;
  
    &lt;h3&gt;Student's Parents Info&lt;/h3&gt;
    &lt;div class="form-group"&gt;
     &lt;div class="col-sm"&gt;
          &lt;label for="Inputfirstname"&gt;Mothers First Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="mothers_first_name" placeholder="Enter First Name"&gt;
        &lt;/div&gt;
        &lt;div class="col-sm"&gt;
          &lt;label for="Inputfirstname"&gt;Mothers Last Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="mothers_last_name" placeholder="Enter Last Name"&gt;
        &lt;/div&gt;
        &lt;div class="col-sm"&gt;
          &lt;label for="Inputfirstname"&gt;Mothers Age&lt;/label&gt;
          &lt;input type="number" class="form-control" name="mothers_age" placeholder="Enter Age"&gt;
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
     &lt;div class="col-sm"&gt;
       &lt;label for="Inputfirstname"&gt;Fathers First Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="fathers_first_name" placeholder="Enter First Name"&gt;
     &lt;/div&gt;
     &lt;div class="col-sm"&gt;
       &lt;label for="Inputfirstname"&gt;Fathers Last Name&lt;/label&gt;
          &lt;input type="text" class="form-control" name="fathers_last_name" placeholder="Enter Last Name"&gt;
     &lt;/div&gt;
     &lt;div class="col-sm"&gt;
       &lt;label for="Inputfirstname"&gt;Fathers Age&lt;/label&gt;
          &lt;input type="number" class="form-control" name="fathers_age" placeholder="Enter Age"&gt;
     &lt;/div&gt;
    &lt;/div&gt;
    &lt;div class="form-group submit"&gt;
        &lt;button type="button submit" class="btn btn-success"&gt;
          &lt;i class="fas fa-check"&gt;&lt;/i&gt; Submit Data
        &lt;/button&gt;
    &lt;/div&gt;
   &lt;/form&gt;
  &lt;/div&gt;</code></pre>
  </div>
  </div>
  
  Table Structure</p>
  
  <p><a href="https://i.stack.imgur.com/rgBQF.jpg" rel="nofollow noreferrer">Student Model</a></p>
  
  <p>i hope you could help  me and Thank in advance </p>