Author Topic: Help with Guild Bot Errors (Read 1953 times)

ghost1607 · « **on:** October 28, 2006, 08:37:10 pm »

I am having ptoblems. I dont know if it is related to V16.4 Anarchy release but new members are not being recognised by the bot.. I have pasted the startup from the bot below. Help please !!!

Connected to MySQL
[2006-10-28 18:27:06] [CORE] [LOAD] Admin.php
[2006-10-28 18:27:06] [CORE] [LOAD] Alts.php
[2006-10-28 18:27:06] [CORE] [LOAD] BotHelp.php
[2006-10-28 18:27:06] [CORE] [LOAD] Online.php
[2006-10-28 18:27:06] [CORE] [LOAD] Que.php
[2006-10-28 18:27:06] [MOD] [LOAD] About.php
[2006-10-28 18:27:06] [MOD] [LOAD] AlienAttack_GUILD.php
[2006-10-28 18:27:06] [MOD] [LOAD] AutoInv.php
[2006-10-28 18:27:06] [MOD] [LOAD] AutoMsg.php
[2006-10-28 18:27:06] [MOD] [LOAD] Bid.php
[2006-10-28 18:27:06] [MOD] [LOAD] Bio.php
[2006-10-28 18:27:06] [MOD] [LOAD] Calc.php
[2006-10-28 18:27:06] [MOD] [LOAD] Callers.php
[2006-10-28 18:27:06] [MOD] [LOAD] Countdown.php
[2006-10-28 18:27:06] [MOD] [LOAD] GuildRelay_GUILD.php
[2006-10-28 18:27:06] [MOD] [LOAD] IRC.php
[2006-10-28 18:27:06] [MOD] [LOAD] Is.php
[2006-10-28 18:27:06] [MOD] [LOAD] Items.php
[2006-10-28 18:27:06] [MOD] [LOAD] Level.php
[2006-10-28 18:27:06] [MOD] [LOAD] Logon_GUILD.php
[2006-10-28 18:27:06] [MOD] [LOAD] MassMsg.php
[2006-10-28 18:27:06] [MOD] [LOAD] News.php
[2006-10-28 18:27:06] [MOD] [LOAD] Oe.php
[2006-10-28 18:27:06] [MOD] [LOAD] Points.php
[2006-10-28 18:27:06] [MOD] [LOAD] PrivGroup.php
[2006-10-28 18:27:06] [MOD] [LOAD] Raffle.php
[2006-10-28 18:27:06] [MOD] [LOAD] RaidTime.php
[2006-10-28 18:27:06] [MOD] [LOAD] Rally.php
[2006-10-28 18:27:06] [MOD] [LOAD] Relay_GUILD.php
[2006-10-28 18:27:06] [MOD] [LOAD] Roll.php
[2006-10-28 18:27:06] [MOD] [LOAD] Roster_GUILD.php
[2006-10-28 18:27:06] [MOD] [LOAD] Server.php
[2006-10-28 18:27:06] [MOD] [LOAD] Shutdown.php
[2006-10-28 18:27:06] [MOD] [LOAD] Target.php
[2006-10-28 18:27:06] [MOD] [LOAD] Time.php
[2006-10-28 18:27:06] [MOD] [LOAD] TowerAttack.php
[2006-10-28 18:27:06] [MOD] [LOAD] Whois.php
[2006-10-28 18:27:06] [LOGIN] [STATUS] Connecting
[2006-10-28 18:27:06] [LOGIN] [STATUS] Authenticating
Using AOKex for login key generation
[2006-10-28 18:27:06] [LOGIN] [STATUS] Logging in
[2006-10-28 18:27:06] [LOGIN] [RESULT] OK
MySQL error (# 0) on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
MySQL error (# 1) on query: SELECT id FROM guests WHERE id =
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 '' at line 1
MySQL error (# 2) on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
MySQL error (# 3) on query: SELECT id FROM guests WHERE id =
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 '' at line 1
MySQL error (# 4) on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
MySQL error (# 5) on query: SELECT id FROM guests WHERE id =
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 '' at line 1
MySQL error (# 6) on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
MySQL error (# 7) on query: SELECT id FROM guests WHERE id =
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 '' at line 1
MySQL error (#

on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
MySQL error (# 9) on query: SELECT id FROM guests WHERE id =
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 '' at line 1
MySQL error (# 10) on query: SELECT nickname FROM members WHERE id =
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 '' at line 1
Threshold of 10 errors in 30 seconds reached. Supressing error output for 30 sec
onds
[2006-10-28 18:27:07] [BUDDY] [LOG] Eginer logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Testman logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Littleengy logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Rikii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Soldiernim logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Mallum logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Metawarior logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Blaberpus logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Mitoension logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Rambo09 logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Jamesbond24 logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Davino logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Docsii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Huxley1 logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Bigtank logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Niszczyciel logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Vampnight logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Bondiisam logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Kittensam logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Fredii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Krilii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Sainttakeshi logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Huskysam logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Samstardust logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Atomicsam logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Blaggy logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Bondii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Puppetmiss logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Youaresodead logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Raysii logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Mitchrin logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Zyprex logged [off]
[2006-10-28 18:27:07] [BUDDY] [LOG] Nanoman7 logged [on] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Iceckate logged [off] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Tabbykittan logged [off] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Nanoman4 logged [off] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Christiana19 logged [off] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Eagent logged [on] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Purpleagent logged [off] (not member)
[2006-10-28 18:27:07] [BUDDY] [LOG] Zezzu logged [off] (not member)
[2006-10-28 18:27:37] [ROSTER] [UPDATE] Starting roster update
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [ADD]
[2006-10-28 18:27:39] [BUDDY] [DEL] Zezzu
[2006-10-28 18:27:39] [BUDDY] [DEL] Purpleagent
[2006-10-28 18:27:39] [BUDDY] [DEL] Eagent
[2006-10-28 18:27:39] [BUDDY] [DEL] Christiana19
[2006-10-28 18:27:39] [BUDDY] [DEL] Nanoman4
[2006-10-28 18:27:39] [BUDDY] [DEL] Tabbykittan
[2006-10-28 18:27:39] [BUDDY] [DEL] Iceckate
[2006-10-28 18:27:39] [BUDDY] [DEL] Nanoman7
MySQL error (# 0) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Nanoman7', '',
'', '2',
'Veteran', '12',
'Nano-Technician', 'Male',
'Nano', 'http://www.anarchy-online.com/character/p
hotos/40186.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 1) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Toxicduckii', '',
'', '2',
'Veteran', '9',
'Doctor', 'Female',
'Solitus', 'http://www.anarchy-online.com/characte
r/photos/223859.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 2) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Nanoman4', '',
'', '2',
'Veteran', '13',
'Nano-Technician', 'Neuter',
'Atrox', 'http://www.anarchy-online.com/character/
photos/40111.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 3) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Christiana19', '',
'', '3',
'Member', '12',
'Adventurer', 'Female',
'Solitus', 'http://www.anarchy-online.com/characte
r/photos/40650.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 4) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Purpleagent', '',
'', '3',
'Member', '34',
'Agent', 'Male',
'Opifex', 'http://www.anarchy-online.com/character
/photos/40250.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 5) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Iceckate', '',
'', '4',
'Applicant', '15',
'Soldier', 'Neuter',
'Atrox', 'http://www.anarchy-online.com/character/
photos/40119.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 6) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Tabbykittan', '',
'', '4',
'Applicant', '17',
'Fixer', 'Female',
'Solitus', 'http://www.anarchy-online.com/characte
r/photos/40663.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (# 7) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Eagent', '',
'', '4',
'Applicant', '20',
'Agent', 'Male',
'Opifex', 'http://www.anarchy-online.com/character
/photos/40250.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
MySQL error (#

on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, lvlrange)
VALUES ('',
'Zezzu', '',
'', '4',
'Applicant', '17',
'Soldier', 'Neuter',
'Atrox', 'http://www.anarchy-online.com/character/
photos/40100.jpg',
'1-99')
Out of range value adjusted for column 'id' at row 1
[2006-10-28 18:27:40] [ROSTER] [UPDATE] Roster update complete.
Added 9 members, removed 8.
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:40] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:41] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:41] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:27:41] [BUDDY] [LOG] logged [off] (not member)
[2006-10-28 18:28:18] [GROUP] [MSG] [Purple Haze] Nanoman7: !level 36
[2006-10-28 18:28:18] [GROUP] [MSG] [Purple Haze] Purplebot: L 36: team 27-4
9 | PvP 28-46 | 45100 XP | missions 25, 27, 28, 30, 32, 36, 39, 43, 46, 54
, 64