12 Aug 2009, 17:59
Generic-user-small

Ken Burgett (20 posts)

Hi,

I am seeing the method facebook_login_required failing on an attempt to insert an entry into my user table. I am following the Tracker Runner video and used facebook_authentication to create the user model. This happens on the second action, the first action inserts my facebook user into the User table, but the second action attempts to repeat this and crashes. What am I missing

class ApplicationController < ActionController::Base helper :all protect_from_forgery include FacebookerAuthentication::Controller

before_filter :facebook_login_required end

Here is my traceback

 ActiveRecord::StatementInvalid in AssetsController#index

Mysql::Error: Duplicate entry '2147483647' for key 2: INSERT INTO `users` (`facebook_id`, `created_at`, `session_key`, `updated_at`, `game_id`) VALUES(100000144622947, '2009-08-12 17:45:01', NULL, '2009-08-12 17:45:01', NULL)

RAILS_ROOT: /home/kenb/development/mg
Application Trace | Framework Trace | Full Trace

/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:320:in `execute'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:259:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:330:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2897:in `create_without_timestamps'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/timestamp.rb:53:in `create_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:266:in `create'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2863:in `create_or_update_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:250:in `create_or_update'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2534:in `save_without_validation'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/validations.rb:1009:in `save_without_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/dirty.rb:79:in `save_without_transactions'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:182:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1959:in `find_or_create_by_facebook_id'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `method_missing'
/home/kenb/development/mg/vendor/plugins/facebooker_authentication/lib/facebooker_authentication/model.rb:28:in `for_facebook_id'
/home/kenb/development/mg/lib/facebooker_authentication/controller.rb:19:in `set_current_user'
/home/kenb/development/mg/lib/facebooker_authentication/controller.rb:25:in `facebook_login_required'

/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:320:in `execute'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:259:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:330:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2897:in `create_without_timestamps'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/timestamp.rb:53:in `create_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:266:in `create'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2863:in `create_or_update_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:250:in `create_or_update'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2534:in `save_without_validation'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/validations.rb:1009:in `save_without_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/dirty.rb:79:in `save_without_transactions'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:182:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1959:in `find_or_create_by_facebook_id'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `method_missing'
/home/kenb/development/mg/vendor/plugins/facebooker_authentication/lib/facebooker_authentication/model.rb:28:in `for_facebook_id'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:178:in `send'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:178:in `evaluate_method'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:166:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:225:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:629:in `run_before_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:615:in `call_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/flash.rb:146:in `perform_action'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:527:in `send'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:527:in `process_without_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:606:in `process'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:391:in `process'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:386:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/routing/route_set.rb:434:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:88:in `dispatch'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:111:in `_call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:82:in `initialize'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:29:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:29:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:9:in `cache'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:28:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/head.rb:9:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/methodoverride.rb:24:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/params_parser.rb:15:in `call'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/rack/facebook.rb:51:in `call'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/facebooker.rb:90:in `with_application'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/rack/facebook.rb:45:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/session/cookie_store.rb:93:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/reloader.rb:29:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/failsafe.rb:26:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `synchronize'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:106:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/static.rb:31:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:46:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in `each'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/debugger.rb:17:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/log_tailer.rb:17:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/content_length.rb:13:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/chunked.rb:15:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:61:in `process'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:159:in `process_client'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `each'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `process_client'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `initialize'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `new'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `initialize'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `new'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `run'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:34:in `run'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/commands/server.rb:111
/usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require'
script/server:3

/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:320:in `execute'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:259:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/mysql_adapter.rb:330:in `insert_sql'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2897:in `create_without_timestamps'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/timestamp.rb:53:in `create_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:266:in `create'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2863:in `create_or_update_without_callbacks'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/callbacks.rb:250:in `create_or_update'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:2534:in `save_without_validation'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/validations.rb:1009:in `save_without_dirty'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/dirty.rb:79:in `save_without_transactions'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:182:in `transaction'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/transactions.rb:196:in `save'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1959:in `find_or_create_by_facebook_id'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `send'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/base.rb:1940:in `method_missing'
/home/kenb/development/mg/vendor/plugins/facebooker_authentication/lib/facebooker_authentication/model.rb:28:in `for_facebook_id'
/home/kenb/development/mg/lib/facebooker_authentication/controller.rb:19:in `set_current_user'
/home/kenb/development/mg/lib/facebooker_authentication/controller.rb:25:in `facebook_login_required'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:178:in `send'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:178:in `evaluate_method'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/callbacks.rb:166:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:225:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:629:in `run_before_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:615:in `call_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/home/kenb/ruby/gems/gems/activesupport-2.3.3/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/flash.rb:146:in `perform_action'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:527:in `send'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:527:in `process_without_filters'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/filters.rb:606:in `process'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:391:in `process'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/base.rb:386:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/routing/route_set.rb:434:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:88:in `dispatch'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:111:in `_call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:82:in `initialize'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:29:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:29:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:9:in `cache'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/query_cache.rb:28:in `call'
/home/kenb/ruby/gems/gems/activerecord-2.3.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/head.rb:9:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/methodoverride.rb:24:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/params_parser.rb:15:in `call'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/rack/facebook.rb:51:in `call'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/facebooker.rb:90:in `with_application'
/home/kenb/development/mg/vendor/plugins/facebooker/lib/rack/facebook.rb:45:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/session/cookie_store.rb:93:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/reloader.rb:29:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/failsafe.rb:26:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `synchronize'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/lock.rb:11:in `call'
/home/kenb/ruby/gems/gems/actionpack-2.3.3/lib/action_controller/dispatcher.rb:106:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/static.rb:31:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:46:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in `each'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/debugger.rb:17:in `call'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/rails/rack/log_tailer.rb:17:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/content_length.rb:13:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/chunked.rb:15:in `call'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:61:in `process'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:159:in `process_client'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `each'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `process_client'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `initialize'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `new'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `initialize'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `new'
/home/kenb/ruby/gems/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `run'
/home/kenb/ruby/gems/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:34:in `run'
/home/kenb/ruby/gems/gems/rails-2.3.3/lib/commands/server.rb:111
/usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require'
script/server:3

Request

Parameters:

{"fb_sig_app_id"=>"113165378682",
 "format"=>"fbml",
 "fb_sig_request_method"=>"GET",
 "fb_sig_locale"=>"en_US",
 "_method"=>"GET",
 "fb_sig_in_canvas"=>"1",
 "fb_sig_in_new_facebook"=>"1",
 "fb_sig"=>"129557807197d68cd4eea4936e98777c",
 "fb_sig_friends"=>"",
 "fb_sig_added"=>"1",
 "fb_sig_expires"=>"1250186400",
 "fb_sig_session_key"=>"2.13lO9JqA2MlBk6u_UVQGFQ__.86400.1250186400-100000144622947",
 "fb_sig_ext_perms"=>"auto_publish_recent_activity",
 "fb_sig_api_key"=>"4b81c488f3656b18087834539faba87d",
 "fb_sig_time"=>"1250099071.0365",
 "fb_sig_profile_update_time"=>"1249929718",
 "fb_sig_user"=>"100000144622947"}

Show session dump

--- 

Response

Headers:

{"Content-Type"=>"",
 "Cache-Control"=>"no-cache"}
11 Sep 2009, 19:00
Generic-user-small

Jukkhapong Pliankam (1 post)

I got the same problem :(

14 Dec 2009, 02:10
Generic-user-small

Adam Medeiros (2 posts)

I ran into the same issue. Did either of you figure this out? It’s a show stopper for me right now.

Thanks in advance.

14 Dec 2009, 02:25
Generic-user-small

Adam Medeiros (2 posts)

Hello - I figured out the problem and thought I would post the solution here to help someone else out. When you use facebooker to create your users table as shown in the video tutorial, it creates the facebook_id column as int(11). It needs to be bigint because the facebook_id is a 64bit integer and not a 32bit integer. My fix was to run:

mysql> alter table users modify facebook_id bigint;

But don’t cut, copy and paste - make sure you set your table name correctly so this will work for you - better yet, back up your db first - I don’t want to ruin anybody’s day (or evening if you work like I do).

Hope this helps you - I don’t have the problem anymore after this.

Thanks

  You must be logged in to comment