search

Coursemology / coursemology.org

[OBSOLETE] Coursemology v1 has now been superseded by v2 (https://github.com/coursemology/coursemology2)
https://v1.coursemology.org
MIT License
38 stars 32 forks source link

ActiveRecord::StatementInvalid: Mysql2::Error: Out of range value for column 'exp' at row 1: INSERT INTO `exp_transactions` (`created_at`, `deleted_at`, `exp`, `giver_id`, `is_valid`, `reason`, `rewardable_id`, `rewardable_type`, `updated_at`, `user_cours #419

Closed jsyeo closed 9 years ago

jsyeo commented 9 years ago

View details in Rollbar: https://rollbar.com/jsyeo/coursemology.org/items/99/


Mysql2::Error: Out of range value for column 'exp' at row 1
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract_mysql_adapter.rb", line 245, in query
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract_mysql_adapter.rb", line 245, in block in execute
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract_adapter.rb", line 280, in block in log
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract_adapter.rb", line 275, in log
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/instrumentation/active_record.rb", line 63, in block in log_with_newrelic_instrumentation
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/method_tracer.rb", line 219, in trace_execution_scoped
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/instrumentation/active_record.rb", line 60, in log_with_newrelic_instrumentation
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract_mysql_adapter.rb", line 245, in execute
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/mysql2_adapter.rb", line 213, in execute
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/mysql2_adapter.rb", line 236, in exec_insert
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract/database_statements.rb", line 90, in insert
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract/query_cache.rb", line 14, in insert
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/relation.rb", line 66, in insert
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/persistence.rb", line 367, in create
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/timestamp.rb", line 58, in create
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/callbacks.rb", line 268, in block in create
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 403, in _run__339356788157033347__create__1469721371563875333__callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 405, in __run_callback
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 385, in _run_create_callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 81, in run_callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/callbacks.rb", line 268, in create
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/persistence.rb", line 348, in create_or_update
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/callbacks.rb", line 264, in block in create_or_update
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 436, in _run__339356788157033347__save__1469721371563875333__callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 405, in __run_callback
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 385, in _run_save_callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.14/lib/active_support/callbacks.rb", line 81, in run_callbacks
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/callbacks.rb", line 264, in create_or_update
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/persistence.rb", line 84, in save
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/validations.rb", line 50, in save
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/attribute_methods/dirty.rb", line 22, in save
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 259, in block (2 levels) in save
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 313, in block in with_transaction_returning_status
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/connection_adapters/abstract/database_statements.rb", line 192, in transaction
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 208, in transaction
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/method_tracer.rb", line 455, in block in transaction_with_trace_ActiveRecord_self_name_transaction
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/method_tracer.rb", line 219, in trace_execution_scoped
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/newrelic_rpm-3.9.1.236/lib/new_relic/agent/method_tracer.rb", line 453, in transaction_with_trace_ActiveRecord_self_name_transaction
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 311, in with_transaction_returning_status
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 259, in block in save
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 270, in rollback_active_record_state!
  File "/home/raymoond/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.14/lib/active_record/transactions.rb", line 258, in save
  File "/home/raymoond/jenkins/workspace/coursemology_second/app/models/user_course.rb", line 240, in manual_exp_award
  File "/home/raymoond/jenkins/workspace/coursemology_second/app/controllers/manual_rewards_controller.rb", line 23, in block in manual_exp
  File "/home/raymoond/jenkins/workspace/coursemology_second/app/controllers/manual_rewards_controller.rb", line 20, in each
  File "/home/raymoond/jenkins/workspace/coursemology_second/app/controllers/manual_rewards_controller.rb", line 20, in manual_exp
  File "/home/