262126 - Invalid date parsing with MySQL 4.1

Status: RESOLVED FIXED

(Bugzilla :: Bugzilla-General, defect)

Description

[Vlad Dascalu]

I get:

[Wed Sep 29 18:27:02 2004] show_bug.cgi: Date/Time format (2004-09-29 16:47:43)
unrecogonzied at Bugzilla/Util.pm line 169.

By looking at the source it seems we expect 2004.09.29; I guess 2004-09-29
appears on my system as a combination of local settings and the newer MySQL that
I'm using; it makes sense to add the format to Bugzilla/Util.pm as well?

Comment 1

[Vlad Dascalu]

Attachment: V1

Comment 2

[Christian Reis]

Comment on attachment 160618 [details] [diff] [review]
V1

I don't see why this would be a problem. I already had this problem before and
added exactly the same hack as you.

Comment 3

[Dave Miller [:justdave]]

seems to me like we had DATE_FORMAT specifically requesting the times be
returned from the database with periods (for the DB compatibility stuff, since
certain other databases can ONLY do it that way).

The correct fix for this would be to find the broken or missing DATE_FORMAT calls.

Comment 4

[Dave Miller [:justdave]]

but that's something to do in 2.22, since we don't have DB compatibility yet
anyway :)

I don't believe this affects 2.16...  Bugzilla/Util.pm doesn't exist. :)

Comment 5

[Vlad Dascalu]

Checking in Bugzilla/Util.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Util.pm,v  <--  Util.pm
new revision: 1.13; previous revision: 1.12
done
Checking in Bugzilla/Util.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Util.pm,v  <--  Util.pm
new revision: 1.12.2.1; previous revision: 1.12
done