Translations: English
Search on Docs:
   
ActionItem Search:

#2200: Filter purchase orders by status doesn't works

Type: BugItem Feature: Plugins Tags: colivre, redemoinho
ScheduledFor: 0.34.1 Assigned to: JoenioCosta Sites:  
Priority: 0 Status: Done  

Description of the bug

Go to: Control panel → Purchase order → (change status to Cancelled) → (Click on Filter)

ActiveRecord::StatementInvalid in Shopping cart plugin myprofileController#reports

PGError: ERRO:  operador não existe: integer == integer
LINE 1: …reated_at <= '2011-11-29 00:00:00.000000' AND status == 0)) 
                                                                ^
HINT:  Nenhum operador corresponde com o nome e o(s) tipo(s) de argumento(s) informados.
 Você precisa adicionar conversões de tipo explícitas.
: SELECT * FROM "shopping_cart_plugin_purchase_orders"
     WHERE ("shopping_cart_plugin_purchase_orders".seller_id = 5 AND (created_at >= '2011-11-01 00:00:00.000000' AND
 created_at <= '2011-11-29 00:00:00.000000' AND status == 0))


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:457:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:894:in `select_raw'
vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:881:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in `cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all'
vendor/rails/activerecord/lib/active_record/base.rb:582:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1341:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:536:in `find'
vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:47:in `find'
config/plugins/shopping_cart/controllers/shopping_cart_plugin_myprofile_controller.rb:32:in `reports'
/usr/bin/mongrel_rails:129:in `run'
/usr/bin/mongrel_rails:282

-- JoenioCosta -- 28 Nov 2011

Merge request Gitorious:79

-- JoenioCosta - 28 Nov 2011
Add comment
You need to login to be able to comment.
 

ActionItemForm edit

Title Filter purchase orders by status doesn't works
ActionItemType BugItem
Priority Low
Tags colivre, redemoinho
Feature Plugins
Plugin ShoppingCartPlugin
ResponsibleDevelopers JoenioCosta
ScheduledFor 0.34.1
AffectsVersion
Status Done
Ticket SAC:23365
Topic revision: r1 - 22 May 2015, UnknownUser

irc Talk with Devs Now!

Copyright © 2007-2019 by the Noosfero contributors
Colivre - Cooperativa de Tecnologias Livres