Author Topic: Tower probelm (Read 3903 times)

Trancillion · « **on:** September 23, 2007, 12:50:39 am »

Noctrish [2007-09-22 22:40:18] [GROUP] [MSG] [All Towers] 0: The Clan organiz
ation Valheru Ascendants (AoF) just entered a state of war! Henke203 attacked th
e Neutral organization Wolf Brigade's tower in Broken Shores at location (249, 2
343).
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, firstname, lastname
, level, gender, breed, faction, profession, defender_rank, defender_rank_id, or
g_id, org_name, org_rank, org_rank_id, pictureurl, updated) VALUES ('-1831044901
', 'Henke203', 'Milan', 'Godfray', '98', 'Neuter', 'Atrox', 'Clan', 'Enforcer',
'', '5', '0', 'Valheru Ascendants (AoF)', 'Applicant', '6', 'http://www.anarchy-
online.com/character/photos/40121.jpg','1190500819') ON DUPLICATE KEY UPDATE id
= VALUES(id), firstname = VALUES(firstname), lastname = VALUES(lastname), level
= VALUES(level), gender = VALUES(gender), breed = VALUES(breed), faction = VALUE
S(faction), profession = VALUES(profession), defender_rank = VALUES(defender_ran
k),defender_rank_id = VALUES(defender_rank_id), pictureurl = VALUES(pictureurl),
updated = VALUES(updated), org_id = VALUES(org_id), org_name = VALUES(org_name)
, org_rank = VALUES(org_rank), org_rank_id = VALUES(org_rank_id)
Data truncated for column 'defender_rank' at row 1
Noctrish [2007-09-22 22:40:19] [GROUP] [MSG] [Nocturnal Fear] Noctrish: Valhe
ru Ascendants (AoF) (Clan) has attacked Wolf Brigade (Neutral) in Broken Shores
at 249x2343. Attacker: Henke203 (LvL 98 Enforcer)

this is what i get each time there is an tower attack, and it seems to slow the bot down by alot :s
This is the version 0.4.1

I also had problem getting !calc to work *temperary just copied the old one from 0.4.0 and it worked fine then* Also just to mention, i get "Roster update failed! Funcom XML returned 0 members ::: System ready" at the startup.

Hope someone may know something about it

PHP: 5.2.3
MySQL: 5.2.3

If anny missing info, ask and i'll give.

Blueeagle · « **Reply #1 on:** September 23, 2007, 03:14:26 am »

TowerAttack.php does not contain code that accesses the indicated table (whois). However it does contain one call to whois -> lookup() which is a part of Sources/Bot.php.

Also the whois table has been changed since 0.2.x so you need to update the table structure. To do this you can run the update script in the Extras folder or you can simply drop the table named whois.

Then again, if it's a broken whois table then you should recieve such errors on all players that does not already exist in the whois cache. To detect if this is the case try a !whois command on someone the bot doesn't know already and see if that gives the same error.

As for the roster update failing we've had some trouble with that, however it's fixed in the lastest 0.4.1 release. You may want to try to re-download it from http://bebot.link/index.php?action=tpmod;dl

I hope that helps.

-Blueeagl3

Edit: 0.4.1, not 4.0.1

Trancillion · « **Reply #2 on:** September 23, 2007, 12:37:25 pm »

exept from the SQL db the bot was downloaded clean for about 4 days ago :s

If any changes since then please let me know.

Blueeagle · « **Reply #3 on:** September 24, 2007, 01:27:13 am »

I assume you read http://svn.shadow-realm.org/index.py/BeBot/trunk/extra/whois-update/README.txt?view=markup

Alreadythere · « **Reply #4 on:** September 24, 2007, 09:11:31 pm »

Grab the files from here, that should help you I think.

Trancillion · « **Reply #5 on:** September 25, 2007, 08:13:59 am »

I reinstalled sql and found the problem, the new bot didn't like any space in the path, i had my mysql on "c:\Program Filer\My SQLserver 5.2......" For some reason it couldn't create new files, neither edit them. It kinda fixed all my probs except the Rooster update. Though i can see there has come a fix for that as well now

Thanks for the help all

Addon:

Was old updates but still worked:o either i didn't see that they came after 0.4.1, else they weren't updated into the bot? Anyway, it fixed the rooster prolem.