search

maxlapshin / mysql2postgres

Mysqldump, writing in postgresql format
MIT License
711 stars 156 forks source link

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

Open thiagobonfante opened 12 years ago

thiagobonfante commented 12 years ago

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 commented 12 years ago

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

thiagobonfante commented 12 years ago

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 commented 12 years ago

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

thiagobonfante commented 12 years ago

Glad to help ;)

nodrog commented 12 years ago

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 commented 11 years ago

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