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.

verify your php and mysql

php --version
mysql --version

and post them here.

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 ?

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 ?

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

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 :\

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