Project

General

Profile

Forums » Help »

Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1

Added by Arunkumar Krishnamoorthy over 16 years ago

While following installation guide to setup the MySQL database - redmine- I faced the following error:

================
Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1
Default configuration data was not loaded. ================
I have been fighting it out for more than 1 day with lots of googling, but not able to resolve it. Here are the environment details.

OS: Win 2000 Server, SP4
MySql version: 5.0.51b
Ruby version: 1.86-26
Rails: 2.0.2 (Rails was installed using gem along with dependencies set)
Redmine version: 0.7.3

Any response will be of great help.


Replies (3)

RE: Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1 - Added by Thomas Lecavelier over 16 years ago

Well, obviously, something failed during rake db:migration. You should run it again, just to see if you meet a problem again. Have a look to your mysql database: you should have 44 tables in it.

If rake db:migration exit with an error, please report it here.

RE: Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1 - Added by Edgar Mwaki over 16 years ago

I have a somewhat similar issue. rake db: create exit with the following error;

c:\ruby\bin\longo>rake db:create
(in c:/ruby/bin/longo)
Couldn't create database for {"encoding"=>"utf8", "username"=>"root", "adapter"=

"mysql", "host"=>"localhost", "password"=>nil, "database"=>"longo_development"}

, charset: utf8, collation: utf8_general_ci (if you set the charset manually, ma
ke sure you have a matching collation)

and script/generate migration (name) exit with the following error;

c:\ruby\bin\longo>ruby script/generate migration add_table
Gem::SourceIndex#search support for Regexp patterns is deprecated
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/rails_generator/lookup.rb:211:in
`each' is outdated
create db/migrate
create db/migrate/20081019105947_add_table.rb

Your help will be greatly appreciated

EDGAR

RE: Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1 - Added by Thomas Lecavelier over 16 years ago

you should avoid drugs or alcohol when installing software... :-/

  1. Why the hell are you working in the ruby/bin directory?
  2. Redmine Guide don't ask you to use the db:create task
  3. ruby script/generate migration add_table ? you want to develop without having the tool installed?
  4. I'm not very sure what you're doing is redmine relative. You should have the honesty to mention it!
    (1-3/3)