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: Bot errors  (Read 2715 times)

0 Members and 1 Guest are viewing this topic.

Offline Chaosix

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Bot errors
« on: July 26, 2007, 10:08:48 pm »
Ok. My org name has a ' in it. So i get a syntax error.
Here it is.

MySQL error: (0) on query: SELECT DISTINCT org_rank_id, org_rank FROM whois WHERE org_name = 'Rock N' Roll' ORDER BY org_rank_id ASC
MySQL server version for the right syntax to use near 'Roll' ORDER BY org_rank_id ASC' at line 1.

??
« Last Edit: July 26, 2007, 10:23:07 pm by Chaosix »
If all else fails, randomly hit it until it works.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: MySQL - Acces denied for user...
« Reply #1 on: July 26, 2007, 10:16:44 pm »
looks like you entered username@localhost as username into MySQL.conf. Just remove @localhost and it should work.

Offline Chaosix

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Bot errors
« Reply #2 on: July 26, 2007, 10:38:22 pm »
Thank you for that  :)
Edited first post to save time. (new problem)
If all else fails, randomly hit it until it works.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Bot errors
« Reply #3 on: July 26, 2007, 10:56:53 pm »
The org name is missing proper escaping in that instance, r820 in SVN should fix this error.

Offline Chaosix

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Bot errors
« Reply #4 on: July 27, 2007, 09:49:05 am »
So i download it into the Bebot directory? Im sorry i don't understand what to do with it.

EDIT: Tried putting it into Bebot directory. Still same result.
« Last Edit: July 27, 2007, 09:54:09 am by Chaosix »
If all else fails, randomly hit it until it works.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Bot errors
« Reply #5 on: July 27, 2007, 02:02:11 pm »
but in your bebot Directory /core/

Offline Chaosix

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Bot errors
« Reply #6 on: July 27, 2007, 03:22:52 pm »
Ah yes :-) sorted it thanks. Now,

fsockopen (): Unable to connect to items.vhabot.net:80
blah blah
In C:\bebot_v0.4.0\sources\bot.php on line 1075.

I think i just need a new site to connect to?
If all else fails, randomly hit it until it works.

Offline Vhab

  • Contributor
  • *******
  • Posts: 180
  • Karma: +0/-0
    • VhaBot Forum
Re: Bot errors
« Reply #7 on: July 27, 2007, 10:27:46 pm »
Nope, was having some really nasty problems with the server today.
Should be all fixed now, but it caused the central db to be down for a few hours.

 

* 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: 631
  • 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