Forum: Ruby on Rails Rails 1.2.3 'Depot' application > Can't create table '.\depot_development\products.frm'

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Jason N (Guest)
on 2009-04-17 11:57
(Received via mailing list)
So I'm driving myself crazy over the 'Depot' application in AWDWR
(Agile Web D. 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)
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)
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
Jason N (Guest)
on 2009-04-18 03:35
(Received via mailing list)
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.


This topic is locked and can not be replied to.