title: WordPress database error: [Column count doesn't match value count at row 1]
body: <p>I have a table that looks like this. They all have default 0 value for some reason:</p>
  
  <p><a href="https://i.stack.imgur.com/23KBz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/23KBz.png" alt="enter image description here"></a></p>
  
  <p>In wordpress I'm inserting new value of score into a table like so:</p>
  
  <pre><code>$scoree = $_POST['whatever'];
  global $wpdb;
  $table = 'username';
  $save = $wpdb-&gt;insert($table, $scoree);
  wp_send_json(['save' =&gt; $save, '$_POST' =&gt; $_POST ]);
  }
  </code></pre>
  
  <p>But this gives me an error when alerting AJAX response in javascript file:</p>
  
  <blockquote>
    <p>Got this from the server: <strong>WordPress database error:</strong> [Column count doesn&#039;t match value count at row 1]<br /><code>INSERT INTO <code>username</code> (``) VALUES ()</code></p>{"save":false,"$_POST":{"action":"my_action","whatever":"9"}}</p>
  </blockquote>
  
  <p>My AJAX in JS file:</p>
  
  <pre><code>var data = {
          'action': 'my_action',
          'whatever' : user1.currentScore
        }
        jQuery.post(my_ajax_object.ajax_url, data, function(response) {
              alert('Got this from the server: ' + response);
          });
      }
  </code></pre>
  
  <p>Any ideas why is this hapenning? </p>