[Mageia-sysadm] bugzilla internal error

[Thierry Vignaud]

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?