What version of Tracks are you using? Reinier
> -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:tracks- > [EMAIL PROTECTED] Namens Walter Cruz > Verzonden: woensdag 23 juli 2008 16:36 > Aan: [email protected] > Onderwerp: [Tracks-discuss] error when removing a project > > The backtrace: > > > ActiveRecord::StatementInvalid > > > > in ProjectsController#destroy > > > > </h1> > > <pre>RuntimeError: ERROR C23502 Mnull value in column > "position" violates not-null constraint > > FexecMain.c L1818 RExecConstraints: UPDATE "projects" > SET > "updated_at" = '2008-07-23 > > 14:32:55.490699', "position" = NULL WHERE "id" = > 38</pre> > > > > <div id="Application-Trace" style="display: block;"> > > > <pre><code>vendor/rails/activerecord/lib/active_record/connection_adapt > ers/abstract_adapter.rb > > :147:in `log' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:446:in > `execut > > e' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:167:in > > `update_sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:457:in > `update > > _sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:49:in > > `update_without_query_dirty' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/query_cache.rb:19:in > `updat > > e' > > vendor/rails/activerecord/lib/active_record/base.rb:2481:in > `update_without_lock' > > vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:70:in > `update_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:137:in > `update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:234:in > `update_without_timestamps' > > vendor/rails/activerecord/lib/active_record/timestamp.rb:38:in `update' > > vendor/rails/activerecord/lib/active_record/base.rb:2472:in > `create_or_update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:207:in > `create_or_update' > > vendor/rails/activerecord/lib/active_record/base.rb:2200:in > `save_without_validation' > > vendor/rails/activerecord/lib/active_record/validations.rb:901:in > `save_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:75:in > `save_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/transactions.rb:118:in > `rollback_active_record_state!' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/validations.rb:922:in > `update_attribute' > > vendor/plugins/acts_as_list/lib/active_record/acts/list.rb:126:in > `remove_from_list' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `evaluate_method' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:161:in > `call' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:272:in > `run_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:298:in > `callback' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:288:in > `destroy_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > app/controllers/projects_controller.rb:159:in `destroy'</code></pre> > > </div> > > > > <div id="Framework-Trace" style="display: none;"> > > > <pre><code>vendor/rails/activerecord/lib/active_record/connection_adapt > ers/abstract_adapter.rb > > :147:in `log' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:446:in > `execut > > e' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:167:in > > `update_sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:457:in > `update > > _sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:49:in > > `update_without_query_dirty' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/query_cache.rb:19:in > `updat > > e' > > vendor/rails/activerecord/lib/active_record/base.rb:2481:in > `update_without_lock' > > vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:70:in > `update_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:137:in > `update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:234:in > `update_without_timestamps' > > vendor/rails/activerecord/lib/active_record/timestamp.rb:38:in `update' > > vendor/rails/activerecord/lib/active_record/base.rb:2472:in > `create_or_update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:207:in > `create_or_update' > > vendor/rails/activerecord/lib/active_record/base.rb:2200:in > `save_without_validation' > > vendor/rails/activerecord/lib/active_record/validations.rb:901:in > `save_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:75:in > `save_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/transactions.rb:118:in > `rollback_active_record_state!' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/validations.rb:922:in > `update_attribute' > > vendor/plugins/acts_as_list/lib/active_record/acts/list.rb:126:in > `remove_from_list' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `evaluate_method' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:161:in > `call' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:272:in > `run_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:298:in > `callback' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:288:in > `destroy_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > vendor/rails/actionpack/lib/action_controller/base.rb:1162:in `send' > > vendor/rails/actionpack/lib/action_controller/base.rb:1162:in > `perform_action_without_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:580:in > `call_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:573:in > `perform_action_without_benchmark' > > vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in > `perform_action_without_rescue' > > /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure' > > vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in > `perform_action_without_rescue' > > vendor/rails/actionpack/lib/action_controller/rescue.rb:201:in > `perform_action_without_caching' > > vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:i > n > `perform_action' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/query_cache.rb:33:in > `cache > > ' > > vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache' > > vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:i > n > `perform_action' > > vendor/rails/actionpack/lib/action_controller/base.rb:529:in `send' > > vendor/rails/actionpack/lib/action_controller/base.rb:529:in > `process_without_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:569:in > `process_without_session_management_ > > support' > > vendor/rails/actionpack/lib/action_controller/session_management.rb:130 > :in > `process' > > vendor/rails/actionpack/lib/action_controller/base.rb:389:in `process' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:149:in > `handle_request' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:107:in > `dispatch' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in > `synchronize' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in > `dispatch' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:120:in > `dispatch_cgi' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:35:in > `dispatch' > > vendor/rails/railties/lib/fcgi_handler.rb:103:in `process_request' > > vendor/rails/railties/lib/fcgi_handler.rb:153:in `with_signal_handler' > > vendor/rails/railties/lib/fcgi_handler.rb:101:in `process_request' > > vendor/rails/railties/lib/fcgi_handler.rb:78:in `process_each_request' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:612:in > `each_cgi' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in `each' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in > `each_cgi' > > vendor/rails/railties/lib/fcgi_handler.rb:77:in `process_each_request' > > vendor/rails/railties/lib/fcgi_handler.rb:76:in `catch' > > vendor/rails/railties/lib/fcgi_handler.rb:76:in `process_each_request' > > vendor/rails/railties/lib/fcgi_handler.rb:50:in `process!' > > vendor/rails/railties/lib/fcgi_handler.rb:24:in `process!' > > dispatch.fcgi:24</code></pre> > > </div> > > > > <div id="Full-Trace" style="display: none;"> > > > <pre><code>vendor/rails/activerecord/lib/active_record/connection_adapt > ers/abstract_adapter.rb > > :147:in `log' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:446:in > `execut > > e' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:167:in > > `update_sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/postgre > sql_adapter.rb:457:in > `update > > _sql' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:49:in > > `update_without_query_dirty' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/query_cache.rb:19:in > `updat > > e' > > vendor/rails/activerecord/lib/active_record/base.rb:2481:in > `update_without_lock' > > vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:70:in > `update_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:137:in > `update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:234:in > `update_without_timestamps' > > vendor/rails/activerecord/lib/active_record/timestamp.rb:38:in `update' > > vendor/rails/activerecord/lib/active_record/base.rb:2472:in > `create_or_update_without_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:207:in > `create_or_update' > > vendor/rails/activerecord/lib/active_record/base.rb:2200:in > `save_without_validation' > > vendor/rails/activerecord/lib/active_record/validations.rb:901:in > `save_without_dirty' > > vendor/rails/activerecord/lib/active_record/dirty.rb:75:in > `save_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/transactions.rb:118:in > `rollback_active_record_state!' > > vendor/rails/activerecord/lib/active_record/transactions.rb:106:in > `save' > > vendor/rails/activerecord/lib/active_record/validations.rb:922:in > `update_attribute' > > vendor/plugins/acts_as_list/lib/active_record/acts/list.rb:126:in > `remove_from_list' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:173:in > `evaluate_method' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:161:in > `call' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run' > > vendor/rails/activesupport/lib/active_support/callbacks.rb:272:in > `run_callbacks' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:298:in > `callback' > > vendor/rails/activerecord/lib/active_record/callbacks.rb:288:in > `destroy_without_transactions' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/database_statements.rb:66:in > > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:79:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:98:in > `transaction' > > vendor/rails/activerecord/lib/active_record/transactions.rb:102:in > `destroy' > > app/controllers/projects_controller.rb:159:in `destroy' > > vendor/rails/actionpack/lib/action_controller/base.rb:1162:in `send' > > vendor/rails/actionpack/lib/action_controller/base.rb:1162:in > `perform_action_without_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:580:in > `call_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:573:in > `perform_action_without_benchmark' > > vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in > `perform_action_without_rescue' > > /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure' > > vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in > `perform_action_without_rescue' > > vendor/rails/actionpack/lib/action_controller/rescue.rb:201:in > `perform_action_without_caching' > > vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:i > n > `perform_action' > > vendor/rails/activerecord/lib/active_record/connection_adapters/abstrac > t/query_cache.rb:33:in > `cache > > ' > > vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache' > > vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:i > n > `perform_action' > > vendor/rails/actionpack/lib/action_controller/base.rb:529:in `send' > > vendor/rails/actionpack/lib/action_controller/base.rb:529:in > `process_without_filters' > > vendor/rails/actionpack/lib/action_controller/filters.rb:569:in > `process_without_session_management_ > > support' > > vendor/rails/actionpack/lib/action_controller/session_management.rb:130 > :in > `process' > > vendor/rails/actionpack/lib/action_controller/base.rb:389:in `process' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:149:in > `handle_request' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:107:in > `dispatch' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in > `synchronize' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in > `dispatch' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:120:in > `dispatch_cgi' > > vendor/rails/actionpack/lib/action_controller/dispatcher.rb:35:in > `dispatch' > > vendor/rails/railties/lib/fcgi_handler.rb:103:in `process_request' > > vendor/rails/railties/lib/fcgi_handler.rb:153:in `with_signal_handler' > > vendor/rails/railties/lib/fcgi_handler.rb:101:in `process_request' > > vendor/rails/railties/lib/fcgi_handler.rb:78:in `process_each_request' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:612:in > `each_cgi' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in `each' > > /usr/local/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in > `each_cgi' > > vendor/rails/railties/lib/fcgi_handler.rb:77:in `process_each_request' > > vendor/rails/railties/lib/fcgi_handler.rb:76:in `catch' > > vendor/rails/railties/lib/fcgi_handler.rb:76:in `process_each_request' > > vendor/rails/railties/lib/fcgi_handler.rb:50:in `process!' > > vendor/rails/railties/lib/fcgi_handler.rb:24:in `process!' > > dispatch.fcgi:24</code></pre> > > </div> > > > > </div> > > <h2 style="margin-top: 30px">Request</h2> > > <p><b>Parameters</b>: <pre>{"format"=>"js", > > > "authenticity_token"=>"bc1b1998123e4fc82635e1fae9e6a8 > 44de76d234", > > "_method"=>"delete", > > "id"=>"38"}</pre></p> > > <p><a href="#" > onclick="document.getElementById('session_dump').style.display='block'; > return false;" > > >Show session dump</a></p> > > <div id="session_dump" style="display:none"><pre class='debug_dump'>--- > > :js_behaviours: > > expiry_time: 2008-07-23 12:32:55.419555 -03:00 > > user_id: 1 > > flash: !map:ActionController::Flash::FlashHash {} > > </pre></div> > > <h2 style="margin-top: 30px">Response</h2> > > <p><b>Headers</b>: <pre>{"cookie"=>[], > > "Cache-Control"=>"no-cache"}</pre></p> > > </body> > > </html> > > []'s > - Walter > _______________________________________________ > Tracks-discuss mailing list > [email protected] > http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
