Topic: Can't edit tags or anything

Posted under Art Talk

I'm getting this:

ActiveRecord::StatementInvalid in PostController#update

PGError: ERROR: invalid input syntax for type inet: "5.79.79.41, 141.101.105.38"
LINE 1: ...furaffinity.net/view/13652414/', 'e', '', 493198, '5.79.79.4...
^
: INSERT INTO "post_tag_histories" ("source", "rating", "reason", "post_id", "ip_addr", "created_at", "user_id", "parent_id", "revertuser", "tags", "description") VALUES('http://www.furaffinity.net/view/13652414/', 'e', '', 493198, '5.79.79.41, 141.101.105.38', '2014-06-10 02:03:41.116981', 68125, NULL, NULL, 'ball_gag bdsm bondage bound breasts canine cloud dildo female gag green_eyes green_hair hair hanging insertion mammal nebri nipple_torture nipples nude penetration pulling_hair pussy rimefox rope_bondage sex_toy sky toy vaginal vaginal_penetration vibrator wolf', '') RETURNING "id"
RAILS_ROOT: /home/e621/e621-production/release-2014-06-08

Application Trace | Framework Trace | Full Trace
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract_adapter.rb:227:in log' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:520:in execute'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:1002:in select_raw' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:989:in select'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in select_all_without_query_cache' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in select_all'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in cache_sql' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in select_all'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in select_one' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in select_value'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:460:in insert' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/base.rb:2969:in create_without_timestamps'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/timestamp.rb:53:in create_without_callbacks' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/callbacks.rb:266:in create'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/base.rb:2935:in create_or_update_without_callbacks' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/callbacks.rb:250:in create_or_update'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/base.rb:2585:in save_without_validation' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/validations.rb:1089:in save_without_dirty'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/dirty.rb:79:in save_without_transactions' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:229:in send'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:229:in with_transaction_returning_status' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in transaction'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:182:in transaction' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:228:in with_transaction_returning_status'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:196:in save' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:208:in rollback_active_record_state!'
/opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/transactions.rb:196:in save' /opt/rbenv/versions/ree-1.8.7-2012.02/lib/ruby/gems/1.8/gems/activerecord-2.3.18/lib/active_record/base.rb:727:in create'
/home/e621/e621-production/release-2014-06-08/app/models/post/tag_methods.rb:223:in commit_tags' /home/e621/e621-production/release-2014-06-08/app/models/post/tag_methods.rb:81:in commit_tags'
/home/e621/e621-production/release-2014-06-08/app/controllers/post_controller.rb:283:in update' Request Parameters: {"post"=>{"source"=>"http://www.furaffinity.net/view/13652414/", "rating"=>"Explicit", "old_tags"=>"ball_gag bdsm bondage bound breasts canine cloud dildo female gag green_eyes green_hair hair hanging insertion mammal nebriwolf nipple_torture nipples nude penetration pulling_hair pussy rimefox rope_bondage sex_toy sky toy vaginal vaginal_penetration vibrator wolf", "hide_google"=>false, "parent_id"=>"", "hide_anon"=>false, "tags"=>"ball_gag bdsm bondage bound breasts canine cloud dildo female gag green_eyes green_hair hair hanging insertion mammal nebri nipple_torture nipples nude penetration pulling_hair pussy rimefox rope_bondage sex_toy sky toy vaginal vaginal_penetration vibrator wolf", "description"=>""}, "reason"=>"", "id"=>"493198"} Show session dump Response Headers: {"Set-Cookie"=>"blacklisted_tags=rigby&benson&scat&my_little_pony&friendship_is_magic&nintendo&sonic_the_hedgehog&pok%C3%A9mon; path=/\nblacklist_avatars=false; path=/\nblacklist_users=false; path=/", "Cache-Control"=>"no-cache", "Content-Type"=>""} friGate сайт из списка 1 proxy включен всегда

Updated by furrypickle

Yep, a couple of us are having that problem. Hopefully it's because they're in the middle of updating something and it will get fixed soon.

In future though, try to post bug reports/glitches/things-not-working-right to the 'Bug Report Thread' which is sticked at the top of the forum or here: https://e621.net/forum/show/28544

It just keeps things organised and makes it easier for the site mods who are in charge of fixing glitches to actually see it, since that is where they will look for things they need to fix.

Updated by anonymous

spight

Former Staff

Yeah... our testing process isn't locked down solid yet. =/ Sorry. For this particular issue, I was an idiot and forgot how the XFF header works. It's fixed for now.

Updated by anonymous

spight said:
Yeah... our testing process isn't locked down solid yet. =/ Sorry. For this particular issue, I was an idiot and forgot how the XFF header works. It's fixed for now.

You test on production? O.o Or it slipped past testing?

Updated by anonymous

spight

Former Staff

Swiftkill said:
You test on production? O.o Or it slipped past testing?

We have test servers, of course, and I deploy to lesser-used sites first. Of the three large issues that occurred when I pushed the code to e621, only the Comments one could have been expected. The rest happened specifically -because- of the live site's configuration.

Luckily, I can easily revert. :)

Updated by anonymous

spight said:
Yeah... our testing process isn't locked down solid yet. =/ Sorry. For this particular issue, I was an idiot and forgot how the XFF header works. It's fixed for now.

Hey, thanks for the explanation though. It's nice to be aware of what's going on. And hopefully the rest goes smoothly for you. =)

Updated by anonymous

  • 1