Hello, Excuse me if this is obvious. I have tried to find an answer to this problem without luck. A google search does not seem to show this as a common problem. I have an existing database, with a schema that has binary columns, and a default value for those columns (in this case "0000000000000000"). I am trying to extract the schema using "rake --trace db:schema:dump", and am getting the following error: ** Execute db:schema:dump rake aborted! binary columns cannot have a default value: "0000000000000000" Clearly it does not like default binary values; but why is this? Should I be doing something different in order to hook ROR up to my existing database? Thanks in advance, Oliver --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
This seems to be a bug, add a ticket at the Rails lighthouse -> http://rails.lighthouseapp.com/dashboard On Sat, Oct 25, 2008 at 10:54 PM, oliver <oliverfriedrichs-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > Hello, > > Excuse me if this is obvious. I have tried to find an answer to this > problem without luck. A google search does not seem to show this as a > common problem. I have an existing database, with a schema that has > binary columns, and a default value for those columns (in this case > "0000000000000000"). > > I am trying to extract the schema using "rake --trace db:schema:dump", > and am getting the following error: > > ** Execute db:schema:dump > rake aborted! > binary columns cannot have a default value: "0000000000000000" > > Clearly it does not like default binary values; but why is this? > Should I be doing something different in order to hook ROR up to my > existing database? > > Thanks in advance, > > Oliver > > > >-- Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) João Pessoa, PB, +55 83 8867-7208 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thank you Maurício, would you happen to have a suggestion for a workaround in the mean time? Oliver On Oct 26, 3:49 am, "Maurício Linhares" <mauricio.linha...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> This seems to be a bug, add a ticket at the Rails lighthouse ->http://rails.lighthouseapp.com/dashboard > > > > On Sat, Oct 25, 2008 at 10:54 PM, oliver <oliverfriedri...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hello, > > > Excuse me if this is obvious. I have tried to find an answer to this > > problem without luck. A google search does not seem to show this as a > > common problem. I have an existing database, with a schema that has > > binary columns, and a default value for those columns (in this case > > "0000000000000000"). > > > I am trying to extract the schema using "rake --trace db:schema:dump", > > and am getting the following error: > > > ** Execute db:schema:dump > > rake aborted! > > binary columns cannot have a default value: "0000000000000000" > > > Clearly it does not like default binary values; but why is this? > > Should I be doing something different in order to hook ROR up to my > > existing database? > > > Thanks in advance, > > > Oliver > > -- > Maurício Linhareshttp://alinhavado.wordpress.com/(pt-br) |http://blog.codevader.com/(en) > João Pessoa, PB, +55 83 8867-7208--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Oct 26, 6:01 pm, oliver <oliverfriedri...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Thank you Maurício, would you happen to have a suggestion for a > workaround in the mean time? >This is probably an artefact of the fact that mysql blob columns genuinely cannot have defaults (http://dev.mysql.com/doc/refman/5.0/en/ blob.html). BINARY/VARBINARY columns can, but rails does not differentiate between binary and blob - it would recreate the column as a blob and so defaults don''t make sense) Fred> Oliver > > On Oct 26, 3:49 am, "Maurício Linhares" <mauricio.linha...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > This seems to be a bug, add a ticket at the Rails lighthouse ->http://rails.lighthouseapp.com/dashboard > > > On Sat, Oct 25, 2008 at 10:54 PM, oliver <oliverfriedri...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Hello, > > > > Excuse me if this is obvious. I have tried to find an answer to this > > > problem without luck. A google search does not seem to show this as a > > > common problem. I have an existing database, with a schema that has > > > binary columns, and a default value for those columns (in this case > > > "0000000000000000"). > > > > I am trying to extract the schema using "rake --trace db:schema:dump", > > > and am getting the following error: > > > > ** Execute db:schema:dump > > > rake aborted! > > > binary columns cannot have a default value: "0000000000000000" > > > > Clearly it does not like default binary values; but why is this? > > > Should I be doing something different in order to hook ROR up to my > > > existing database? > > > > Thanks in advance, > > > > Oliver > > > -- > > Maurício Linhareshttp://alinhavado.wordpress.com/(pt-br) |http://blog.codevader.com/(en) > > João Pessoa, PB, +55 83 8867-7208--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---