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
|
<!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=%3CCAONrEtbW6UCqghvNfQiUXCGJ__%3D3i99kqH0txWZgn7q1_DqejA%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="005045.html">
<LINK REL="Next" HREF="005058.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=%3CCAONrEtbW6UCqghvNfQiUXCGJ__%3D3i99kqH0txWZgn7q1_DqejA%40mail.gmail.com%3E"
TITLE="[Mageia-sysadm] bugzilla internal error">thierry.vignaud at gmail.com
</A><BR>
<I>Mon Mar 25 20:27:17 CET 2013</I>
<P><UL>
<LI>Previous message: <A HREF="005045.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI>Next message: <A HREF="005058.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5057">[ date ]</a>
<a href="thread.html#5057">[ thread ]</a>
<a href="subject.html#5057">[ subject ]</a>
<a href="author.html#5057">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>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> 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>
ping?
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="005045.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI>Next message: <A HREF="005058.html">[Mageia-sysadm] bugzilla internal error
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#5057">[ date ]</a>
<a href="thread.html#5057">[ thread ]</a>
<a href="subject.html#5057">[ subject ]</a>
<a href="author.html#5057">[ 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>
|
