Mysql2psql: conversion failed: undefined method `hour' for nil:NilClass

[thiagobonfante]

Hi,

I'm trying to convert a database but still getting this error:

"Mysql2psql: conversion failed: undefined method `hour' for nil:NilClass"

Regards,

Thiago Bonfante

[mraaroncruz]

I just received this error as well. I will post something if I find a fix.

[thiagobonfante]

pferdefleisch

The problem is related to columns with type "TIME". Like me, you can convert those columns to "DATETIME" and keep going with the convertion.

At least, this workaround was good enough to me.

Regards,

Thiago Bonfante

[mraaroncruz]

Thanks a lot. That totally will work for me. :)

[thiagobonfante]

Glad to help ;)

[nodrog]

Any news on this, i am having the same problem.

Thiago are you saying to convert the DATETIME in the MySql database to TIME or the other way round.

Many thanks

[settermjd]

Thanks. After making the conversion, all's worked well.