Author Topic: roster update over and over again (Read 6628 times)

Neznanec · « **on:** July 07, 2011, 01:06:02 pm »

Hi guys!
I was running bot for few months already with no problems at all but now all the sudden something somehow went wrong probably because of my computer crash while bot running. That is a part of some errors.
^{Vbot [SETTINGS] [LOAD] Loaded settings from database.
MySQL ERROR(# 4) on query: SELECT id, name FROM vbot_timer WHERE channel = 'inte
rnal' AND owner = 'IRC'
Table '.\vengeancebot\vbot_timer' is marked as crashed and should be repairedMyS
QL ERROR(# 5) on query: INSERT INTO vbot_timer (name, timerclass, endtime, owner
, channel, repeatinterval) VALUES ('IRC-Connect', 17, 1310036225, 'IRC', 'intern
al', 0)
Table '.\vengeancebot\vbot_timer' is marked as crashed and should be repairedMyS
QL ERROR(# 6) on query: SELECT COUNT(endtime), MIN(endtime) FROM (SELECT endtime
FROM vbot_timer WHERE timerclass = -1 UNION SELECT endtime - notify_delay AS en
dtime FROM vbot_timer AS t1, timer_class_entries AS t2 WHERE t1.timerclass <> -1
AND t1.timerclass = t2.id) AS endtime_temp_table
Table '.\vengeancebot\vbot_timer' is marked as crashed and should be repairedVbo
t [CORE] [INC_GANNOUNCE] Detected org name as: Vengeance}

Now I wonder if that is something that is making my bot start over and over again about 4 mins loop time its updating roster all the time and not recognizing some names... and so on kinda wierd since I havent change anything around.

kenny · « **Reply #1 on:** July 07, 2011, 05:41:49 pm »

Quote

Table '.\vengeancebot\vbot_timer' is marked as crashed and should be repaired

You should be able to repair or reset this table via phpMyAdmin.

Neznanec · « **Reply #2 on:** July 07, 2011, 08:19:16 pm »

can u be more specific how to do that a little guide. I would realy appriciate it.

And 1 more thing only the org bot seems to be damaged the raid bot which we have is working normaly.

Shelly · « **Reply #3 on:** July 08, 2011, 01:49:32 am »

From the errors you posted it looks like the computer crash corrupted your mysql database for the bot. You need to fix that and your bot should stabilize. At a worst case you may need to use a different database (in your MySql.conf file) and reconfigure your bot back.

WARNING: doing this means you are essentially starting over from scratch... all guests will need to be re-added and such.

Shelly

Neznanec · « **Reply #4 on:** July 08, 2011, 11:35:12 am »

well with my low lvl of sql and php knowledge I was able to find this in the database but now I dont know how to fix that.

Can any1 help me? Thx The problem is described in first post.

uberjon · « **Reply #5 on:** July 08, 2011, 02:39:05 pm »

click the link that says database: vengencebot then scroll down, checkmark the vbot_timer box, and scroll down further with selected: repair table

Neznanec · « **Reply #6 on:** July 09, 2011, 11:17:53 pm »

Tywm for help uberjon I was able to fix that but it seems like it wasnt the main problem! Bot is still reconnecting and cant stay online. There is possible to do every function in it but there is spam all the time about slaves loging on/off...

Problem:
^{Vbot [GROUP] [MSG] [Vengeance] Vbot: Roster update completed. ::: Added 286
members
Vbot [BUDDY] [LOG] Vbot2 logged [off] (MEMBER)
Vbot [ERROR] [raidloot] Undefined function buddy(Vbot2, 0)!

Warning: socket_read(): unable to read from socket : An existing connection w

as forcibly closed by the remote host.
in C:\Program Files\Vbot\Sources\AOChat.php on line 311
Read error: An existing connection was forcibly closed by the remote host.

Vbot2 [CONN] [ERROR] Slave has disconnected. Reconnecting...
Vbot2 [LOGIN] [STATUS] Connecting to server chat.d1.funcom.com:7101
Vbot2 [LOGIN] [STATUS] Authenticating vengbot
buddy add bot = 1

Warning: socket_write(): unable to write to socket : An established connectio

n was aborted by the software in your host machine.
in C:\Program Files\Vbot\Sources\AOChat.php on line 494
Vbot [BUDDY QUEUE] [BUDDY-ADD] Satanenfgirl
buddy add bot = 1

Warning: socket_write(): unable to write to socket : An established connectio

n was aborted by the software in your host machine.
in C:\Program Files\Vbot\Sources\AOChat.php on line 494
Vbot [BUDDY QUEUE] [BUDDY-ADD] Septobermp
Vbot2 [LOGIN] [STATUS] Logging in Vbot2
Vbot2 [LOGIN] [RESULT] OK
Vbot [GROUP] [MSG] [Vengeance] Vbot: Vbot2 logged off
Vbot [PGRP] [MSG] [Vbot] Vbot: Vbot2 logged off
Vbot [BUDDY] [LOG] Warbear logged [off] (ADMIN)
Vbot [ERROR] [raidloot] Undefined function buddy(Warbear, 0)!
Vbot [BUDDY] [LOG] Vbot2 logged [on] (MEMBER)
Vbot [ERROR] [raidloot] Undefined function buddy(Vbot2, 1)!

Warning: socket_read(): unable to read from socket : An established connectio

n was aborted by the software in your host machine.
in C:\Program Files\Vbot\Sources\AOChat.php on line 311
Read error: An established connection was aborted by the software in your host m
achine.

Vbot1 [CONN] [ERROR] Slave has disconnected. Reconnecting...
Vbot1 [LOGIN] [STATUS] Connecting to server chat.d1.funcom.com:7101
Vbot1 [LOGIN] [STATUS] Authenticating vengbot
buddy add bot = 1
Vbot [BUDDY QUEUE] [BUDDY-ADD] Vierna
buddy add bot = 1
Vbot [BUDDY QUEUE] [BUDDY-ADD] Senca
Vbot1 [LOGIN] [STATUS] Logging in Vbot1
Read error: EOF
Vbot [GROUP] [MSG] [Vengeance] Vbot: Warbear logged off
Vbot [PGRP] [MSG] [Vbot] Vbot: Warbear logged off
Vbot [GROUP] [MSG] [Vengeance] Vbot: "Vbot2" (Lvl 1/0 Clan Fixer, Member of
Vengeance) Logged On :: [link]Details[/link]
Vbot [PGRP] [MSG] [Vbot] Vbot: "Vbot2" (Lvl 1/0 Clan Fixer, Member of Veng
eance) Logged On :: [link]Details[/link]
Vbot2 [BUDDY] [ERROR] Hellodoc logged on despite of already being marked as lo
gged on!!
Read error: EOF
Vbot1 [CONN] [ERROR] Slave has disconnected. Reconnecting...
Vbot1 [LOGIN] [STATUS] Connecting to server chat.d1.funcom.com:7101
buddy add bot = 1
Vbot [BUDDY QUEUE] [BUDDY-ADD] Invictum
Vbot1 [LOGIN] [STATUS] Authenticating vengbot
Read error: EOF
AOChat:

===================================================

_/_/_/ _/_/_/ _/

_/ _/ _/_/ _/ _/ _/_/ _/_/_/_/

_/_/_/ _/_/_/_/ _/_/_/ _/ _/ _/

_/ _/ _/ _/ _/ _/ _/ _/

_/_/_/ _/_/_/ _/_/_/ _/_/ _/_/

An Anarchy Online Chat Automaton

And

An Age of Conan Chat Automaton

v.0.6.8 - PHP 5.3.0

OS: Windows_NT

Your operating system is detected as 32bit

===================================================}

And before all that when the roster update start there are some errors as well but probably not so crucial as

^{Vbot [ERROR] [AOChatWrapper_Core] I was unable to get the user id for user
: 'Unclesquee-1'} Some of this -number name users but ptobably aint important and then there is this

^{Warning: socket_write(): unable to write to socket : An existing connection was forcibly closed by the remote host.

in C:\Program Files\Vbot\Sources\AOChat.php on line 494
Vbot [BUDDY QUEUE] [BUDDY-ADD] Dokottet
buddy add bot = 1}
for many members and I checked that line but I have no idea what if anything to change there to make it work.

A lot of things yea sorry guys

but if any1 can help please do and ask away if u need more info. TY

Shelly · « **Reply #7 on:** July 10, 2011, 03:44:02 am »

Quote from: Neznanec on July 09, 2011, 11:17:53 pm

Vbot2 [CONN] [ERROR] Slave has disconnected. Reconnecting...
Vbot2 [LOGIN] [STATUS] Connecting to server chat.d1.funcom.com:7101

Ok so you are logging into RK1? Maybe check that you don't have an out-going connection being blocked by your firewall (either local or remote) ...

Shelly

Neznanec · « **Reply #8 on:** July 10, 2011, 11:39:33 am »

Thx Shelly I have changed the port on my router and for now it seems like its working. Will let u guys know if anything else happens

and u are all great!!!

PolarTiger · « **Reply #9 on:** August 15, 2011, 11:26:35 pm »

Hey all,

I have the same problem.

I'm running MS Windows XP Professional SP3 on a physical machine

I downloaded the bot today (0.6.

Downloaded PHP (5.3.6) and MySQL (5.5) installers copied files and created database as instructed but I keep getting an EOF error during roster update (at random positions/times)

I already disabled the firewall and comp is now fully open to the internet.

I tried to find a solution on the forums but didnt find a single one.

I also made sure my dimension was marked as 2 instead of Rimor

The console doesn;t show anything else than Read Error (EOF)

See below the console output when i run debugstartbot.bat

Code: [Select]


===================================================

    _/_/_/              _/_/_/                _/

   _/    _/    _/_/    _/    _/    _/_/    _/_/_/_/

  _/_/_/    _/_/_/_/  _/_/_/    _/    _/    _/

 _/    _/  _/        _/    _/  _/    _/    _/

_/_/_/      _/_/_/  _/_/_/      _/_/        _/_/

         An Anarchy Online Chat Automaton

                     And

          An Age of Conan Chat Automaton

         v.0.6.8 - PHP 5.3.6

                 OS: Windows_NT

        Your operating system is detected as 32bit

===================================================

Curl extension loaded
MySQL database connection test successfull
Creating MySQL class!
Creating AOChat class!
Creating main Bot class!
Steadybot [MAIN]        [DIR]   Loading main functions of the bot
Steadybot [MAIN]        [LOAD]  00_BotError.php
Steadybot [MAIN]        [LOAD]  01_BasePassiveModule.php
Steadybot [MAIN]        [LOAD]  02_BaseActiveModule.php
Steadybot [MAIN]        [LOAD]  03_Security.php
Steadybot [MAIN]        [LOAD]  05_Maintenance.php
Steadybot [MAIN]        [LOAD]  06_Preferences.php
Steadybot [SETTINGS]    [LOAD]  Loaded settings from database.
Steadybot [MAIN]        [LOAD]  06_Settings.php
Steadybot [MAIN]        [LOAD]  09_AccessControl.php
Steadybot [MAIN]        [LOAD]  10_Roster.php
Steadybot [MAIN]        [LOAD]  11_FlexibleSecurity.php
Steadybot [MAIN]        [LOAD]  12_ConfigMagik.php
Steadybot [MAIN]        [LOAD]  14_Queue.php
Steadybot [MAIN]        [LOAD]  14_Tools.php
Steadybot [MAIN]        [LOAD]  15_AOChatWrapper.php
Steadybot [MAIN]        [LOAD]  15_BotHelp.php
Steadybot [MAIN]        [LOAD]  15_ChatQueue.php
Steadybot [MAIN]        [LOAD]  15_Colors.php
Steadybot [MAIN]        [LOAD]  15_CommandAlias.php
Steadybot [MAIN]        [LOAD]  15_Log.php
Steadybot [MAIN]        [LOAD]  15_Notify.php
Steadybot [MAIN]        [LOAD]  15_OnlineDB.php
Steadybot [MAIN]        [LOAD]  15_Timer_Core.php

Steadybot [CORE]        [DIR]   Loading core-modules
Steadybot [CORE]        [LOAD]  Alias.php
Steadybot [CORE]        [LOAD]  Alts.php
Steadybot [CORE]        [LOAD]  BotStatistics.php
Steadybot [CORE]        [LOAD]  Buddy_Queue.php
Steadybot [CORE]        [LOAD]  FunFilters.php
Steadybot [CORE]        [LOAD]  Logon_Notifies.php
Steadybot [CORE]        [LOAD]  ModuleCatcher.php
Steadybot [CORE]        [LOAD]  PlayerNotes.php
Steadybot [CORE]        [LOAD]  Professions.php
Steadybot [CORE]        [LOAD]  ShortCuts.php
Steadybot [CORE]        [LOAD]  Statistics.php
Steadybot [CORE]        [LOAD]  StringFilter.php
Steadybot [CORE]        [LOAD]  Time.php
Steadybot [CORE]        [LOAD]  User.php

Steadybot [CORE]        [DIR]   Loading Game Specific core-modules
Steadybot [CORE]        [LOAD]  Whois.php

Steadybot [CORE-CUSTOM] [DIR]   Loading additional core-modules in directory cus
tom/core/

Steadybot [MOD] [DIR]   Loading modules
Steadybot [MOD] [LOAD]  About.php
Steadybot [MOD] [LOAD]  AccessControlUI.php
Steadybot [MOD] [LOAD]  AdminsUI.php
Steadybot [MOD] [LOAD]  AFK.php
Steadybot [MOD] [LOAD]  AltsUI.php
Steadybot [MOD] [LOAD]  BanManagerUI.php
Steadybot [MOD] [LOAD]  Bid.php
Steadybot [MOD] [LOAD]  BotStatisticsUI.php
Steadybot [MOD] [LOAD]  Calc.php
Steadybot [MOD] [LOAD]  ColorConfigUI.php
Steadybot [MOD] [LOAD]  CommandAliasUI.php
Steadybot [MOD] [LOAD]  Countdown.php
Steadybot [MOD] [LOAD]  FlexibleSecurityUI.php

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\modules\IRC.php on line 682

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\SmartIRC.php on line 1158

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\SmartIRC.php on line 1184

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\SmartIRC.php on line 1219

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\SmartIRC.php on line 1321

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\SmartIRC.php on line 1595

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\IRC\messagehandler.php on line 49

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\IRC\messagehandler.php on line 60

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\IRC\messagehandler.php on line 318

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\Sources\IRC\messagehandler.php on line 366
Steadybot [SETTINGS]    [SAVED] connected for module irc set to FALSE as datatyp
e bool
Steadybot [MOD] [LOAD]  IRC.php
Steadybot [MOD] [LOAD]  Is.php
Steadybot [MOD] [LOAD]  Logon.php
Steadybot [MOD] [LOAD]  Mail.php
Steadybot [MOD] [LOAD]  MassMsg.php
Steadybot [MOD] [LOAD]  ModulesControlUI.php
Steadybot [MOD] [LOAD]  News.php
Steadybot [MOD] [LOAD]  Notify.php
Steadybot [MOD] [LOAD]  nroll.php
Steadybot [MOD] [LOAD]  OnlineCount.php
Steadybot [MOD] [LOAD]  OnlineDisplay.php
Steadybot [MOD] [LOAD]  Ping.php
Steadybot [MOD] [LOAD]  PlayerNotesUI.php
Steadybot [MOD] [LOAD]  Points.php
Steadybot [MOD] [LOAD]  PreferencesUI.php
Steadybot [MOD] [LOAD]  Raffle.php
Steadybot [MOD] [LOAD]  Raid.php
Steadybot [MOD] [LOAD]  Rally.php
Steadybot [MOD] [LOAD]  Relay.php
Steadybot [MOD] [LOAD]  Roll.php
Steadybot [MOD] [LOAD]  Roster.php
Steadybot [MOD] [LOAD]  Say.php
Steadybot [MOD] [LOAD]  SettingsUI.php
Steadybot [MOD] [LOAD]  ShortCutsUI.php
Steadybot [MOD] [LOAD]  Shutdown.php
Steadybot [MOD] [LOAD]  StringFilterUI.php
Steadybot [MOD] [LOAD]  TimerRelay.php
Steadybot [MOD] [LOAD]  TimerUI.php
Steadybot [MOD] [LOAD]  Whois.php

Steadybot [MOD] [DIR]   Loading game specific modules
Steadybot [MOD] [LOAD]  AlienAttack.php
Steadybot [MOD] [LOAD]  AutoInv.php
Steadybot [MOD] [LOAD]  Callers.php
Steadybot [MOD] [LOAD]  Glyph.php
Steadybot [MOD] [LOAD]  History.php
Steadybot [MOD] [LOAD]  Identify.php
Steadybot [MOD] [LOAD]  Items.php
Steadybot [MOD] [LOAD]  LandControlZones.php
Steadybot [MOD] [LOAD]  LeadEcho.php
Steadybot [MOD] [LOAD]  Level.php
Steadybot [MOD] [LOAD]  Loot.php
Steadybot [MOD] [LOAD]  Oe.php
Steadybot [MOD] [LOAD]  Orbital.php
Steadybot [MOD] [LOAD]  PB.php
Steadybot [MOD] [LOAD]  PrivGroup.php
Steadybot [MOD] [LOAD]  Server.php
Steadybot [MOD] [LOAD]  Symbiants.php
Steadybot [MOD] [LOAD]  Target.php

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\modules\ao\Teams.php on line 231

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\modules\ao\Teams.php on line 287

Deprecated: Assigning the return value of new by reference is deprecated in C:\b
ebot\modules\ao\Teams.php on line 288
Steadybot [MOD] [LOAD]  Teams.php
Steadybot [MOD] [LOAD]  Tier2.php
 Steadybot [MOD]        [LOAD]  Tokens.php
Steadybot [MOD] [LOAD]  TowerAttack.php
Steadybot [MOD] [LOAD]  Trickle.php

Steadybot [MOD-CUSTOM]  [DIR]   Loading additional modules in directory custom/m
odules/


Steadybot [LOGIN]       [STATUS]        Connecting to ao server chat.d2.funcom.c
om:7102
Steadybot [LOGIN]       [STATUS]        Authenticating [accountname]
Steadybot [LOGIN]       [STATUS]        Logging in Steadybot
Steadybot [LOGIN]       [RESULT]        OK
Steadybot [SETTINGS]    [LOAD]  Loaded settings from database.
Steadybot [CORE]        [INC_GANNOUNCE] Detected org name as: Steadfast
Steadybot [SETTINGS]    [LOAD]  Loaded settings from database.
Steadybot [ROSTER]      [UPDATE]        Starting roster update for guild id: 809
5749 on RK2
Steadybot [ROSTER]      [UPDATE]        XML for the Clan guild Steadfast obtaine
d
Steadybot [ROSTER]      [UPDATE]        Roster update ran less than 6 hours ago,
 skipping!
Steadybot [VERSION]     [UPDATE]        Initiating version check
Steadybot [VERSION]     [UPDATE]        No new version detected
Steadybot [GROUP]       [MSG]   [Steadfast] Steadybot: Roster update starting ::
: System busy
Steadybot [ROSTER]      [UPDATE]        XML for the Clan guild Steadfast contain
ed 243 member entries
Steadybot [BUDDY]       [BUDDY-ADD]     Fortaxer
Steadybot [BUDDY]       [BUDDY-ADD]     Blutbad
Steadybot [SETTINGS]    [SAVED] LastRosterUpdate for module members set to 13134
46751 as datatype int
Steadybot [ROSTER]      [UPDATE]        Roster update complete.
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Minthe
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Hellchild
Steadybot [GROUP]       [MSG]   [Steadfast] Steadybot: Roster update completed.

Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Buckshotz
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Steady
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Kenaro
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Naraya
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Bonehead
Steadybot [BUDDY QUEUE] [BUDDY-ADD]     Quyan
Read error: EOF
Steadybot [CONN]        [ERROR] Bot has disconnected. Reconnecting in 60 seconds
.

Has anyone else had this problem before?

Thanks

Shelly · « **Reply #10 on:** August 16, 2011, 04:50:51 am »

Hi PolarTiger,

Have a look at this thread... It might be the method of your connects being curl or sockets.

http://bebot.link/ao-0-6-support/roster-update-isint-working/msg15339/#msg15339

Shelly

PolarTiger · « **Reply #11 on:** August 16, 2011, 10:05:55 am »

Hi Shelly,

I have tried to set the timeout to 30 (as someone also did on that threat) and also created a new empty database for the bot to use, however still the same problem.

I'm not that advanced in PHP and MySQL and did everything from the installation guide, so I have no clue what to look for

Shelly · « **Reply #12 on:** August 17, 2011, 04:14:48 am »

PolarTiger,

Out of curiosity... What version of php are you running?

PolarTiger · « **Reply #13 on:** August 17, 2011, 07:59:12 pm »

Quote from: Shelly on August 17, 2011, 04:14:48 am

PolarTiger,

Out of curiosity... What version of php are you running?

PHP 5.3.6 and MySQL 5.5
(The versions currently available on their websites)

PolarTiger · « **Reply #14 on:** August 21, 2011, 12:53:21 pm »

Anyone has a clue?

Author Topic: roster update over and over again (Read 6628 times)

Neznanec

roster update over and over again

kenny

Re: roster update over and over again

Neznanec

Re: roster update over and over again

Shelly

Re: roster update over and over again

Neznanec

Re: roster update over and over again

uberjon

Re: roster update over and over again

Neznanec

Re: roster update over and over again

Shelly

Re: roster update over and over again

Neznanec

Re: roster update over and over again

PolarTiger

Re: roster update over and over again

Shelly

Re: roster update over and over again

PolarTiger

Re: roster update over and over again

Shelly

Re: roster update over and over again

PolarTiger

Re: roster update over and over again

PolarTiger

Re: roster update over and over again