# The dreaded "Before updating scaffolding from new DB schema,

**URL:** <https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539>\
**Category:** Rails\
**Created:** [January 16, 2006, 3:42am UTC](https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539 "2006-01-16T03:42:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbelsham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dbelsham](https://www.ruby-forum.com/u/dbelsham)\
**Post date:** [January 16, 2006, 3:42am UTC](https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539/1 "2006-01-16T03:42:51Z")

</div>

Hi  
Can any one help me with this? I think that this is soemthing quite  
simple as there is quite abit traffic about this on the web and everyone  
sems to figure it out. I have tried most of the solutions that I can  
find. but nothing.

I have mysql 5.0.11 working on linux redhat 9. ruby is working rails  
install mysql library seem to be there.  
to some trying rt get mysql to install need to point the installer to  
the correct mysql. I have the table created an am usein the example in  
linux journal to test it out.

I am new to ruby and rails but think it may have potential for some  
ideas I have.

[derek@192 Blog]$ script/generate scaffold Blog Admin  
exists app/controllers/  
exists app/helpers/  
exists app/views/admin  
exists test/functional/  
dependency model  
exists app/models/  
exists test/unit/  
exists test/fixtures/  
identical app/models/blog.rb  
identical test/unit/blog\_test.rb  
identical test/fixtures/blogs.yml  
error Before updating scaffolding from new DB schema, try  
creating a table for your model (Blog)

my database

# MySQL (default setup). Versions 4.1 and 5.0 are recommended.

# 

# Get the fast C bindings:

# gem install mysql

# (on OS X: gem install mysql – --include=/usr/local/lib)

# And be sure to use new-style password hashing:

# [http://dev.mysql.com/doc/refman/5.0/en/old-client.html](http://dev.mysql.com/doc/refman/5.0/en/old-client.html)

development:  
adapter: mysql  
database: blog\_development  
username: derek  
password: wcug13  
socket: /tmp/mysql.sock

# Connect on a TCP socket. If omitted, the adapter will connect on

the

# domain socket given by socket instead.

#host: localhost  
#port: 3306

# 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: mysql  
database: blog\_test  
username: derek  
password: wcug13  
socket: /tmp/mysql.sock

production:  
adapter: mysql  
database: blog\_production  
username: derek  
password: wcug13  
socket: /tmp/mysql.sock

Derek

---

<div class="post-metadata">

**Author:** ![dbelsham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dbelsham](https://www.ruby-forum.com/u/dbelsham)\
**Post date:** [January 16, 2006, 5:12am UTC](https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539/2 "2006-01-16T05:12:48Z")

</div>

You just need to create a ‘blog’ table in your database before running  
the scaffold generator.

It should have an ‘id’ column at least.

BTW…I wouldn’t recommend posting the password to your mysql server in  
the mailing list, even if it is just a development machine.

---

<div class="post-metadata">

**Author:** ![dbelsham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dbelsham](https://www.ruby-forum.com/u/dbelsham)\
**Post date:** [January 16, 2006, 6:07am UTC](https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539/3 "2006-01-16T06:07:14Z")

</div>

Are you sure the database table exists and the username/password is  
correct?

Try connecting to mysql from the command prompt using that username and  
password and see what happens.

Cheers

Tim

---

<div class="post-metadata">

**Author:** ![dbelsham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dbelsham](https://www.ruby-forum.com/u/dbelsham)\
**Post date:** [January 16, 2006, 7:48am UTC](https://www.ruby-forum.com/t/the-dreaded-before-updating-scaffolding-from-new-db-schema/52539/4 "2006-01-16T07:48:50Z")

</div>

Kevin O. wrote:

> You just need to create a ‘blog’ table in your database before running  
> the scaffold generator.
> 
> It should have an ‘id’ column at least.
> 
> BTW…I wouldn’t recommend posting the password to your mysql server in  
> the mailing list, even if it is just a development machine.

One thousand thank yous. The problem was I did create a “Blog” table  
instad of a “blog” table. I suspect that I had some library problems at  
first as well.

Any way thanks again  
Derek