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
96
97
98
99
100
101
|
<!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=%3C5150A7CB.2040503%40hiebel.eu%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="005057.html">
<LINK REL="Next" HREF="005046.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] bugzilla internal error</H1>
<B>Manuel Hiebel</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20bugzilla%20internal%20error&In-Reply-To=%3C5150A7CB.2040503%40hiebel.eu%3E"
TITLE="[Mageia-sysadm] bugzilla internal error">manuel.mageia at hiebel.eu
</A><BR>
<I>Mon Mar 25 20:38:51 CET 2013</I>
<P><UL>
<LI>Previous message: <A HREF="005057.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI>Next message: <A HREF="005046.html">[Mageia-sysadm] New Mirror not being recognised
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5058">[ date ]</a>
<a href="thread.html#5058">[ thread ]</a>
<a href="subject.html#5058">[ subject ]</a>
<a href="author.html#5058">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Le 25/03/2013 20:27, Thierry Vignaud a écrit :
><i> On 12 March 2013 08:31, Thierry Vignaud <<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">thierry.vignaud at gmail.com</A>> wrote:
</I>>><i> this worked previously
</I>>><i>
</I>>><i> <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>
</I>>><i>
</I>>><i> Software error:
</I>>><i>
</I>>><i> DBD::Pg::db selectcol_arrayref failed: ERROR: invalid input syntax
</I>>><i> for type timestamp: "-3"
</I>>><i> LINE 13: ...MED','NEW','ASSIGNED','REOPENED') AND bugs.delta_ts >= '-3'
</I>>><i> ^
</I>>><i> [for Statement "SELECT bugs.bug_id AS bug_id, bugs.priority AS
</I>>><i> priority, bugs.bug_severity AS bug_severity
</I>>><i> FROM bugs
</I>>><i> LEFT JOIN bug_group_map AS security_map ON bugs.bug_id =
</I>>><i> security_map.bug_id AND NOT ( security_map.group_id IN (8) )
</I>>><i> LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND
</I>>><i> security_cc.who = 81
</I>>><i> INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
</I>>><i> INNER JOIN bug_severity AS map_bug_severity ON bugs.bug_severity =
</I>>><i> map_bug_severity.value
</I>>><i> WHERE bugs.creation_ts IS NOT NULL
</I>>><i> AND (security_map.group_id IS NULL
</I>>><i> OR (bugs.reporter_accessible = 1 AND bugs.reporter = 81)
</I>>><i> OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
</I>>><i> OR bugs.assigned_to = 81
</I>>><i> OR bugs.qa_contact = 81)
</I>>><i> AND bugs.bug_status IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED')
</I>>><i> AND bugs.delta_ts >= '-3'
</I>>><i> GROUP BY bugs.bug_id,
</I>>><i> bugs.priority,bugs.bug_severity,map_priority.sortkey,map_priority.value,map_bug_severity.sortkey,map_bug_severity.value
</I>>><i> ORDER BY map_priority.sortkey, map_priority.value,
</I>>><i> map_bug_severity.sortkey, map_bug_severity.value
</I>>><i> "] at /usr/share/bugzilla/lib/Bugzilla/Search.pm line 708
</I>>><i> Bugzilla::Search::data('Bugzilla::Search=HASH(0x4200568)') called at
</I>>><i> /usr/share/bugzilla/www/buglist.cgi line 736
</I>>><i>
</I>>><i> For help, please send mail to the webmaster (<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">root at localhost</A>), giving
</I>>><i> this error message and the time and date of the error.
</I>><i> ping?
</I>
Was the search a list bugs modified since 3 days ?
if yes maybe making a new one with
<A HREF="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">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</A>
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="005057.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI>Next message: <A HREF="005046.html">[Mageia-sysadm] New Mirror not being recognised
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5058">[ date ]</a>
<a href="thread.html#5058">[ thread ]</a>
<a href="subject.html#5058">[ subject ]</a>
<a href="author.html#5058">[ 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>
|
