Jason N
2009-Apr-17 05:42 UTC
Rails 1.2.3 ''Depot'' application > Can''t create table ''.\depot_development\products.frm''
So I''m driving myself crazy over the ''Depot'' application in AWDWR (Agile Web Development With Rails) for Rails 1.2. I can''t run my migration script (001_create_products.rb). I''m receiving the following error when attempting to run the rake db:migrate command on page 75 of the book: C:\Rails\rails_apps\depot>rake db:migrate (in C:/Rails/rails_apps/depot) C:/Rails/rails_apps/depot/config/boot.rb:26:Warning: Gem::SourceIndex#search support for String patterns is deprecated == CreateProducts: migrating =================================================-- create_table(:products) rake aborted! Mysql::Error: Can''t create table ''.\depot_development \products.frm'' (errno: 121): CREATE TABLE products (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `image_url` varchar(255) DEFAULT NULL) ENGINE=InnoDB The MySQL errno: 121 is a foreign key error. I''ve googled and googled this problem, with nothing useful related to the migration. I have a feeling there''s going to be a problem between my versions, I''ve outlined them below in the hope that something obvious jumps out, else I''m going to uninstall and re-install it all. Tried with Rails 2.2, simply couldn''t quite handle the scaffold problems (pg 76-77), so decided to revert back to Rails 1.2.3 - to achieve this I ran the following: gem uninstall rails -v=2.2.2 gem install rails -v=1.2.3 These are the versions I''m running below (MySQL courtesy of InstantRails 2.0): C:\Rails\rails_apps\depot>ruby -v ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] C:\Rails\rails_apps\depot>rails -v Rails 1.2.3 C:\Rails\rails_apps\depot>c:\Rails\mysql\bin\mysqladmin.exe -V c:\Rails\mysql\bin\mysqladmin.exe Ver 8.41 Distrib 5.0.27, for Win32 on ia32 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Jason N
2009-Apr-17 23:34 UTC
Re: Rails 1.2.3 ''Depot'' application > Can''t create table ''.\depot_development\products.frm''
Nah don''t worry about it, I''m going to make my way forward with Rails 2.2 and learning the new way scaffolding works. Cheers! J On Apr 17, 5:42 pm, Jason N <freezingki...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> So I''m driving myself crazy over the ''Depot'' application in AWDWR > (Agile Web Development With Rails) for Rails 1.2. I can''t run my > migration script (001_create_products.rb). > > I''m receiving the following error when attempting to run the rake > db:migrate command on page 75 of the book: > > C:\Rails\rails_apps\depot>rake db:migrate > (in C:/Rails/rails_apps/depot) > C:/Rails/rails_apps/depot/config/boot.rb:26:Warning: > Gem::SourceIndex#search support for String patterns is deprecated > == CreateProducts: migrating > =================================================> -- create_table(:products) > rake aborted! > Mysql::Error: Can''t create table ''.\depot_development > \products.frm'' (errno: 121): CREATE TABLE products (`id` int(11) > DEFAULT NULL auto_increment PRIMARY > KEY, `title` varchar(255) DEFAULT NULL, `description` text DEFAULT > NULL, `image_url` varchar(255) DEFAULT NULL) ENGINE=InnoDB > > The MySQL errno: 121 is a foreign key error. I''ve googled and googled > this problem, with nothing useful related to the migration. > > I have a feeling there''s going to be a problem between my versions, > I''ve outlined them below in the hope that something obvious jumps out, > else I''m going to uninstall and re-install it all. > > Tried with Rails 2.2, simply couldn''t quite handle the scaffold > problems (pg 76-77), so decided to revert back to Rails 1.2.3 - to > achieve this I ran the following: > > gem uninstall rails -v=2.2.2 > gem install rails -v=1.2.3 > > These are the versions I''m running below (MySQL courtesy of > InstantRails 2.0): > > C:\Rails\rails_apps\depot>ruby -v > ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] > > C:\Rails\rails_apps\depot>rails -v > Rails 1.2.3 > > C:\Rails\rails_apps\depot>c:\Rails\mysql\bin\mysqladmin.exe -V > c:\Rails\mysql\bin\mysqladmin.exe Ver 8.41 Distrib 5.0.27, for Win32 > on ia32--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---