[Tracks-discuss] error when removing a project

Wed, 23 Jul 2008 07:35:36 -0700 

The backtrace:


  ActiveRecord::StatementInvalid



    in ProjectsController#destroy



</h1>

<pre>RuntimeError: ERROR        C23502  Mnull value in column
&quot;position&quot; violates not-null constraint

        FexecMain.c     L1818   RExecConstraints: UPDATE &quot;projects&quot; 
SET
&quot;updated_at&quot; = '2008-07-23

 14:32:55.490699', &quot;position&quot; = NULL WHERE &quot;id&quot; = 38</pre>



    <div id="Application-Trace" style="display: block;">

      
<pre><code>vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb

:147:in `log'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:446:in
`execut

e'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:167:in

 `update_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:457:in
`update

_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:49:in

 `update_without_query_dirty'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/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/abstract/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/abstract/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_adapters/abstract_adapter.rb

:147:in `log'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:446:in
`execut

e'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:167:in

 `update_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:457:in
`update

_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:49:in

 `update_without_query_dirty'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/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/abstract/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/abstract/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:in
`perform_action'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/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:in
`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_adapters/abstract_adapter.rb

:147:in `log'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:446:in
`execut

e'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:167:in

 `update_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:457:in
`update

_sql'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:49:in

 `update_without_query_dirty'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/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/abstract/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/abstract/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:in
`perform_action'

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/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:in
`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>{&quot;format&quot;=&gt;&quot;js&quot;,

 
&quot;authenticity_token&quot;=&gt;&quot;bc1b1998123e4fc82635e1fae9e6a844de76d234&quot;,

 &quot;_method&quot;=&gt;&quot;delete&quot;,

 &quot;id&quot;=&gt;&quot;38&quot;}</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>{&quot;cookie&quot;=&gt;[],

 &quot;Cache-Control&quot;=&gt;&quot;no-cache&quot;}</pre></p>

</body>

</html>

[]'s
- Walter
_______________________________________________
Tracks-discuss mailing list
[email protected]
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

Reply via email to