605393 - Unfriendly error message when entering "^" into the date picker in advanced search

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

Very much edge-case, but if you:

1. Load http://crash-stats.stage.mozilla.com/query
2. Enter "^" into the date picker ("For the period of [x] weeks before ______")

You'll get:

An error was detected which prevented the loading of this page. If this problem persists, please contact the website administrator.

application/libraries/drivers/Database/Pgsql.php [74]:

pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type timestamp: "^"

Comment 1

[Stephen Donner [:stephend] Not actively reading bugmail]

See also http://crash-stats.stage.mozilla.com/report/list?range_unit=weeks&query_search=signature&hang_type=any&query_type=exact&plugin_query=&do_query=&plugin_query_type=&date=<script>var+pf_687474703a2f2f63726173682d73746174732e73746167652e6d6f7a696c6c612e636f6d2f7265706f72742f6c697374_64617465=new+Boolean();</script>&query=&missing_sig=&build_id=&plugin_field=&process_type=any&version=Firefox%3A4.0b6&signature=js_fun_apply%28JSContext*%2C%20unsigned%20int%2C%20js%3A%3AValue*%29&page=2/&range_value=2

Comment 2

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Committing for 1.7.6.

==

Sending        webapp-php/application/models/common.php
Transmitting file data .
Committed revision 2774.

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; thanks, Ryan!