title: Pentaho DI - Table Input error "couldn't get row from result set"
body: <p>I get an error in Pentaho Data Integration while creating an ETL that extracts from a MySQL database.</p>
  
  <p>Specifically, I get an error in the VERY first step called "Table Input". The connection is fine so I know that is not the problem. I get a problem with even the very first row.</p>
  
  <p>This paragraph is part of the log of the error:</p>
  
  <pre><code>2017/01/11 12:26:00 - IN R.A.L..0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Unexpected error
  2017/01/11 12:26:00 - IN R.A.L..0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
  2017/01/11 12:26:00 - IN R.A.L..0 - Couldn't get row from result set
  2017/01/11 12:26:00 - IN R.A.L..0 - 
  2017/01/11 12:26:00 - IN R.A.L..0 - Unable to get value 'Date' from database resultset, index 63
  2017/01/11 12:26:00 - IN R.A.L..0 - Value '0000-00-00' can not be represented as java.sql.Timestamp
  2017/01/11 12:26:00 - IN R.A.L..0 - 
  2017/01/11 12:26:00 - IN R.A.L..0 - 
  </code></pre>
  
  <p>I can "suppose" it is a value in the row declared as timestamp that has a 0000-00-00, but I checked and double checked, and that is not it! I do have a timestamp but its value is not 0000-00-00 as it says in the log, and the one column that does have a 0000-00-00 is not a timestamp but a Date, so...</p>
  
  <p>I'm obviously missing something, otherwise I wouldn't be asking, so thanks in advance for your help!!!</p>