[Mageia-sysadm] bugzilla internal error

Thierry Vignaud thierry.vignaud at gmail.com
Tue Mar 12 08:31:29 CET 2013


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.


More information about the Mageia-sysadm mailing list