Re: [Os-sim-devel] Problems at Alarm_Console from last update

[David G. <dg...@os...>]

Mysql 4.1 does not complain about it, so I think you're using mysql 4.0.
Anyway, now is fixed, thanks!


El mi=E9, 21-09-2005 a las 01:49 -0300, sebastian serrano escribi=F3:
> Hi
>  I'm running ossim on a debian box. From the last update at the
> alarm_console i get an error:
>=20
> You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '+0 AS timestamp, inet_ntoa(src_ip), inet_nto
>=20
> I get ride of it changing a line at classes/Alarm.inc (at least dont
> get the error and see some output), this is a diff output:
>=20
> --- Alarm.inc.orig      2005-09-21 04:18:07.000000000 +0000
> +++ Alarm.inc   2005-09-21 04:18:20.000000000 +0000
> @@ -228,7 +228,7 @@
>          /* number of alerts per page */
>          $nalerts =3D $sup - $inf;
>=20
> -        $query =3D "SELECT *, timestamp+0 AS timestamp,
> +        $query =3D "SELECT *, timestamp + 0 AS timestamp,
>                    inet_ntoa(src_ip), inet_ntoa(dst_ip)
>              FROM alarm $where $order LIMIT $nalerts OFFSET $inf";
>=20
>=20
> Sorry my poor english. Thanks in advance and continue with your great wor=
k.
>=20
> Sebastian Serrano
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.=20
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Os-sim-devel mailing list
> Os-...@li...
> https://lists.sourceforge.net/lists/listinfo/os-sim-devel