BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: MiCR0 on August 06, 2006, 11:21:47 pm

Title: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
Post by: MiCR0 on August 06, 2006, 11:21:47 pm

[2006-08-06 20:40:48] [TELL] [INC] name: !admin add Admin Aname
MySQL error (# 0) on query: SELECT name FROM admin_members WHERE name = 'Aname' AND admin_group = 2
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 ''Aname AND admin_group = 2' at line 1

Am useing MySQL Server 5.0 it does work so not sure what going on here...

Title: Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
Post by: MiCR0 on August 07, 2006, 10:22:02 am

Warning: socket_read(): unable to read from socket

: An existing connection w

as forcibly closed by the remote host.
in C:\Server\BeBot_v0.2.6\AOChat.php on line 222

Read error: An existing connection was forcibly closed by the remote host.

[2006-08-07 00:42:26] [CONN] [ERROR] Bot has disconnected. Reconnecting in 60
seconds.
The bot is restarting.

C:\Server\BeBot_v0.2.6>pause
Press any key to continue . . .

left the bot online over night and this happand?

Title: Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
Post by: jjones666 on August 07, 2006, 10:34:36 am

Bigmicro I assume?

Which version of Bebot are you using?

-jj-

Title: Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
Post by: MiCR0 on August 07, 2006, 10:56:29 am

BeBot_v0.2.6 but i get this on the BeBot_v0.2.5 as well

And how did u know it was me :P

if(($tmp = socket_read($this->socket, $rlen)) === false) Line 222

going to install a new php give that a try

Title: Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
Post by: MiCR0 on August 08, 2006, 07:27:06 pm

fixed it i think not crashing any more i download a new php pack and working ok now