Can't get past rake db:create, guidance appreciated

$ rake db:create
(in /home/adrian/sites/tmpee)
Could not find gem 'sqlite3-ruby (>= 0, runtime)' in any of the gem
sources listed in your Gemfile.
Try running `bundle install`.

So I ran bundle install and got the same error.

This is my config/database.yml file:

development:
  adapter: postgresql
  encoding: unicode
  database: tmpees.development
  pool: 5
  timeout: 5000

# 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: postgresql
  database: tmpees.test
  pool: 5
  timeout: 5000

production:
  adapter: postgresql
  database: tmpees.production
  pool: 5
  timeout: 5000

Thank you for your patience with a noob.

in your Gemfile delete line which have sqlite3-ruby

Kannav R. wrote in post #964048:

in your Gemfile delete line which have sqlite3-ruby

As usual, your advice is useless and wrong. Please don't post if this
is all you're going to say.

Best,

Marnen Laibow-Koser wrote in post #964375:

Kannav R. wrote in post #964048:

in your Gemfile delete line which have sqlite3-ruby

As usual, your advice is useless and wrong. Please don't post if this
is all you're going to say.

No, on second look, you were right and I'm the one who shouldn't have
posted. I'm very sorry.

Hello,

Check all versions, I assume everything is updated, Ruby1.9 Rails 3+
Gem 1.3.7

This error can mean:
1. your Ruby and Gem version isn't fit, update;
2. Your Gemfile contains the line gem 'sqlite3' ... but your gem list
does not - check it from command line 'gem list'. If you want to use
sqlite3 later (good choice) then type 'gem install sqlite3-ruby'
This way your system will have sqlite3 gem, which means later you can
use 'bundle install' (if you wrote it to the Gemfile...)
Anyway first also check if the DBs works properly from console.

I think the same with postgre.

Let me know if you have further problems, but then pls copy-paste here
your versions and OS and gemlist.
good luck,
Zoltán