acid-0.9.6b15: phplot graphs and time criteria

[Andreas Hasenack <andreas () conectiva com br>]

Whenever I select any of the "chart begin" or "chart end" criterias
in the graph page I get the following errors (debug=1):


Criteria warning: Multiple Time/Date criteria entered without a boolean operator (e.g. AND, OR) between them.



Chart criteria
Array
(
    [0] => LEFT JOIN acid_ag_alert ON (acid_event.sid=acid_ag_alert.ag_sid AND acid_event.cid=acid_ag_alert.ag_cid) 
    [1] => ag_id = 4 AND  AND (  UNIX_TIMESTAMP(timestamp) >=  UNIX_TIMESTAMP('2001-09-01 000000')         
UNIX_TIMESTAMP(timestamp) >=  UNIX_TIMESTAMP('2001-09-17 000000')       ) 
)
chart_type = 2
 data_source = 4
Database ERROR:You have an error in your SQL syntax near 'AND ( UNIX_TIMESTAMP(timestamp) >= UNIX_TIMESTAMP('2001-09-01 
000000') ' at line 1


SELECT min(timestamp), max(timestamp) FROM acid_event LEFT JOIN acid_ag_alert ON (acid_event.sid=acid_ag_alert.ag_sid 
AND acid_event.cid=acid_ag_alert.ag_cid)  WHERE ag_id = 4 AND  AND (  UNIX_TIMESTAMP(timestamp) >=  
UNIX_TIMESTAMP('2001-09-01 000000')         UNIX_TIMESTAMP(timestamp) >=  UNIX_TIMESTAMP('2001-09-17 000000')       ) 


This is acid-0.9.6b15 (tarball), php-4.0.6, mysql-3.23.33.

Attachment: _bin
Description: