bag_properties error
1 view
Skip to first unread message
urdabum
Mar 10, 2009, 12:51:01 AM3/10/09
to luvfoo
Hi people,
Can anyone help me with this error?
[root@localhost luvfoo]# rake db:schema:load
(in /root/Desktop/luvfoo)
-- create_table("bag_properties", {:force=>true})
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
Can anyone help me with this error?
[root@localhost luvfoo]# rake db:schema:load
(in /root/Desktop/luvfoo)
-- create_table("bag_properties", {:force=>true})
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
urdabum
Mar 12, 2009, 11:02:57 PM3/12/09
to luvfoo
nevermind i found the error.
urdabum
Mar 15, 2009, 5:27:16 AM3/15/09
to luvfoo
need help!!
I fix this by changing the whole schema, but then agian the whole
database got mess up.
[root@localhost luvfoo]# rake db:schema:load
(in /root/Desktop/luvfoo)
-- create_table("bag_properties", {:force=>true})
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
(See full trace by running task with --trace)
any ideas guys?
I fix this by changing the whole schema, but then agian the whole
database got mess up.
[root@localhost luvfoo]# rake db:schema:load
(in /root/Desktop/luvfoo)
-- create_table("bag_properties", {:force=>true})
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
any ideas guys?
urdabum
Mar 15, 2009, 8:31:22 PM3/15/09
to luvfoo
Here is the full trace:
[root@localhost luvfoo]# rake db:schema:load --trace
(in /root/Desktop/luvfoo)
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:schema:load
connection_adapters/abstract_adapter.rb:147:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/mysql_adapter.rb:302:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/abstract/schema_statements.rb:108:in
`create_table'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/mysql_adapter.rb:438:in `create_table'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:346:in `send'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:346:in `method_missing'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:326:in `say_with_time'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:326:in `say_with_time'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:342:in `method_missing'
/root/Desktop/luvfoo/db/schema.rb:14
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
schema.rb:43:in `instance_eval'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
schema.rb:43:in `define'
/root/Desktop/luvfoo/db/schema.rb:12
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:355:in `new_constants_in'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/tasks/databases.rake:226
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:578:in
`invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:571:in
`invoke_with_call_chain'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:564:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2027:in
`invoke_task'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1999:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1977:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1974:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/bin/rake:31
/usr/bin/rake:19:in `load'
/usr/bin/rake:19
[root@localhost luvfoo]# rake db:schema:load --trace
(in /root/Desktop/luvfoo)
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:schema:load
-- create_table("bag_properties", {:force=>true})
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
rake aborted!
Mysql::Error: Can't create table './luvfoo_development/
bag_properties.frm' (errno: 121): CREATE TABLE `bag_properties` (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY, `bag_id` int(11)
DEFAULT 1, `name` varchar(255), `label` varchar(255), `data_type` int
(11) DEFAULT 1, `display_type` varchar(255) DEFAULT 'text', `required`
tinyint(1) DEFAULT 0, `default_value` varchar(255),
`default_visibility` int(11) DEFAULT 4, `can_change_visibility` tinyint
(1) DEFAULT 1, `sort` int(11) DEFAULT 9999, `width` int(11) DEFAULT
-1, `height` int(11) DEFAULT -1, `registration_page` int(11),
`sf_field` varchar(255), `is_link` tinyint(1) DEFAULT 0, `prefix`
varchar(255), `maxlength` int(11) DEFAULT 5000) ENGINE=InnoDB
connection_adapters/abstract_adapter.rb:147:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/mysql_adapter.rb:302:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/abstract/schema_statements.rb:108:in
`create_table'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
connection_adapters/mysql_adapter.rb:438:in `create_table'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:346:in `send'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:346:in `method_missing'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:326:in `say_with_time'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:326:in `say_with_time'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
migration.rb:342:in `method_missing'
/root/Desktop/luvfoo/db/schema.rb:14
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
schema.rb:43:in `instance_eval'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/
schema.rb:43:in `define'
/root/Desktop/luvfoo/db/schema.rb:12
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:355:in `new_constants_in'
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/
dependencies.rb:503:in `load'
/usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/tasks/databases.rake:226
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:578:in
`invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:571:in
`invoke_with_call_chain'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:564:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2027:in
`invoke_task'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1999:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1977:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1974:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.4/bin/rake:31
/usr/bin/rake:19:in `load'
/usr/bin/rake:19
Reply all
Reply to author
Forward
0 new messages