BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: screwy on July 06, 2009, 11:18:33 pm

Title: (closed) rosterupdate fails
Post by: screwy on July 06, 2009, 11:18:33 pm: Hey all!

Rosterupdate fails because the bot tried to add stuff to the database that required unique IDs, but is supplying the same one for every entry.

According to the log, these are the SQL entried:

Code: [Select]
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sylo669', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Apocalypze', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Drkwak', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Pienipupu', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Pulskapupu', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Mundylusius', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Shadowops', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Dirtypickle', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Tinglyma', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Beelzeboob', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Lenridel', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Donkiepunch', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Quantumman', 'Roster-XML', '1246912822', '2', '1') INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Fickitgurl', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Begmefor', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Captaindurrr', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Maotao', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Ecat', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Bennymoowoo', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Lacyqueen', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sirhealaloty', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Timthepinger', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Frynancial', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Urdarnskippy', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Froob1', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Froob2', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Bighairyape', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Hettsbank', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Colkirby', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Gunzblazin', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sillycoon', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Soldiermk1', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Kumdumpster', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Hienztank', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Amarath', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Whofixedwho', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Drhowse', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Krvnik', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Eddysengie', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Wraglexzzor', 'Roster-XML', '1246912822', '2', '1'); INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sillycoone', 'Roster-XML', '1246912822', '2', '1');
As you can see, the char_id is the same for all.

Ideas? :D

-Screwy.
Title: Re: rosterupdate fails
Post by: screwy on July 06, 2009, 11:36:51 pm: I also notices that the whois db has a lot of ID entries with "0". Are those supposed to get update on the next whois? Or so?
Title: Re: rosterupdate fails
Post by: Khalem on July 07, 2009, 12:09:50 am: The rosterupdate issue has never been reported before or seen before, even on 64bit php installs.

Are there any errors in the log aside from the MySQL errors?
Could you give us some more information about your operating enviroment, OS, php version, version of the bot, any modifications done etc.
Title: Re: rosterupdate fails
Post by: screwy on July 11, 2009, 12:02:46 am: Hey,

I tried to replicate the problem for easier debugging, turns out that after I dumped the botname_users and whois tables, restarted the bot, did a rosterupdate, well, everything is fine again.

Sorry I can not give you any further debug information. For now, let's consider this a one-time-hiccup that can not replicated.

If further errors occur I will keep you folks posted.

-Screwy.
Title: Re: (closed) rosterupdate fails
Post by: screwy on July 25, 2009, 11:48:42 am: This issue actually might be directly connected with the ID colum not large enough.
Title: Re: (closed) rosterupdate fails
Post by: Khalem on July 25, 2009, 12:13:49 pm: Highly doubtful. The issue is the same uid being used for all for some reason, and also notice how the uid used is a mere 10 characters long.