close fullscreen

Support Ticket

Seeding db caused script error+status
closed
help edit space_dashboard
Seeding db caused script error+tags
 

Seeding db caused script error+issues

help edit space_dashboard

PGError: ERROR:  column "trash" is of type boolean but expression is of type integer

USING postgres 9.1

Changed the schema.rb file trash to type integer fixed the problem

 

 

help edit space_dashboard

I think we're having this problem because the fixtures were dumped from mysql, which treats booleans as tiny integers.

 

Your solution is clever but may cause you some problems in the future.  Perhaps you can alter the column back to a boolean?


I think we need to tweak the bootstrap dumping here:

file.write YAML::dump( data.inject({}) { |hash, record|

hash["#{table}_#{i.succ!}"] = record

hash

})

  --Ethan McCutchen.....2012-11-09 18:05:29 +0000


this has been addressed in a more durable way in our data generation

  --Ethan McCutchen.....2013-03-13 01:30:00 +0000