Project

General

Profile

Error: Table 'custom_values' already exists <SOLVED>

Added by Natan Shalva over 11 years ago

ruby 1.9.3p392 (2013-02-22 revision 39386) [x86_64-linux]
Rails 3.2.8
Ubuntu 10.4
Redmine - svn co http://svn.redmine.org/redmine/trunk redmine
mysql 5.1.67-0ubuntu0.10.04.1

RAILS_ENV=production rake db:migrate
Setup: migrating ========================================================
-- create_table("attachments", {:force=>true})
> 0.0658s
-
create_table("auth_sources", {:force=>true})
> 0.0442s
-
create_table("custom_fields", {:force=>true})
> 0.0361s
-
create_table("custom_fields_projects", {:id=>false, :force=>true})
> 0.0363s
-
create_table("custom_fields_trackers", {:id=>false, :force=>true})
> 0.0365s
-
create_table("custom_values", {:force=>true})
rake aborted!
An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'custom_values' already exists: CREATE TABLE `custom_values` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `customized_type` varchar(30) DEFAULT '' NOT NULL, `customized_id` int(11) DEFAULT 0 NOT NULL, `custom_field_id` int(11) DEFAULT 0 NOT NULL, `value` text) ENGINE=InnoDB/usr/local/rvm/gems/ruby-1.9.3-p392/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'

clean install.


Replies (3)

RE: Error: Table 'custom_values' already exists - Added by Jan Niggemann (redmine.org team member) over 11 years ago

Is this a new install or an upgrade? Perhaps you can just delete the table and retry.

RE: Error: Table 'custom_values' already exists - Added by Natan Shalva over 11 years ago

Thanks. this is new installation.
I did delete the db and create new one, didn't help.

Also, i can see there is no table called 'custom_values', so i can't understand where it get it from.

RE: Error: Table 'custom_values' already exists <SOLVED> - Added by Natan Shalva over 11 years ago

Finally, the problem resolved by restart the mysql ...

(ubuntu ) /etc/init.d/mysql restart

    (1-3/3)