db create ERROR in "Creating a Rails 2.0 Ruby Weblog in 10 Minutes"

[tonylc]

Hey guys,
  I'm new to both ruby on rails AND netbeans.  I started following the tutorial

http://blogs.sun.com/divas/entry/creating_a_rails_2_0

and updated my netbeans with

ruby 1.8.6
rails 2.0

and then when following the tutorial and I get to the part where i'm creating the db....Run Rake Task > db > create.  I get the following error

(in C:/Documents and Settings/Administrator/Desktop/rubyweblog)

Couldn't create database for {"encoding"=>"utf8", "username"=>"tony", "adapter"=>"mysql", "host"=>"localhost", "password"=>"tony", "database"=>"rubyweblog_development"}, charset: utf8, collation: utf8_general_ci (if you set the charset manually, make sure you have a matching collation).   Any help would be greatly appreciated!

Thanks!
Tony

PS  My yml file is very basic with the following

development:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_development
  username: tony
  password: tony
  host: localhost

test:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_test
  username: tony
  password: tony
  host: localhost

production:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_production
  username: tony
  password: tony
  host: localhost

[rest]

I'm getting this same error. I'd appreciate hearing about how you solve this problem. Thanks.
gk

tonylc wrote:

Hey guys,
  I'm new to both ruby on rails AND netbeans.  I started following the
tutorial

http://blogs.sun.com/divas/entry/creating_a_rails_2_0

and updated my netbeans with

ruby 1.8.6
rails 2.0

and then when following the tutorial and I get to the part where i'm
creating the db....Run Rake Task > db > create.  I get the following error

(in C:/Documents and Settings/Administrator/Desktop/rubyweblog)

Couldn't create database for {"encoding"=>"utf8", "username"=>"tony",
"adapter"=>"mysql", "host"=>"localhost", "password"=>"tony",
"database"=>"rubyweblog_development"}, charset: utf8, collation:
utf8_general_ci (if you set the charset manually, make sure you have a
matching collation).   Any help would be greatly appreciated!

Thanks!
Tony

PS  My yml file is very basic with the following

development:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_development
  username: tony
  password: tony
  host: localhost

test:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_test
  username: tony
  password: tony
  host: localhost

production:
  adapter: mysql
  encoding: utf8
  database: rubyweblog_production
  username: tony
  password: tony
  host: localhost

[indiehead]

sure it's something simple, hope you fix it,

on a later note i should probably post my blogging engine to github, it runs fine on rails 2.1.1 / ruby 1.8.7,

will let you know when i do,




John.
www.red91.com

2008/10/14 rest <restycena@...>

I'm getting this same error. I'd appreciate hearing about how you solve this
problem. Thanks.
gk


tonylc wrote:
>
> Hey guys,
>   I'm new to both ruby on rails AND netbeans.  I started following the
> tutorial
>
> http://blogs.sun.com/divas/entry/creating_a_rails_2_0
>
> and updated my netbeans with
>
> ruby 1.8.6
> rails 2.0
>
> and then when following the tutorial and I get to the part where i'm
> creating the db....Run Rake Task > db > create.  I get the following error
>
> (in C:/Documents and Settings/Administrator/Desktop/rubyweblog)
>
> Couldn't create database for {"encoding"=>"utf8", "username"=>"tony",
> "adapter"=>"mysql", "host"=>"localhost", "password"=>"tony",
> "database"=>"rubyweblog_development"}, charset: utf8, collation:
> utf8_general_ci (if you set the charset manually, make sure you have a
> matching collation).   Any help would be greatly appreciated!
>
> Thanks!
> Tony
>
> PS  My yml file is very basic with the following
>
> development:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_development
>   username: tony
>   password: tony
>   host: localhost
>
> test:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_test
>   username: tony
>   password: tony
>   host: localhost
>
> production:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_production
>   username: tony
>   password: tony
>   host: localhost
>
>

--
View this message in context: http://www.nabble.com/db-create-ERROR-in-%22Creating-a-Rails-2.0-Ruby-Weblog-in-10-Minutes%22-tp19893635p19967100.html
Sent from the NetBeans Ruby Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

--
John Griffiths

» email: indiehead@...
» skype: sgmuse
» blog: http://www.red91.com

[Chris Kutler]

Hello Tony,

That is my blog. Sorry I took so long to reply. I have some questions
for you.

What is your operating system?

Can you open a terminal window on the root folder (rubyweblog) of the
project and try this command:

rake db:create

Do you get any error messages?

It looks as if MySQL or some other internal software has a problem with
UTF8. Did you set the encoding to UTF8, or was that in the database.yml
file created by the IDE?

tony chen wrote:

> Hey guys,
>   I'm new to both ruby on rails AND netbeans.  I started following the
> tutorial
>
> http://blogs.sun.com/divas/entry/creating_a_rails_2_0
>
> and updated my netbeans with
>
> ruby 1.8.6
> rails 2.0
>
> and then when following the tutorial and I get to the part where i'm
> creating the db....Run Rake Task > db > create.  I get the following
> error
>
> (in C:/Documents and Settings/Administrator/Desktop/rubyweblog)
>
> Couldn't create database for {"encoding"=>"utf8", "username"=>"tony",
> "adapter"=>"mysql", "host"=>"localhost", "password"=>"tony",
> "database"=>"rubyweblog_development"}, charset: utf8, collation:
> utf8_general_ci (if you set the charset manually, make sure you have a
> matching collation).   Any help would be greatly appreciated!
>
> Thanks!
> Tony
>
> PS  My yml file is very basic with the following
>
> development:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_development
>   username: tony
>   password: tony
>   host: localhost
>
> test:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_test
>   username: tony
>   password: tony
>   host: localhost
>
> production:
>   adapter: mysql
>   encoding: utf8
>   database: rubyweblog_production
>   username: tony
>   password: tony
>   host: localhost
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...