It seems the last slash on HKCU\\Software\ is escaping the ' that ends the field
data.
We should modify the consolidate script to use addslashes before inserting into
MySQL.
Javier
Wim Pouseele wrote:
> Hi,
>
> I got an error with the consolidate scheduled task.
> When running from the command line, I get the error
>
> D:\jffnms\engine>d:\php\php.exe -f d:\jffnms\engine\consolidate.php
>
> 13:41:55 Query Failed - table_insert(events) - insert into events
> (date,type,host,interface,state,username,info,referer) VALUES
> ('2006-12-22 18:32:19','46','15','','1401','','DVSM\\sys_jffnms
> DVSM\\sys_jffnms S-1-5-21-5706737-105989904-332618576-15565 php.exe 1772
> HKCU 0x7ac nmap.exe 1856 HKCU 0x794 HKCU\\Software\','946548'); -
> 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 '946548')'
> at line 113:41:55 New Event (): 2006-12-22 18:32:19 - 46 - 15 - - 1401
> - - DVSM\\sys_jffnms DVSM\\sys_jffnms
> S-1-5-21-5706737-105989904-332618576-15565 php.exe 1772 HKCU 0x7ac
> nmap.exe 1856 HKCU 0x794 HKCU\\Software\ - 946548
>
> I can't see the error in the syntax.
> Am I doing something wrong?
> Using JFFNMS version 0.8.3 on Windows Server 2003 SP1, Apache 2.2, php5
> and mysql 5.0.27
>
> I've checked already my tables and none of them are corrupt.
> Run also a repair on the events database.
>
> Many thanks,
>
> Wim
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> jffnms-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
[EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you
can, please donate at http://jffnms.org/donate
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
