Fixed.
diff --git a/app/views/friends/_list.html.erb b/app/views/friends/
_list.html.erb
index 9578948..edb1e9f 100644
--- a/app/views/friends/_list.html.erb
+++ b/app/views/friends/_list.html.erb
@@ -2,7 +2,7 @@
profile ||= @profile
type ||= 'friends'
size ||= 20
-list = profile.send(type).find(:all, :limit => size, :order =>
'RAND()') rescue []
+list = profile.send(type).find(:all, :limit => size, :order =>
'RANDOM()') rescue []
total = profile.send(type).count
with_friending ||= false
RAND() isn't in postgresql.
Joe
On Oct 19, 2:36 pm, Joe Van Dyk <[EMAIL PROTECTED]> wrote:
> Does anyone else get these test errors?
>
> Joe
>
> On Oct 12, 5:20 pm, Joe Van Dyk <[EMAIL PROTECTED]> wrote:
>
> > Using postgresql on a fresh install of LovdByLess. Get a bunch of
> > these errors when running the tests. Any ideas? That query does
> > succeed when I run it manually in psql.
>
> > 25) Error:
> > test: rendering an avatar should use the user's icon if it exists.
> > (ProfilesControllerTest):
> > ActionView::TemplateError: PGError: ERROR: current transaction is
> > aborted, commands ignored until end of transaction block
> > : SELECT count(*) AS count_all FROM "profiles" INNER JOIN friends ON
> > profiles.id = friends.invited_id WHERE (("friends".inviter_id =
> > 8950599) AND ((status = 1)))
> > On line #6 of friends/_list.html.erb
>
> > 3: type ||= 'friends'
> > 4: size ||= 20
> > 5: list = profile.send(type).find(:all, :limit => size, :order =>
> > 'RAND()') rescue []
> > 6: total = profile.send(type).count
> > 7: with_friending ||= false
> > 8:
> > 9:
>
> > vendor/plugins/rows_logger/init.rb:36:in `log'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/postgresql_adapter.rb:484:in
> > `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/postgresql_adapter.rb:929:in
> > `select_raw'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/postgresql_adapter.rb:916:in
> > `select'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/database_statements.rb:7:in
> > `select_all_without_query_cache'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/query_cache.rb:59:in
> > `select_all'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/query_cache.rb:80:in
> > `cache_sql'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/query_cache.rb:59:in
> > `select_all'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/database_statements.rb:
> > 13:in `select_one'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/database_statements.rb:
> > 19:in `select_value'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/calculations.rb:225:in `execute_simple_calculation'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/calculations.rb:126:in `calculate'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/calculations.rb:122:in `catch'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/calculations.rb:122:in `calculate'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/calculations.rb:48:in `count'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/associations/has_many_through_association.rb:41:in
> > `count'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/base.rb:1857:in `with_scope'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/associations/has_many_through_association.rb:41:in
> > `send'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/associations/has_many_through_association.rb:41:in
> > `count'
> > app/views/friends/_list.html.erb:6:in
> > `_run_erb_47app47views47friends47_list46html46erb'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partial_template.rb:20:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:26:in `benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/
> > active_support/core_ext/benchmark.rb:8:in `realtime'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:26:in `benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partial_template.rb:19:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template.rb:22:in `render_template'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partials.rb:110:in `render_partial'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:277:in `render'
> > app/views/profiles/_public.html.erb:64:in
> > `_run_erb_47app47views47profiles47_public46html46erb'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partial_template.rb:20:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:26:in `benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/
> > active_support/core_ext/benchmark.rb:8:in `realtime'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:26:in `benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partial_template.rb:19:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template.rb:22:in `render_template'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > partials.rb:110:in `render_partial'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:277:in `render'
> > app/views/profiles/show.html.erb:16:in
> > `_run_erb_47app47views47profiles47show46html46erb'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:342:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template_handlers/compilable.rb:29:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template.rb:35:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > template.rb:22:in `render_template'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/action_view/
> > base.rb:248:in `render_file'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:1112:in `render_for_file'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:845:in `render_with_no_layout'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/layout.rb:251:in `render_without_benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:51:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/
> > active_support/core_ext/benchmark.rb:8:in `realtime'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:51:in `render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:1161:in `default_render'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:1167:in `perform_action_without_filters'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/filters.rb:579:in `call_filters'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/filters.rb:572:in `perform_action_without_benchmark'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:68:in
> > `perform_action_without_rescue'
> > /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/benchmarking.rb:68:in
> > `perform_action_without_rescue'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/rescue.rb:201:in `perform_action_without_caching'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/caching/sql_cache.rb:13:in `perform_action'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/connection_adapters/abstract/query_cache.rb:33:in
> > `cache'
> > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/
> > active_record/query_cache.rb:8:in `cache'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/caching/sql_cache.rb:12:in `perform_action'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:529:in `send'
> > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.1.1/lib/
> > action_controller/base.rb:529:in `process_without_filters'
> >
>
> ...
>
> read more »
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Lovd by Less" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/lovdbyless?hl=en
Who loves ya baby?
-~----------~----~----~----~------~----~------~--~---
