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

Question

thiagobonfante opened this issue 13 years ago · 6 comments

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

Answer 1 · 2012-02-06T17:50:55.000Z

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

Answer 2 · 2012-02-06T19:41:33.000Z

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

Answer 3 · 2012-02-06T19:44:47.000Z

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

Answer 4 · 2012-02-06T20:01:56.000Z

Glad to help ;)

Answer 5 · 2012-10-02T19:55:39.000Z

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

Answer 6 · 2013-04-11T03:25:08.000Z

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