1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-sysadm] bugzilla internal error
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20bugzilla%20internal%20error&In-Reply-To=%3CCAONrEtZkw-9e%2B1aFDM0f2LNm20UuZhR0KeHH%3D__bgLUvda1vcw%40mail.gmail.com%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="005044.html">
<LINK REL="Next" HREF="005057.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] bugzilla internal error</H1>
<B>Thierry Vignaud</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20bugzilla%20internal%20error&In-Reply-To=%3CCAONrEtZkw-9e%2B1aFDM0f2LNm20UuZhR0KeHH%3D__bgLUvda1vcw%40mail.gmail.com%3E"
TITLE="[Mageia-sysadm] bugzilla internal error">thierry.vignaud at gmail.com
</A><BR>
<I>Tue Mar 12 08:31:29 CET 2013</I>
<P><UL>
<LI>Previous message: <A HREF="005044.html">[Mageia-sysadm] whitelisting the sender of translation notifications
</A></li>
<LI>Next message: <A HREF="005057.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5045">[ date ]</a>
<a href="thread.html#5045">[ thread ]</a>
<a href="subject.html#5045">[ subject ]</a>
<a href="author.html#5045">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>this worked previously
<A HREF="https://bugs.mageia.org/buglist.cgi?cmdtype=runnamed&namedcmd=last%203%20days&list_id=1363">https://bugs.mageia.org/buglist.cgi?cmdtype=runnamed&namedcmd=last%203%20days&list_id=1363</A>
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 (<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">root at localhost</A>), giving
this error message and the time and date of the error.
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="005044.html">[Mageia-sysadm] whitelisting the sender of translation notifications
</A></li>
<LI>Next message: <A HREF="005057.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5045">[ date ]</a>
<a href="thread.html#5045">[ thread ]</a>
<a href="subject.html#5045">[ subject ]</a>
<a href="author.html#5045">[ author ]</a>
</LI>
</UL>
<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm
mailing list</a><br>
</body></html>
|
