Archive > BeBot Hyborian support

AoC bot issue

(1/2) > >>

meatshield:
I know it? an alpha, but i figured i post the error message I got. I running this on both Vista 64bit and WMWare Player--Ubuntu.

Guildadmin [BUDDY]   [LOG]   Satch logged [on] (MEMBER)
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('67178806', 'Satch', '44', 'Assassin', '', '', 1154213, 1, '1214974967') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  updated = VALUES(updated)
Unknown column 'class' in 'field list'
Guildadmin [GETUID]   [FAILED]   I was unable to get the user id for user:
Guildadmin [Whois]   [Update]    had an invalid user ID! UID:
Guildadmin [GETUID]   [FAILED]   I was unable to get the user id for user:
Guildadmin [GROUP]   [MSG]   [~Guild] Guildadmin: "Satch" (Lvl  ) Logged On :: [link]Details[/link]
Guildadmin [PGRP]   [MSG]   [Guildadmin] Guildadmin: "Satch" (Lvl  ) Logged On :: [link]Details[/link]

I was using a different bot that had a lot of these commands working. Of course it wasnt using mySQL like this one. Since this is the only chatbot for AoC that I found that? using ´sql, i going to put my all into it. 

Thanks for providing the app for us.

Noer:
Hrm that error looks a bit strange. Are you running this on top of an old Bebot install? If that is the case the table structure is not compatible and you need to start from scratch.

meatshield:
I actually deleted all the files out of the bebot folder and installed the new files in there.  I also using the Bebot Hyborian that was posted on the funcom EU server.

To answer the question -- It was installed ontop of the old bebop... but not really. Since everything was deleted.

meatshield:
ok... answer this.  I noticed that it had a mySQL error in there...  if Im using the same database ... could that be the issue?

I gonna test that theory out.

Yup... Im a mySQL and just plain old php aoc chatbot newb.  Id get list in a pile of my own dirty stuff.  So I removed the database and rebuilt it. Works great!   

Heres my update to the issues I noticed:
When you click on the nice little script that is called !whois name -- it provides a link for ¨Details¨. When you select this theres an option to add buddy. When I click this it sends me a tell from the bot saying cc addbuddy ¨name¨.

Another issue is the !online :: This is what I get (only two members online)
<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>
 - Lvl 44 Bohica

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>
 - Lvl 69 Dalri

Yay, Ive got another potential issue or question :)

When I do !buddylist I get (below).  Is that how its supposed to look or should I be getting information? 
Bohica (ID: 67122783)
Dalri (ID: 6726747)

When I type !member I get the member count page It shows 2 buddylist count.  Below that the classes are listed and they all have 0s. Since i deleted the bebot database and restarted everything I should be fine. I really hope I dont have to delete any old files :)

There are some more questions and issues, but I think this is long enough. I know it? in alpha and I dont want to seem like an SoB. I ReALLY REALLY enjoy it and ive spent hours just learning linux so I can run this stuff better. 

Thanks again!

Noer:
You need a fresh install for Bebot Hyborian. That means - no old files and no old mysql stuff. Start from scratch.

Navigation

[0] Message Index

[#] Next page