[Mageia-sysadm] bugzilla internal error

[Manuel Hiebel]

Le 25/03/2013 20:27, Thierry Vignaud a écrit :
> On 12 March 2013 08:31, Thierry Vignaud <thierry.vignaud at gmail.com> wrote:
>> this worked previously
>>
>> https://bugs.mageia.org/buglist.cgi?cmdtype=runnamed&namedcmd=last%203%20days&list_id=1363
>>
>> Software error:
>>
>> DBD::Pg::db selectcol_arrayref failed: ERROR:  invalid input syntax
>> for type timestamp: "-3"
>> LINE 13: ...MED','NEW','ASSIGNED','REOPENED')  AND bugs.delta_ts >= '-3'
>>                                                                      ^
>> [for Statement "SELECT bugs.bug_id AS bug_id, bugs.priority AS
>> priority, bugs.bug_severity AS bug_severity
>>    FROM bugs
>> LEFT JOIN bug_group_map AS security_map ON bugs.bug_id =
>> security_map.bug_id AND NOT ( security_map.group_id IN (8) )
>> LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND
>> security_cc.who = 81
>> INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
>> INNER JOIN bug_severity AS map_bug_severity ON bugs.bug_severity =
>> map_bug_severity.value
>>   WHERE bugs.creation_ts IS NOT NULL
>>     AND (security_map.group_id IS NULL
>>          OR (bugs.reporter_accessible = 1 AND bugs.reporter = 81)
>>          OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
>>          OR bugs.assigned_to = 81
>>          OR bugs.qa_contact = 81)
>>     AND  bugs.bug_status IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED')
>>   AND bugs.delta_ts >= '-3'
>> GROUP BY bugs.bug_id,
>> bugs.priority,bugs.bug_severity,map_priority.sortkey,map_priority.value,map_bug_severity.sortkey,map_bug_severity.value
>> ORDER BY map_priority.sortkey, map_priority.value,
>> map_bug_severity.sortkey, map_bug_severity.value
>> "] at /usr/share/bugzilla/lib/Bugzilla/Search.pm line 708
>> Bugzilla::Search::data('Bugzilla::Search=HASH(0x4200568)') called at
>> /usr/share/bugzilla/www/buglist.cgi line 736
>>
>> For help, please send mail to the webmaster (root at localhost), giving
>> this error message and the time and date of the error.
> ping?

Was the search a list bugs modified since 3 days ?
if yes maybe making a new one with 
https://bugs.mageia.org/buglist.cgi?list_id=2398&chfieldto=Now&query_format=advanced&chfieldfrom=-3d&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED