Topic: MySQL Error: rake db:migrate

Hello guys,

i just tried to setup and migrate some objects in the MySQL DB with Ruby on Rails. If i am running "rake db:migrate" i getting the following error:

rake aborted!
Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version`varchar(255) NOT NULL) ENGINE=InnoDB

(See full trace by running task with --trace)

I am using MySql 5.1.37 and i already created a DB with rake db:create

Can you help me with this error message? Thanks a lot!
Mark

Last edited by crain (2009-08-25 13:28:20)

Re: MySQL Error: rake db:migrate

Hey crain,

I am getting the exact same error.  If you wouldn't mind forwarding any proposed solutions (rob.smith05@gmail.com) it would be greatly appreciated...

rob

Re: MySQL Error: rake db:migrate

Or you could subscribe to this topic and they could be posted here and be of benefit to everyone. Just a thought ...

Re: MySQL Error: rake db:migrate

Hi everybody,

i just found a hint on http://forums.aptana.com/viewtopic.php? … dll#p27407

And this works for me!

-Mark

Re: MySQL Error: rake db:migrate

The proposed solution by crain worked for me as well.

Sorry, I didn't see the subscribe option when I posted the request.

Thanks all!

Re: MySQL Error: rake db:migrate

Different Rails version needs different configuration.
So, never update your rails version without preparation.

Re: MySQL Error: rake db:migrate

viva_yang wrote:

Different Rails version needs different configuration.
So, never update your rails version without preparation.

No where does this thread mention an upgrade.

Re: MySQL Error: rake db:migrate

Hi,

I faced the same issue now its solved.

Step -1 To get rid of the issue copyt the libmySQL.dll from this link

http://instantrails.rubyforge.org/svn/t … bmySQL.dll

Step -2 Paste iit in C:\Ruby\bin of yours

Reply to me ! If u get rid off :)
Thanks

Re: MySQL Error: rake db:migrate

Thx Sundari,
It worked for me.....

Re: MySQL Error: rake db:migrate

Thanks Sundari my problem is fixed now
_____________________
Make cash from residual income affiliate programs like health affiliate programs.

Re: MySQL Error: rake db:migrate

Same here, Sundari's fix worked like a charm.

Thanks!

Re: MySQL Error: rake db:migrate

thanks !! it works smile

Re: MySQL Error: rake db:migrate

Thanks gsundari,
it worked for me too!!!

Re: MySQL Error: rake db:migrate

the same problem,i tried gsundari's solution,but still not fixed,why?

Re: MySQL Error: rake db:migrate

If this breaks the update procedure it might be a good idea to start checking for the columns before adding them since I think there could be a number of users that have had it installed previously and it will break the migrate when 0.9.4 comes out.

Very True