StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POActiveRecord::StatementInvalid (PG::Error: ERROR: value too long for type character varying(255)
text
Body
copied!<p>Help! In my system, users search books and choose one and create one group for the book. But some users unintentionally created three groups for one book. Then I deleted the others. After that, I suddenly got the error below. </p> <p>Now, users can't post any article.</p> <p>☆heroku logs</p> <pre><code>2013-12-28T15:58:35.611503+00:00 app[web.1]: Started POST "/group_messages/7/group_message_comments" for 119.72.194.92 at 2013-12-29 00:58:35 +0900 2013-12-28T15:58:35.614373+00:00 app[web.1]: Processing by GroupMessageCommentsController#create as HTML 2013-12-28T15:58:35.614373+00:00 app[web.1]: Parameters: {"utf8"=>"✓", "authenticity_token"=>"SMyCZ8R97XIEMWQTzdYFMwcBRjtuoOgp7EDtpebyJRU=", "group_message_comment"=>{"member_id"=>"2", "group_message_id"=>"7", "group_id"=>"5", "content"=>"他人の地位を買収する、というより、その話題の彼が主宰するメンバーシップの中にお金を払って入ることができないという意味ですね。こちらはご参考です。http://idioms.thefreedictionary.com/buy+way+in\\r\\nSun Valley was always very reassuring, because unlike most elephant bumps, one could not buy one’s way\\r\\nin.ほかのこういうビッグネームの集まる類いのイベント（elepaht bump）の中には、お金さえ払えば参加できるものが主流なんでしょうね"}, "commit"=>"Comment", "group_message_id"=>"7"} 2013-12-28T15:58:35.624060+00:00 app[web.1]: 2013-12-28T15:58:35.624060+00:00 app[web.1]: 2013-12-28T15:58:35.624060+00:00 app[web.1]: 2013-12-28T15:58:35.624060+00:00 app[web.1]: app/controllers/group_message_comments_controller.rb:47:in `create' 2013-12-28T15:58:35.624060+00:00 app[web.1]: ActiveRecord::StatementInvalid (PG::Error: ERROR: value too long for type character varying(255) 2013-12-28T15:58:35.624060+00:00 app[web.1]: : INSERT INTO "group_message_comments" ("content", "created_at", "group_id", "group_message_id", "member_id", "read", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"): 2013-12-28T15:58:35.621719+00:00 app[web.1]: Completed 500 Internal Server Error in 7ms </code></pre> <p>☆group.rb</p> <pre><code>class Group < ActiveRecord::Base attr_accessible :admin, :memo, :name has_many :group_in_members, :dependent => :destroy has_many :members, :through => :group_in_members has_many :group_messages, :dependent => :destroy end </code></pre> <p>☆schema.rb</p> <pre><code>ActiveRecord::Schema.define(:version => 20131219064155) do create_table "comments", :force => true do |t| t.integer "member_id" t.integer "message_id" t.string "content" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end create_table "contacts", :force => true do |t| t.string "name", :null => false t.string "email", :null => false t.text "content", :null => false t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end create_table "friends", :force => true do |t| t.integer "member_id", :null => false t.integer "friend_id", :null => false t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end create_table "group_in_members", :force => true do |t| t.integer "group_id", :null => false t.integer "member_id", :null => false t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end create_table "group_message_comments", :force => true do |t| t.integer "member_id", :null => false t.integer "group_id", :null => false t.string "content" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false t.integer "group_message_id", :null => false t.boolean "read", :default => false end create_table "group_messages", :force => true do |t| t.integer "member_id", :null => false t.text "content" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false t.integer "group_id", :null => false t.integer "page" t.integer "line" t.string "name" t.string "username" t.boolean "kaiketsu", :default => false end create_table "groups", :force => true do |t| t.datetime "created_at", :null => false t.datetime "updated_at", :null => false t.string "imageurl" t.string "author" t.string "publish" t.date "published" t.integer "page" t.string "isbn" t.string "asin" t.string "name" t.text "detailurl", :limit => 255 end create_table "members", :force => true do |t| t.string "user" t.string "pass" t.string "name" t.string "mail" t.text "memo" t.boolean "admin" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false t.string "password_digest" t.string "pass_confirmation" t.string "field" t.string "place" t.string "experience" t.string "url" t.string "provider" t.string "uid" t.string "image" t.string "avatar_file_name" t.string "avatar_content_type" t.integer "avatar_file_size" t.datetime "avatar_updated_at" end create_table "messages", :force => true do |t| t.integer "member_id" t.text "content" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end create_table "sessions", :force => true do |t| t.string "session_id", :null => false t.text "data" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" end </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload