Error: Mysql::Error: #42S02Table 'redmine.roles' doesn't exist: SELECT * FROM `roles` WHERE (`roles`.`builtin` = 0) LIMIT 1
Added by Arunkumar Krishnamoorthy about 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 about 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 almost 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 almost 16 years ago
you should avoid drugs or alcohol when installing software... :-/
- Why the hell are you working in the ruby/bin directory?
- Redmine Guide don't ask you to use the db:create task
- ruby script/generate migration add_table ? you want to develop without having the tool installed?
- I'm not very sure what you're doing is redmine relative. You should have the honesty to mention it!