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
-~----------~----~----~----~------~----~------~--~---
