Please fix sql query or scanner for MySQL 5.1
SNT LOG
12:58:58.019: *** Start logging
12:58:58.021: CListenerWin: OK
12:58:58.027: Mysql client: 5.0.45
12:58:58.029: Connecting to Host 127.0.0.1:3306 User root Db lan_search
12:58:58.818: Using charset cp1251
12:58:58.820: >>>> FixErrorServers()
12:58:58.824: 0 servers
12:58:58.829: Servers with wrong update 0
12:58:58.830: <<<< FixErrorServers()
12:59:03.865: !!!!! SQL error: SELECT id,ip,name,type,namespace,login,password,reindex_interval, dirs_index, dirs_banned FROM servers WHERE type>0 AND next_in
12:59:03.865: Error code : 1054
12:59:03.866: Description: Unknown column 'login' in 'field list'
12:59:03.866: ~TableUnlocker(): exception catched (unknown)
12:59:05.767: ~CListenerWin
12:59:05.767: *** Stop logging
MySQL LOG
080426 12:51:58 2 Connect root@localhost on lan_search
2 Init DB lan_search
2 Query SELECT * FROM config WHERE name='lock'
080426 12:51:59 2 Query SET NAMES cp1251
2 Query SELECT namespace,name FROM servers WHERE type<0
2 Query UPDATE servers SET next_index=0 WHERE next_index>(NOW()+INTERVAL 10 DAY)
2 Query SELECT id,ip,type FROM servers WHERE type>0
080426 12:52:01 2 Query UPDATE servers SET lastStateChange=NOW() WHERE id=16451 AND online=1
2 Query UPDATE servers SET online=0 WHERE id=16451
080426 12:52:03 2 Query UPDATE servers SET lastStateChange=NOW() WHERE id=16452 AND online=1
2 Query UPDATE servers SET online=0 WHERE id=16452
080426 12:52:04 2 Query LOCK TABLES servers WRITE
2 Query SELECT id,ip,name,type,namespace,login,password,reindex_interval, dirs_index, dirs_banned FROM servers WHERE type>0 AND next_index<NOW() AND online>0 ORDER BY next_index LIMIT 1
080426 12:52:05 2 Query DELETE FROM config WHERE name='lock'
2 Quit