ruby on rails - Running Heroku rake db:migrate on Heroku not migrating the database -


so when run heroku rake db:migrate, after pushing latest code heroku doesn't alter tables. however, when try on pc(where use postgresql) , run rake db:migrate, migrates database , adds necessary tables , fields existing tables.

however, heroku, don't errors, response get.

 sql (2.4ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'flow_elements'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.2ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"flows"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.7ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"flows"'::regclass    sql (2.7ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'flows'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.3ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"images"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.3ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"images"'::regclass    sql (2.3ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'images'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.2ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"login_histories"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.8ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"login_histories"'::regclass    sql (2.7ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'login_histories'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.1ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"projects"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.2ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"projects"'::regclass    sql (2.6ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'projects'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.3ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"projects_users"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.5ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"projects_users"'::regclass    sql (2.4ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'projects_users'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (2.2ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"questions"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.2ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"questions"'::regclass    sql (2.4ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'questions'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    columns index questions_fts_idx on questions (1.8ms)   select a.attnum, a. attname  pg_attribute  a.attrelid = 48972  , a.attnum in (0)    sql (2.1ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"screens"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (4.3ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"screens"'::regclass    sql (2.4ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'screens'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname    sql (3.0ms)   select a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,  a.attnotnull  pg_attribute left join pg_attrdef d  on a.attrelid = d.adrelid , a.attnum = d.adnum  a.attrelid = '"users"'::regclass  , a.attnum > 0 , not a.attisdropped  order a.attnum    pk , serial sequence (3.6ms)   select attr.attname, seq.relname  pg_class seq,  pg_attribute attr,  pg_depend dep,  pg_namespace name,  pg_constraint cons  seq.oid = dep.objid  , seq.relkind = 's'  , attr.attrelid = dep.refobjid  , attr.attnum = dep.refobjsubid  , attr.attrelid = cons.conrelid  , attr.attnum = cons.conkey[1]  , cons.contype = 'p'  , dep.refobjid = '"users"'::regclass    sql (2.4ms)   select distinct i.relname, d.indisunique, d.indkey, t.oid  pg_class t, pg_class i, pg_index d  i.relkind = 'i'  , d.indexrelid = i.oid  , d.indisprimary = 'f'  , t.oid = d.indrelid  , t.relname = 'users'  , i.relnamespace in (select oid pg_namespace nspname in ('"$user"' ,'public') )  order i.relname 

any ideas ?

you need restart heroku servers using "heroku restart".


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -