BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.4 support => Topic started by: Chaosix on July 26, 2007, 10:08:48 pm

Title: Bot errors
Post by: Chaosix 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.

??

Title: Re: MySQL - Acces denied for user...
Post by: Alreadythere 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.

Title: Re: Bot errors
Post by: Chaosix on July 26, 2007, 10:38:22 pm

Thank you for that  :)
Edited first post to save time. (new problem)

Title: Re: Bot errors
Post by: Alreadythere on July 26, 2007, 10:56:53 pm

The org name is missing proper escaping in that instance, r820 in SVN (http://svn.shadow-realm.org/index.py/BeBot/branches/0.4/core/Security.php?revision=820&view=markup) should fix this error.

Title: Re: Bot errors
Post by: Chaosix 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.

Title: Re: Bot errors
Post by: Temar on July 27, 2007, 02:02:11 pm

but in your bebot Directory /core/

Title: Re: Bot errors
Post by: Chaosix 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?

Title: Re: Bot errors
Post by: Vhab 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.