sql scan err: []uint8 into *time.Time about xo HOT 5 CLOSED

Is there an index missing in the schema you provided? I had no trouble generating models from the provided schema, however the SomeTablesBySomeString method isn't there -- so I'm assuming you're creating an index on some_string?

For what it's worth, the error you have listed indicates column 1, which I believe is the created field. I modified the code accordingly, and had no problems with it. It could be an issue with the version of MySQL you are using. For what it's worth, I've been doing my testing against MariaDB 10.0.23-0ubuntu0.15.10.1. I'm fairly certain it should work just fine with any other MySQL compatible client.

The Scan method delegates to the actual sql driver. If there is an issue there, I'm sure we can come up with a workaround if there's some kind of incompatibility with timestamp columns on whatever version of MySQL you're using.

from xo.

I would like to fix this, but I cannot do so without the requested information -- namely the MySQL version you are using. I cannot reproduce this in my environment, and I am not able to test every MySQL/MariaDB/Percona/etc version that exists out there.

from xo.

This is not an issue with xo -- I just realized that you must pass the mysql driver the parseTime=true parameter. Please see examples/mysql/booktest.go where the sql.Open call is.

from xo.

Please note I just updated the examples to use dburl to open the database connection. It works the same as sql.Open, except that it processes a URL instead of a driver and dsn string.

from xo.

sorry for my unresponsiveness! Your solution is perfect, thanks for taking the time and figuring that out. Glad to see it was an error on my part and not something wrong with the library. Thanks!

from xo.