PG :: StringDataRightTruncation:错误:PostgreSQL字符串(255)限制| Heroku的 [英] PG::StringDataRightTruncation: ERROR: PostgreSQL string(255) limit | Heroku
问题描述
我有清单控制器
,用户可以添加说明。如果描述很长,应该是这样,我在Heroku收到这个错误:
I Have a Listings controller
and users can add a description. If the description is long, which it should be, I receive this error in Heroku:
ActiveRecord::StatementInvalid (PG::StringDataRightTruncation: ERROR:
value too long for type character varying(255)
我怎么能解决这个问题?
How can I fix this?
编辑
我发现了我必须改变我的表格字符串(它有一个限制):文本是无限的,但只是在迁移中更改表格似乎没有用。
I found out (John said it also) that i have to change in my table string(which has a limit) to :text which is limitless. But only changing the table in the migration didn't seem to work.
我的编辑列表迁移
class CreateListings < ActiveRecord::Migration
def change
create_table :listings do |t|
t.string :title
t.text :description, :limit => nil
t.timestamps
end
end
end
但是我仍然遇到Heroku麻烦 - >
But i'm still getting Heroku trouble ->
2013-07-29T09:39:05.069692+00:00 app[web.1]: ActiveRecord::StatementInvalid (PG::StringDataRightTruncation: ERROR: value too long for type character v rying(255)
2013-07-29T09:39:05.069870+00:00 app[web.1]:
2013-07-29T09:39:05.069692+00:00 app[web.1]: : INSERT INTO "listings" ("created_at", "description", "image_content_type", "image_file_name", "image_fil _size", "image_updated_at", "price", "title", "updated_at", "user_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id"):
2013-07-29T09:39:05.069870+00:00 app[web.1]: app/controllers/listings_controller.rb:35:in `block in create'
2013-07-29T09:39:05.069870+00:00 app[web.1]: app/controllers/listings_controller.rb:34:in `create'
2013-07-29T09:39:05.069870+00:00 app[web.1]:
2013-07-29T09:39:05.069860+00:00 heroku[router]: at=info method=POST path=/listings host=vaultx.herokuapp.com fwd="178.59.173.169" dyno=web.1 connect=3 s service=1882ms status=500 bytes=1266
推荐答案
它似乎是这样将列指定为:文本类型而不是:字符串将解决此问题。
It would seem that specifying the column as a :text type and not a :string would fix this problem.
这篇关于PG :: StringDataRightTruncation:错误:PostgreSQL字符串(255)限制| Heroku的的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!