More data points...
under jruby it works fine and that uses gem postgres-pr (0.4.0)
under Regular Ruby it fails as above and it uses gem postgres
(0.7.9.2007.12.12)
Hope that helps in tracking the problem down.
I am still not sure what the consensus is on which postgres gem to
use, although with jruby there is no choice.
Thanks
On Jun 30, 1:50 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
> Oh and yes I upgraded from 1.5.1 where it did work ok.
>
> On Jun 30, 12:54 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
>
> > I simplified the test to...
>
> > @db[:profiles].each do |r|
> > puts r[:email] + ", " + r[:experience] + ", " + r[:created_at]
> > end
>
> > I'm not even looking at the dob field which is a date and NULL, and I
> > get this...
>
> > F, [2008-06-30T12:51:51.344626 #22762] FATAL -- : Invalid date value
> > '' (invalid date) (Sequel::Error::InvalidValue)
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > core_ext.rb:159:in `to_date'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:172
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:528:in `call'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:528:in `fetch_rows'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:524:in `each'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:524:in `fetch_rows'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:522:in `each'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:522:in `fetch_rows'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:60:in `[]'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:60:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:229:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > connection_pool.rb:90:in `hold'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:229:in `execute'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > adapters/postgres.rb:521:in `fetch_rows'
> > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > dataset.rb:231:in `each'
> > sequel_date_bug.rb:19:in `check'
> > sequel_date_bug.rb:78:in `run'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:25:in
> > `call'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:25:in
> > `run'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:13:in
> > `catch'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:13:in
> > `run'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/factories.rb:
> > 11:in `run'
> > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/factories.rb:
> > 16:in `Main'
> > sequel_date_bug.rb:27
>
> > On Jun 30, 12:17 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
>
> > > Hi, thanks for looking at this.
>
> > > The error comes from sequel not my code here is the stack dump...
>
> > > I, [2008-06-30T12:12:17.899823 #22006] INFO -- : SELECT "username",
> > > "users"."email", "last_ip", "password", "experience",
> > > "users"."created_at", "disabled", "profiles"."dob" FROM "users" INNER
> > > JOIN "profiles" ON ("profiles"."user_id" = "users"."id") WHERE
> > > ("referrer" = 2)
> > > I, [2008-06-30T12:12:17.901634 #22006] INFO -- : Invalid date value
> > > '' (invalid date)
> > > I, [2008-06-30T12:12:17.901708 #22006] INFO -- : Invalid date value
> > > '' (invalid date)
> > > F, [2008-06-30T12:12:17.901790 #22006] FATAL -- : Invalid date value
> > > '' (invalid date) (Sequel::Error::InvalidValue)
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > core_ext.rb:159:in `to_date'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:172
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:528:in `call'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:528:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:524:in `each'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:524:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:522:in `each'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:522:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:60:in `[]'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:60:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:229:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > connection_pool.rb:83:in `hold'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:229:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:521:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > dataset.rb:231:in `each'
> > > check_referrals.rb:29:in `check'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > dataset.rb:234:in `each'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:533:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:522:in `each'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:522:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:60:in `[]'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:60:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:229:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > connection_pool.rb:90:in `hold'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:229:in `execute'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > adapters/postgres.rb:521:in `fetch_rows'
> > > /usr/local/lib/ruby/gems/1.8/gems/sequel_core-2.1.0/lib/sequel_core/
> > > dataset.rb:231:in `each'
> > > check_referrals.rb:23:in `check'
> > > check_referrals.rb:89:in `run'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:25:in
> > > `call'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:25:in
> > > `run'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:13:in
> > > `catch'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/base.rb:13:in
> > > `run'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/factories.rb:
> > > 11:in `run'
> > > /usr/local/lib/ruby/gems/1.8/gems/main-2.8.0/lib/main/factories.rb:
> > > 16:in `Main'
> > > check_referrals.rb:38
>
> > > The database column is a date field, and may be null.
>
> > > The fetch I do is..
>
> > > @users.join(:profiles, :user_id => :id).filter(:referrer =>
> > > userid).select(:username, :users__email, :last_ip, :password,
> > > :experience, :users__created_at, :disabled, :profiles__dob).each
>
> > > The field that is null and causes the error is :profiles__dob, if I
> > > leave that out, or set all dob fields to something then I don't get
> > > the error.
>
> > > I looked at the relevant sequel code, and for some reason it is
> > > passing a nil value onto the date conversion, but that does not make a
> > > lot of sense as it seems to check for nil.
>
> > > Thanks
> > > Jim
>
> > > On Jun 30, 7:43 am, Jeremy Evans <[EMAIL PROTECTED]> wrote:
>
> > > > On Jun 29, 1:23 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
>
> > > > > I just upgraded to 2.1.0, I'm using posgresql and my script that was
> > > > > working now throws a
>
> > > > > Invalid date value '' (invalid date) (Sequel::Error::InvalidValue)
>
> > > > > when it reads a date from the database that is NULL.
> > > > > It did not used to do this, and having NULL dates in the database is
> > > > > very much an OK thing.
>
> > > > > Any work arounds?
>
> > > > The adapter type conversion code converts NULLs to nil. Apparantly,
> > > > your code does something like nil.to_s.to_date, which would lead to
> > > > the error you describe. Without seeing your code, I can't tell you
> > > > how to fix it. My guess is that you upgraded from version 1.5.1 or
> > > > previous, and the model typecasting code introduced in 2.0.0 is now
> > > > giving you an error, but that's just a guess. Please pastie your code
> > > > somewhere with a full traceback if you would like me to look into it.
>
> > > > Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" 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/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
