title: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
body: <p>I am using 000webhost.com and I am using phpMyAdmin there. I am getting this error from MySQL when I run my PHP script as the title says:</p>
  <blockquote>
  <p>Column count of mysql.proc is wrong. Expected 20, found 16.</p>
  <p>The table is probably corrupted.</p>
  </blockquote>
  <p>Is there any solution for this?</p>
  <pre><code>&lt;?php
  $username=&quot;usrname&quot;;
  $password=&quot;passwd&quot;;
  $database=&quot;a1xxxxx_mydb&quot;;
  $host=&quot;mysqlxx.000webhost.com&quot;;
  mysql_connect($host,$username,$password);
  @mysql_select_db($database) or die( &quot;Unable to select database&quot;);
  if (isset($_GET[&quot;userLatitude&quot;]) &amp;&amp; isset($_GET[&quot;userLongitude&quot;])) {
  
   $userLatitude=$_GET['userLatitude']; 
   $userLongitude=$_GET['userLongitude']; 
   $result = mysql_query(&quot;SELECT locationName, ( 6371 * acos( cos( radians(floatval(     $userLatitude) )) * cos( radians( locationLatitude ) ) * cos( radians( locationLongitude ) - radians( floatval($userLatitude)) ) + sin( radians(floatval($userLongitude)) ) * sin( radians( locationLatitude) ) ) ) AS distance 
           FROM Location HAVING distance &lt; 2 ORDER BY distance LIMIT 0 ,20&quot;) or die(mysql_error()); 
  echo $result;
  
   // check for empty result
  if (mysql_num_rows($result) &gt; 0) {
     // looping through all results
     // products node
    $response[&quot;Location&quot;] = array();
  
    while ($row = mysql_fetch_array($result)) {
      // temp user array
      $product = array();
      $product[&quot;locationName&quot;] = $row[&quot;locationName&quot;];
      $product[&quot;locationInfo&quot;] = $row[&quot;locationInfo&quot;];
      $product[&quot;locationLatitude&quot;] = $row[&quot;locationLatitude&quot;];
      $product[&quot;locationLongitude&quot;] = $row[&quot;locationLongitude&quot;];
      $product[&quot;locationPic&quot;] = $row[&quot;locationPic&quot;];
      $product[&quot;city&quot;] = $row[&quot;city&quot;];
  
      // push single product into final response array
      array_push($response[&quot;Location&quot;], $product);
   }
   // success
   $response[&quot;success&quot;] = 1;
  
     // echoing JSON response
     echo json_encode($response);
   } else {
  // no products found
  $response[&quot;success&quot;] = 0;
  $response[&quot;message&quot;] = &quot;No products found&quot;;
  
  // echo no users JSON
  echo json_encode($response);
   }
   }
    else {
      // required field is missing
     $response[&quot;success&quot;] = 0;
     $response[&quot;message&quot;] = &quot;Required field(s) is missing&quot;;
  
    // echoing JSON response
    echo json_encode($response);
   }
  mysql_close();
  ?&gt;
  </code></pre>