Undefined method `accept' for nil:NilClass on rake db:migrate

Question

Using ruby-1.9.2 and rails 3.2.1. The version of mysql2 is 0.2.7.

Upon running rake db:migrate I get the error: "undefined method `accept' for nil:NilClass:"

Trace includes:

gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `to_sql'

Have you ever done a successful rake db:migrate, or is this a fresh install? Do any other rake commands work? — Marc Talbot, Feb 11 '12 at 23:40
Hi Marc, this is a fresh install - upgrade to 10.7 Mac OS X. Rake db:create worked fine. — vectran, Feb 11 '12 at 23:41
@vectran Did you fix this problem? I am facing same issue now. — chhantyal, Mar 06 '12 at 19:15

score 28 · Answer 1 · answered Feb 17 '13 at 01:13

28

Change your Gemfile from:

gem 'activerecord-mysql2-adapter'

to:

gem 'mysql2'

answered Feb 17 '13 at 01:13

Shaheen Ghiassy

7,397
3
40
40

1

why does this happen? – Maruccio Dec 20 '13 at 19:17
Still solving problems more than a year later! – Stephen Sep 24 '14 at 13:56

score 11 · Answer 2 · answered Mar 06 '12 at 19:55

11

Ok, I fixed on my machine. This is because of older MySQL2. Do this to resolve the problem.

bundle update mysql2

        Or

bundle update

For more details visit Github

answered Mar 06 '12 at 19:55

chhantyal

11,874
7
51
77

score 10 · Answer 3 · answered Oct 03 '12 at 11:04

10

For me by removing gem 'activerecord-mysql2-adapter' from Gem File worked out

answered Oct 03 '12 at 11:04

Anikethana

350
3
11

Works for me when upgrading from Rails 3.0.3 to Rails 3.2.8 – superluminary Oct 10 '12 at 15:26
1

That medicine cured my ail – Martin Capodici Nov 09 '13 at 07:26

score 1 · Answer 4 · answered Dec 12 '12 at 08:00

1

Install the lastest mysql2 ruby gem. my environtment:

Rails3.2.9 + mysql2 0.2.9,  : "undefined method `accept' for nil:NilClass:"
Rails3.2.9 + mysql2 0.3.11, works fine

answered Dec 12 '12 at 08:00

Siwei

19,858
7
75
95

score 1 · Answer 5 · answered Dec 03 '13 at 18:30

It can happen because of incompatibility of your mysql and ruby version.

To resolve this either update your mysql gem by gem install mysql which will install latest mysql gem.

And then add this in your Gemfile.

If still the problem exists then you should see the compatibility between your ruby and mysql

score 0 · Answer 6 · answered Aug 24 '12 at 03:30

0

You get this if in your database.yaml file you have:

dev:
  adapter: mysql2

It should be (even if the gem you are using is mysql2):

dev:
  adapter: mysql

Took me over a week to figure this out I hope it saves you some time.

answered Aug 24 '12 at 03:30

leat

1,418
1
15
21

score -1 · Answer 7 · answered Jun 15 '13 at 23:00

-1

Define:

def nil.accept
  puts "Accepted."
end

And the error will go away.

answered Jun 15 '13 at 23:00

Boris Stitnicky

12,444
5
57
74

hilarious, I hope not too many people will fall into the trap. might not be well received in a Q/A helping site – Mathieu J. Jun 12 '20 at 02:58

Undefined method `accept' for nil:NilClass on rake db:migrate

7 Answers7