On 7/3/07, Support <[EMAIL PROTECTED]> wrote: > I am running jffnms on a windows 2003 machine. > > It was running pretty well till recently. > > Now I am receiving the underneath error message when logging into the > webinterface. > > How I fix this > > > 15:39:17 db_ping(mysql) Connection to DB Restored... 15:39:18 db_ping(mysql) > Connection to DB Restored... 15:39:19 db_ping(mysql) Connection to DB > Restored... 15:39:20 db_ping(mysql) Connection to DB Restored... 15:39:21 > db_ping(mysql) Connection to DB Restored... 15:39:21 Query Failed - > table_insert(events) - insert into events > (date,type,host,interface,state,username,info) VALUES > ('2007-06-28 > 15:39:16','43','1','Login','successful','admin','from > 201.222.33.92') - Can't open file: 'events.MYI' (errno: 145)15:39:22 > db_ping(mysql) Connection to DB Restored... 15:39:23 db_ping(mysql) > Connection to DB Restored... 15:39:24 db_ping(mysql) Connection to DB > Restored... 15:39:25 db_ping(mysql) Connection to DB Restored... 15:39:26 > db_ping(mysql) Connection to DB Restored... > Warning: join() [function.join]: Bad arguments. in > C:\jffnms\lib\api.events.inc.php on line 246 > Query Failed - events_list() - Can't open file: 'events.MYI' (errno: 145)
It sonds like the table "jffnms.events" is corrupt. Go into mysql: use jffnms; repair table events; done. --falz ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users