Re: acid-0.9.6b15: phplot graphs and time criteria

[roman () danyliw com]

Fixed in CVS.

Roman

> --9JSHP372f+2dzJ8X
> Content-Type: text/plain; charset=us-ascii
> Content-Disposition: inline
> Content-Transfer-Encoding: quoted-printable
>
> Whenever I select any of the "chart begin" or "chart end" criterias
> in the graph page I get the following errors (debug=3D1):
>
>
> Criteria warning: Multiple Time/Date criteria entered without a boolean ope=
> rator (e.g. AND, OR) between them.
>
>
>
> Chart criteria
> Array
> (
>     [0] =3D> LEFT JOIN acid_ag_alert ON (acid_event.sid=3Dacid_ag_alert.ag_=
> sid AND acid_event.cid=3Dacid_ag_alert.ag_cid)=20
>     [1] =3D> ag_id =3D 4 AND  AND (  UNIX_TIMESTAMP(timestamp) >=3D  UNIX_T=
> IMESTAMP('2001-09-01 000000')         UNIX_TIMESTAMP(timestamp) >=3D  UNIX_=
> TIMESTAMP('2001-09-17 000000')       )=20
> )
> chart_type =3D 2
>  data_source =3D 4
> Database ERROR:You have an error in your SQL syntax near 'AND ( UNIX_TIMEST=
> AMP(timestamp) >=3D UNIX_TIMESTAMP('2001-09-01 000000') ' at line 1
>
>
> SELECT min(timestamp), max(timestamp) FROM acid_event LEFT JOIN acid_ag_ale=
> rt ON (acid_event.sid=3Dacid_ag_alert.ag_sid AND acid_event.cid=3Dacid_ag_a=
> lert.ag_cid)  WHERE ag_id =3D 4 AND  AND (  UNIX_TIMESTAMP(timestamp) >=3D =
>  UNIX_TIMESTAMP('2001-09-01 000000')         UNIX_TIMESTAMP(timestamp) >=3D=
>   UNIX_TIMESTAMP('2001-09-17 000000')       )=20
>
>
> This is acid-0.9.6b15 (tarball), php-4.0.6, mysql-3.23.33.
>
>
> --9JSHP372f+2dzJ8X
> Content-Type: application/pgp-signature
> Content-Disposition: inline
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iEYEARECAAYFAjumExQACgkQeEJZs/PdwpCnNwCdEGfIsvydcpKBYWbaWPs9aSrx
> 1Z8AoMmiNP3xv9G8Ivx7OkCuibqve2H/
> =FkZY
> -----END PGP SIGNATURE-----
>
> --9JSHP372f+2dzJ8X--
>
> _______________________________________________
> 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



---------------------------------------------
This message was sent using Voicenet WebMail.
      http://www.voicenet.com/webmail/



_______________________________________________
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