ActiveRecord::StatementInvalid in Taxons#show

38 views
Skip to first unread message

Nikolay

unread,
May 8, 2012, 4:24:57 AM5/8/12
to Synergy
После добавлении товаров в ветку таксонов и перехода по ссылке
http://178.63.209.220/t/brendy выдает следующую ошибку:

Как починить?

ActiveRecord::StatementInvalid in Taxons#show

Showing /home/deployer/.rvm/gems/ruby-1.9.3-p194/gems/
spree_core-0.60.6/app/views/taxons/_taxon.html.erb where line #3
raised:

SQLite3::SQLException: no such function: rand: SELECT "products".*
FROM "products" INNER JOIN "products_taxons" ON "products".id =
"products_taxons".product_id WHERE ("products_taxons".taxon_id = 4 )
AND (products.deleted_at is NULL) AND (products.available_on <=
'2012-05-08 08:10:16.688469') ORDER BY rand() LIMIT 6
Extracted source (around line #3):

1: <div class="taxon">
2: <h2><%= link_to taxon.name, seo_url(taxon), :class =>
'breadcrumbs' %></h2>
3: <%= render :partial => "shared/products", :locals => {:products
=> taxon_preview(taxon), :taxon => taxon} %>
4: </div>
Trace of template inclusion: /home/deployer/.rvm/gems/ruby-1.9.3-p194/
gems/spree_core-0.60.6/app/views/taxons/show.html.erb

Rails.root: /home/deployer/projects/synergy_app

Application Trace | Framework Trace | Full Trace
Request

Parameters:

{"id"=>"brendy"}
Show session dump

Show env dump

Response

Headers:

None

Denis Lukyanov

unread,
May 8, 2012, 4:34:00 AM5/8/12
to synerg...@googlegroups.com

Очевидно, перевести базу на MySQL.

Denis Lukyanov (Service & Consulting)

08.05.2012 12:24 пользователь "Nikolay" <itsni...@gmail.com> написал:

Nikolay

unread,
May 8, 2012, 7:14:55 AM5/8/12
to Synergy
Предположительно баг несовместимости с sqlite.
Решился миграцией с sqlite на mysql2.
Reply all
Reply to author
Forward
0 new messages