collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot  (Read 2253 times)

0 Members and 1 Guest are viewing this topic.

Offline MiCR0

  • BeBot Rookie
  • *
  • Posts: 18
  • Karma: +0/-0
[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...

Offline MiCR0

  • BeBot Rookie
  • *
  • Posts: 18
  • Karma: +0/-0
Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
« Reply #1 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?

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
« Reply #2 on: August 07, 2006, 10:34:36 am »
Bigmicro I assume?

Which version of Bebot are you using?

-jj-

Offline MiCR0

  • BeBot Rookie
  • *
  • Posts: 18
  • Karma: +0/-0
Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
« Reply #3 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
« Last Edit: August 07, 2006, 11:55:48 am by MiCR0 »

Offline MiCR0

  • BeBot Rookie
  • *
  • Posts: 18
  • Karma: +0/-0
Re: MySql syntax Error on MySQL Server 5.0 with adding admins to the bot
« Reply #4 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
« Last Edit: August 08, 2006, 09:01:05 pm by MiCR0 »

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 447
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal