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 jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users