My MySQL sourced query is throwing an exceptionAnswered
I receive the following MySQL exception: Exception collecting data for query. Why is this?
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/eac26MnmicComment actions
Please sign in to leave a comment.