Problem using .new - p101 Lenz

[zoejessica]

Hi, this is the response I get when trying to create a new instance of the Story class, as per p101 of Patrick Lenz's book. It looks like something in my setup is screwy – can anyone help me figure out what's wrong? Thank you! Zoë

>> class Story < ActiveRecord::Base; end
=> nil
>> story = Story.new
ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalid
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/sqlite_adapter.rb:365:in `table_structure'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/core_ext/object/misc.rb:23:in `returning'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/sqlite_adapter.rb:364:in `table_structure'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/sqlite_adapter.rb:215:in `columns'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:763:in `columns'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:2060:in `attributes_from_column_definition_without_lock'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/locking/optimistic.rb:45:in `attributes_from_column_definition'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1502:in `initialize_without_callbacks'
from /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/callbacks.rb:225:in `initialize'
from (irb):2:in `new'
from (irb):2

[ruby-lang]

Do you have a sqlite-ruby gem installed? How about SQLite itself?

[zoejessica]

Ah... I was attempting, clearly not very successfully, to use mysql. Any idea how I get ruby to use the mysql that I've installed?

[Luke Redpath]

Have you configured your database.yml properly and created the schema you require?

[zoejessica]

Ah. Durrrr. Yes, that turned out to be it –&#160;Ruby was still trying to use sqlite instead of mysql, as specified in the database.yml file. It's all working perfectly now.

Thanks so much for your help Luke!

[Weenee]

How would I configure the Database.yml file? I'm having the same error message....saying can not find stories Table.


I must have overlooked a step but dont know which one.....I've been struggling with this all day long.

[Fenrir2]

Easy. database.yml is in the config folder. Open it with your text editor and replace 'sqlite' with 'mysql'. You may also have to set your database name.

[Weenee]

This is my database.yml file in the RailsApp >> Shovell >> Config>> Database.yml

Where would I chage to Mysql...just in the adapter line ? Sorry for these nubish questions. i appreciate the help very much. thanks


# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: sqlite3
database: db/development.sqlite3
timeout: 5000

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
adapter: sqlite3
database: db/test.sqlite3
timeout: 5000

production:
adapter: sqlite3
database: db/production.sqlite3
timeout: 5000

[pjleonhardt]

it would be

adapter: mysql
database: shovell_development

(no timeout)

If you create your rails app with

rails shovell -d mysql

It will generate the correct database.yml file. The change to sqlite happened in Rails 2.0.2

[Weenee]

I had rails 2.02 installed the first time, but when I encountered this problem, I thought it had to do with my version...I thought I read that some functionality are the same in 2.02 vs 1.86 so I deleted rails from my comp and reinstalled 1.86...I guess I shouldn't have donethat?.

what should I do???? Delete my rails app and reinstall again with 2.02? and start all over? Starting over and getting to this point is pretty quick, but if I dont have to restart the install again, that would be great. Please let me know what I should do first? change my Database.yml file or reinstall?

Sorry for the nubbish questions...I'm a graphic Designer wondering in the world of Scripting, with the hopes of being a Web Developer one day.

[pjleonhardt]

Well, first of all, you're confusing ruby (1.8.6) with rails (2.0.2). They are two combined, but different things. Ruby is a language, just like PHP. Ruby on Rails (RoR, or just "rails") utilizes ruby and creates a framework on top of the language that gives your constructs and conventions, to help you program (a PHP example would be CakePHP, or Zend Framework).

Second, to rebegin an application, you would not have to uninstall Rails, you would simple delete the shovell directory that you have created, and recreate it with the rails command.

That said, you do not need to recreate your application, just fix your database.yml file, as that is the only location that rails uses to determine your database.

development:
  adapter: mysql
  database: cia_development
  host: localhost
  username: root
  password:
 	
 test:
  adapter: mysql
  database: cia_test
  host: localhost
  username: root
  password:
 	
  production:
    adapter: mysql
    database: cia_production
    host: localhost
    username: root
    password:

Where cia should be changed to shovell in this case, since that is the name of your application

[Weenee]

Thank you for the help guys.

My solution was to delete the Shovell folder in the Railsapp folder and start fresh. But prior to me creating the mysql (before I typed in $mysql -u root) I opened up that Database.yml file and changed the necessary changes. Then proceeded on with the book.

From reading page 91, it wasn't apparent to me and the original poster to do anything, but look at a file. Maybe that section should be more clearer



Thanks again