Re: acid_ag_alert empty : can't have a Graph Alert Data in Base

[chido42 () free fr]

Sorry for the flood... Send my previous mail too early 

After some test and research the problem is not coming from the database. I have the correct data.
However my graph is still down and i don't know why.

Here is a copy/paste of base in debug_mode = 1
Chart criteria

Array
(
    [0] => 
    [1] =>  1 = 1 
)

chart_type = 1
data_source =
chart_begin_hour = "", hour_start = "20"
chart_end_hour = "", hour_end = "10"
year_start      year_end        month_start     month_end       day_start       day_end hour_start      hour_end
2010    2010    07      07      08      09      20      23
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 20
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 21
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 22
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 23
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 00
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 01
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 02
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 03
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 04
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 05
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 06
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 07
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 08
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 09
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 10
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 11
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 12
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 13
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 14
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 15
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 16
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 17
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 18
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 19
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 20
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 21
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 22
SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND 
DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 23
chart_type = 1
data_source =
chart_interval = 0
element_start = 0
count($xdata) = 28
Handling Period if necessary...
i = 0
element_start = 0
number_array_elements = 28
count(xdata) = 28

count(xdata) = 28
0 -- 07/08/2010 20:00:00 - 20:59:59 - 151
1 -- 07/08/2010 21:00:00 - 21:59:59 - 0
2 -- 07/08/2010 22:00:00 - 22:59:59 - 10
3 -- 07/08/2010 23:00:00 - 23:59:59 - 0
4 -- 07/09/2010 00:00:00 - 00:59:59 - 0
5 -- 07/09/2010 01:00:00 - 01:59:59 - 0
6 -- 07/09/2010 02:00:00 - 02:59:59 - 2
7 -- 07/09/2010 03:00:00 - 03:59:59 - 0
8 -- 07/09/2010 04:00:00 - 04:59:59 - 4
9 -- 07/09/2010 05:00:00 - 05:59:59 - 0
10 -- 07/09/2010 06:00:00 - 06:59:59 - 0
11 -- 07/09/2010 07:00:00 - 07:59:59 - 3
12 -- 07/09/2010 08:00:00 - 08:59:59 - 0
13 -- 07/09/2010 09:00:00 - 09:59:59 - 16
14 -- 07/09/2010 10:00:00 - 10:59:59 - 15
15 -- 07/09/2010 11:00:00 - 11:59:59 - 0
16 -- 07/09/2010 12:00:00 - 12:59:59 - 0
17 -- 07/09/2010 13:00:00 - 13:59:59 - 0
18 -- 07/09/2010 14:00:00 - 14:59:59 - 0
19 -- 07/09/2010 15:00:00 - 15:59:59 - 0
20 -- 07/09/2010 16:00:00 - 16:59:59 - 0
21 -- 07/09/2010 17:00:00 - 17:59:59 - 0
22 -- 07/09/2010 18:00:00 - 18:59:59 - 0
23 -- 07/09/2010 19:00:00 - 19:59:59 - 0
24 -- 07/09/2010 20:00:00 - 20:59:59 - 0
25 -- 07/09/2010 21:00:00 - 21:59:59 - 0
26 -- 07/09/2010 22:00:00 - 22:59:59 - 0
27 -- 07/09/2010 23:00:00 - 23:59:59 - 0
Drawing graph (600 x 800)

And then a picture of a broken image link.
If you have an idea how to correct that.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users