Author Topic: Bot not responding (Read 1932 times)

Landcast · « **on:** October 31, 2006, 12:43:50 am »

Hey guys.

im running bebot 2.9

Followed the instructions that i found on this forum.

When i start up with php start.php the bot starts and the mod's load. When it gets to the end i get the following :

Quote

[2006-10-30 23:42:00] [LOGIN] [STATUS] Connecting
[2006-10-30 23:42:00] [LOGIN] [STATUS] Authenticating
Using AOKex for login key generation
[2006-10-30 23:42:01] [LOGIN] [STATUS] Logging in
[2006-10-30 23:42:01] [LOGIN] [RESULT] OK
MySQL error (# 0) on query: SELECT nickname FROM members WHERE id =
You have an error in your SQL syntax; check the manual that correspo
MySQL server version for the right syntax to use near '' at line 1
[2006-10-30 23:42:01] [BUDDY] [LOG] Landcast logged [on]
[2006-10-30 23:42:01] [BUDDY] [LOG] Nanolaskey logged [off] (not
MySQL error (# 1) on query: SELECT nickname FROM members WHERE id =
You have an error in your SQL syntax; check the manual that correspo
MySQL server version for the right syntax to use near '' at line 1
MySQL error (# 2) on query: SELECT nickname FROM members WHERE id =
You have an error in your SQL syntax; check the manual that correspo
MySQL server version for the right syntax to use near '' at line 1

I did not get any errors when i set up my mysql from the glarawyn post ( noob mysql post )

The bot loads and i can join the chat but the bot dosnt respond..

hope someone can help
/LC

Landcast · « **Reply #1 on:** October 31, 2006, 03:00:27 pm »

installed the database stuff again and now i got the bot to respond when i do commands in tells.

how do i get it to do the output in the raid channel ?

and i still have the same errors as i did before.

jjones666 · « **Reply #2 on:** October 31, 2006, 03:13:32 pm »

Each module has its own output defined, some are configured so that you can use in GC only, some in raid channel only. The advantage of bebot is that it is fairly easy to customise each module as you need (examine how they are set up and it should make sense).

I had same issue as you mentioned with members on a new toon that had been created. You would be required to download Nesi's modified AOCHAT.php, replace current file. Then I had to convert the ID field to be of type VARCHAR(11) instead of INTEGER. It is not yet known, what, if anything, this fix will break (I personally didn't see anything yet).

http://bebot.link/index.php/topic,531.msg3581/topicseen.html#new

As this fix isn't official approved by Khalem and you aren't comfortable to hack things yourself, it may be easier to wait for official fix when Khalem has time to check.

Cheers,

-jj-