Lorraine Williams

Updated March 28, 2018 18:17

My MySQL sourced query is throwing an exception

Answered

Follow

I receive the following MySQL exception: Exception collecting data for query. Why is this?

• Official comment

  

  Lorraine Williams March 28, 2018 22:15

  This may be due to some timestamp values in your source MySQL database not actually being timestamps. 

  There is a setting you can add into the MySQL database properties within Knowi to set the behaviour of 00:00 timestamps to treat those as nulls. That could do the trick here (if you are not able to fix the data). Here's how to do it: http://recordit.co/eac26Mnmic

  Comment actions Permalink

Please sign in to leave a comment.