Topic: Add User issue (Read 2634 times)

Iheaca · « **on:** September 14, 2008, 03:11:44 PM »

I installed version 5.3 using with Age of Conan.

MySQL 4.1.14 and PHP5

Bot seems to work fine, except addition to the bot_user table. Even manual additions are not stored over time. As a result, the !member and !buddylist are always empty (maybe I am wrong on the dependance).

Any clue on what I could have missed, done wrong with installation to have an issue only with the member addition ? (manual and automatic).

Thanks for help.

Iheaca · « **Reply #1 on:** September 14, 2008, 08:31:51 PM »

MySQL error (# 0) on query:
Scribe [2008-09-15 00:45:27] [TELL] [INC] NAME: !adduser NAME

INSERT INTO scribe_users (char_id, nickname, added_by, added_at, user_level, updated_at)
VALUES (, '', 'NAME', 1221439527, 1, 1221439527)
ON DUPLICATE KEY UPDATE added_by = 'NAME', added_at = 1221439527, user_level=1, updated_at = 1221439527

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 ' '', 'NAME', 1221439527, 1, 1221439527) ON DUPLICATE KEY UPDATE added_by = 'D' at line 1

-----------------

This is an error I have in the log file, scribe_users has no entries.

Iheaca · « **Reply #2 on:** September 15, 2008, 09:59:07 PM »

Nobody has a clue on what the issue could be ?

Nytridr · « **Reply #3 on:** September 16, 2008, 02:24:07 AM »

verify your php and mysql

php --version
mysql --version

and post them here.

Temar · « **Reply #4 on:** September 19, 2008, 07:01:35 AM »

the char_id is missing

Iheaca · « **Reply #5 on:** September 19, 2008, 11:02:02 AM »

Sorry, for delay, was trvalling back from the US to Europe.

MySQL 4.1.14 and PHP 5.2.6

To me it seems the bot maybe does not identify the peoples and can not get infos on them. Would explain why autoadduser does not work, buddylist and members.

Manually set access rights with caracter name work and are correctly attributed.

So was wondering if there are conditions, like minimum level for the bot or I do not what.

Why would "chard_id" be missing ?

Temar · « **Reply #6 on:** September 19, 2008, 03:11:37 PM »

VALUES (, '', 'NAME', 1221439527, 1, 1221439527)

as you cacn see there is nothing before the 1st ,
this means the variable for the char_id is empty when its trying to add
as to why i dont know im just letting you know exactly what the problem is

Iheaca · « **Reply #7 on:** September 20, 2008, 10:31:00 AM »

Thanks, but as I do not really know the Bebot code, I have no idea on why he would not be able to have that piece of data.

Server is Stygia, a french european server. Is that one not supported ?

Iheaca · « **Reply #8 on:** September 23, 2008, 05:18:28 AM »

Does anybody have a clue ?

What piece of information could help to identify the issue ?

Note: Using BeBot v0.5.3 released (development version) downloaded here, not the version found on Google.

Thanks for support.

Iheaca · « **Reply #9 on:** September 23, 2008, 11:38:26 AM »

My issue seems strangely similar to that one:

http://bebot.shadow-realm.org/bebot-0-5-support/add-guild-members/

Please let me know what type of info could help to fix this.

Thanks

Elesar1 · « **Reply #10 on:** September 23, 2008, 02:36:33 PM »

I too am having this issue with the bot I setup for AoC lastnight.

I checked the mySQL database, and it is not entering any information into the users table. When I add a member, (!adduser Elesar member for example) it is added to the security table, but not to the users table.

This is hindering the functionality of the !online and !members commands to always show 0 players.

PHP version 5.2.6
MySQL version 5.0.51b

Elesar1 · « **Reply #11 on:** September 23, 2008, 03:21:12 PM »

I have also noticed that the whois table is empty and never gets written to, the information just gets cached, and when it expires or the bot is reset, it is gone until someone calls for that information again, then they have to issue the command twice, since the first command does not return anything while to bot is gathering information.

I think that there may be an issue with the communication between the core and AoC modules, but I know very very little PHP, so I am hard pressed to see it.

I will keep looking and see if I stumble upon something, but I wouldn't hold my breath if I were you

EDIT:
I have noticed that trying to add a character to the buddylist always results in a response tell of "/tell BotName !help"
No information is passed to the database that I can see.

The whois table is now being populated, though I didn't change anything :\

Elesar1 · « **Reply #12 on:** September 24, 2008, 09:32:53 AM »

Changed to 0.5.2 Hyborian instead of 0.5.3 and it is working perfectly as far as I can tell.

Alreadythere · « **Reply #13 on:** September 24, 2008, 02:02:52 PM »

Finally found time to track this down. Should be fixed in most current version of Security.

The main supported command to add users is !guest add or !member add though