Globalize doesn't work: HELP ME PLEASE...

Hi to all,

seems that Globalize creates wrong sql statements on dynamic finders on translated columns (find_by_{attribute}) when locale is not en-US.

Globalize Plugin (for_1_2) installed on vendor/plugins under application root Rails 1.2.3 Ruby 1.8.6 Mysql Ver 14.12 Distrib 5.0.37, for redhat-linux-gnu (i686) using readline 5.0 Fedora Core 7

Example:

Migration / Table:

db/migrate/001_test1.rb class Test1 < ActiveRecord::Migration   def self.up     create_table(:test1s, :options => 'DEFAULT CHARSET=UTF8') do |t|       t.column :name, :string, :limit => 100, :null => false       t.column :description, :string, :limit => 100, :null => false       t.column :created_at, :datetime, :null => false       t.column :updated_at, :datetime, :null => false     end   end   def self.down     drop_table :test1s   end end

Model: app/models/test1.rb class Test1 < ActiveRecord::Base   translates :description   validates_presence_of :name, :description   validates_uniqueness_of :name, :description end

Configuration: config/environment.rb ... on last line... Globalize::Locale.set_base_language "en-US"

Run rake db:migrate

Run script/console

t=Test1.new => #<Test1:0xb76b1bf8 @attributes={"name"=>"", "updated_at"=>nil, "description"=>"", "created_at"=>nil}, @new_record=true> t.name="n1" => "n1" t.description="d1" => "d1" t.save! => true

Globalize::Locale.set "en-US" => #<Globalize::Locale:0xb769db08 @currency_decimal_sep=".", @currency_format=nil, @decimal_sep=".", @language=English, @code="en-US", @date_format=nil, @thousands_sep=",", @country=#<Globalize::Country:0xb76999e0 @attributes={"date_format"=>nil, "currency_decimal_sep"=>".", "thousands_sep"=>",", "code"=>"US", "number_grouping_scheme"=>"western", "english_name"=>"United States of America", "decimal_sep"=>".", "id"=>"223", "currency_code"=>"USD", "currency_format"=>nil}>, @number_grouping_scheme=:western, @currency_code="USD">

Test1.find_by_description("d1") => #<Test1:0xb76943b4 @original_language=English, @attributes={"name"=>"n1", "updated_at"=>"2007-08-09 11:24:49", "id"=>"3", "description"=>"d1", "created_at"=>"2007-08-09 11:24:49"}>

# All works only because the locale is en-US...

Globalize::Locale.set "it-IT" => #<Globalize::Locale:0xb769271c @currency_decimal_sep=",", @currency_format="€ %n", @decimal_sep=",", @language=Italian, @code="it-IT", @date_format=nil, @thousands_sep=".", @country=#<Globalize::Country:0xb768ff08 @attributes={"date_format"=>nil, "currency_decimal_sep"=>",", "thousands_sep"=>".", "code"=>"IT", "number_grouping_scheme"=>"western", "english_name"=>"Italy", "decimal_sep"=>",", "id"=>"106", "currency_code"=>"EUR", "currency_format"=>"€ %n"}>, @number_grouping_scheme=:western, @currency_code="EUR">

Test1.find_by_description("d1") ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COALESCE(t_description.text, test1s.description) = 'd1') LIMIT 1' at line 1: SELECT test1s.id, test1s.name, test1s.created_at, test1s.updated_at, COALESCE(t_description.text, test1s.description) AS description, t_description.text AS description_not_base FROM test1s LEFT OUTER JOIN globalize_translations AS t_description ON t_description.table_name = 'test1s' AND test1s.id = t_description.item_id AND t_description.facet = 'description' AND t_description.language_id = 2600 WHERE (test1s. COALESCE(t_description.text, test1s.description) = 'd1') LIMIT 1         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in

`log'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in

`execute'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:399:in

`select'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in

`select_all'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:427:in

`find_by_sql'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:997:in

`globalize_old_find_every'         from ./script/../config/../config/../vendor/plugins/for-1.2/lib/globalize/localization/db_translate.rb:885:in

`find_every'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:991:in

`find_initial'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in

`send'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in

`method_missing'         from /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/deprecation.rb:44:in

`silence'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in

`method_missing'         from (irb):9

# And now this not works because the locale is "it-IT" WHY ???

I think this is a Globalize bug but I'm not 100% sure...

Someone can help me ???

Thanks in advance to everyone...

Tex