2588: Web API doesn't understand time zones in parameters

zoli.******@gmai***** (Google Code) (Is this you? Claim this profile.)
Feb. 1, 2014 
What version are you running?
1.6.6

What's the URL of the page containing the problem?
/api/review-requests/?repository=2&time-added-from=2010-06-27T16:26:30-08:00
According to the API docs at http://www.reviewboard.org/docs/manual/1.6/webapi/2.0/glossary/#term-date-time-format
the parameter value should be valid

What steps will reproduce the problem?
1. Send a GET request to the API:
/api/review-requests/?repository=2&time-added-from=2010-06-27T16:26:30-08:00
2. The response status is 500
3. When the time zone suffix is removed from the "time-added-from" parameter, the request is successful.

What is the expected output? What do you see instead?


What operating system are you using? What browser?


Please provide any additional information below.
#1 zoli.******@gmai***** (Google Code) (Is this you? Claim this profile.) 
The following message is in the server log:

ValueError: MySQL backend does not support timezone-aware datetimes.


<WSGIRequest
GET:<QueryDict: {u'time-added-from': [u'2010-06-27T16:26:30UTC'], u'repository': [u'1']}>,
david
#2 david
  • +Component-API
david
#3 david 
This has been fixed since 1.7
  • +Fixed