LoadError when using heroku db:push

views:

220

answers:

+1 Q:

LoadError when using heroku db:push

When i use "heroku db:push" to transfer my local data to heroku,i got this error message:

Sequel::AdapterNotFound -> LoadError: no such file to load -- sequel/adapters/mysql2

I already install the mysql2 gem, and i am using rvm with ruby 1.9.2 in Mac OS X Snow Leopard.

Are you using the most current version of Sequel? mysql2 support wasn't added until 3.15.0.

Jeremy Evans 2010-09-08 16:07:20

thanks for your reply,i installed sequal again ,and this time i got sequel (3.15.0, 3.13.0) installed,when i run heroku db:push again ,i got this error message:Sequel::AdapterNotFound -> Gem::LoadError: can't activate sequel (= 3.15.0, runtime) for [], already activated sequel-3.13.0 for ["taps-0.3.11"],i try to uninstall sequal but failed,how can i fix it???

29decibel 2010-09-08 16:15:23

i thought i face a touth problem,i find that rails3 is using mysql2,and taps using sequal 3.13,but only sequal 3.15 support mysql2,is there any solution to this problem??? great thanks!!

29decibel 2010-09-08 16:28:54

any one has some idea?

29decibel 2010-09-09 01:32:41

You'll have to wait for a new release of taps that depends on a more recent version of Sequel. Or you can modify the taps gem spec to require Sequel 3.15.0 instead of 3.13.0.

Jeremy Evans 2010-09-09 15:23:56

Did you ever get this working? I am trying now too! If I figure something out I'll post,

rtfminc 2010-10-24 19:05:02

I'm able to use the original "mysql" gem still with rails3 instead of "mysql2" to get around this problem.

2010-09-08 23:16:54

sure i tried this ,but when i run "bundle install",i got some error.. which ruby version do u use?

29decibel 2010-09-09 02:10:29

Taps is still not compatible with sequel 3.15 which has mysql2 support. So mysql2 adapter won't work heroku db:pull or db:push commands. But I got it working by using the old mysql adapter. i was facing problems because my mysql adapter wasn't configured properly. If you are on 64 bit macOSX. Try uninstalling mysql adapter and reinstalling it using: sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config

Hope it helps.

gvaswani 2010-09-09 09:28:17

great thanks, i'll have a try latter..

29decibel 2010-09-10 08:11:55

ansaurus

tags:

views:

answers:

LoadError when using heroku db:push

related questions