HOME FORUM
* *

Content

  •    Links
  •        Downloads
  •        Bugtracker
  •        Code repository
  •        Documentation (Wiki)

User

Welcome, Guest. Please login or register.
Did you miss your activation email?
July 04, 2009, 06:16:14 PM

Login with username, password and session length

Search




Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot Hyborian support > Topic: Add User issue
Pages: [1] 2 3   Go Down
« previous next »
Print
Author Topic: Add User issue  (Read 2068 times)
0 Members and 1 Guest are viewing this topic.
Iheaca
Rookie
**
Offline Offline

Posts: 23


Add User issue
« 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.
Logged
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« 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.
Logged
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« Reply #2 on: September 15, 2008, 09:59:07 PM »

Nobody has a clue on what the issue could be ?
Logged
Nytridr
Expert
*****
Offline Offline

Gender: Male
Posts: 262


WWW
Re: Add User issue
« Reply #3 on: September 16, 2008, 02:24:07 AM »

verify your php and mysql

php --version
mysql --version

and post them here.
Logged

Co-Prez of Rising Sun RK1 (1st & only org I will ever belong to)
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 1091



WWW
Re: Add User issue
« Reply #4 on: September 19, 2008, 07:01:35 AM »

the char_id is missing
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« 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 ?
« Last Edit: September 19, 2008, 11:06:12 AM by Iheaca » Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 1091



WWW
Re: Add User issue
« 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
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« 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 ?
Logged
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« 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.
« Last Edit: September 23, 2008, 06:28:23 AM by Iheaca » Logged
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« 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
Logged
Elesar1
Rookie
**
Offline Offline

Posts: 47


Re: Add User issue
« 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
Logged
Elesar1
Rookie
**
Offline Offline

Posts: 47


Re: Add User issue
« 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 Tongue

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 :\
« Last Edit: September 23, 2008, 04:51:15 PM by Elesar1 » Logged
Elesar1
Rookie
**
Offline Offline

Posts: 47


Re: Add User issue
« 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.
Logged
Alreadythere
BeBot Maintainer
Administrator
Grandmaster
********
Offline Offline

Posts: 1251


Re: Add User issue
« 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 Wink
« Last Edit: September 24, 2008, 02:04:53 PM by Alreadythere » Logged
Iheaca
Rookie
**
Offline Offline

Posts: 23


Re: Add User issue
« Reply #14 on: September 24, 2008, 02:11:33 PM »

Thanks trying asap
Logged
Pages: [1] 2 3   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot Hyborian support > Topic: Add User issue
« previous next »
 
Jump to:  

Recent

  • bind module to group? by Alreadythere [Today at 06:07:10 PM]
  • multiple bots on one acco... by WeZoN [Today at 04:52:37 PM]
  • No Auto-notify for new Me... by Wolfbiter [Today at 12:04:14 PM]
  • Player Quotes by clashbot [Today at 09:53:22 AM]
  • Quotes module by clashbot [Today at 09:44:54 AM]
  • unable to load by Khalem [Today at 09:01:07 AM]
  • Bebot 6.3 installation pr... by Gridsurge [Today at 05:58:27 AM]
  • Installing v0.6.3 by Vulkor [Today at 12:34:46 AM]
  • AoC and Patch 1.05 by Apollyon [July 03, 2009, 10:00:56 PM]
  • !items error now by Rekkx [July 03, 2009, 07:29:43 PM]

Stats

Members
  • Total Members: 1225
  • Latest: Apollyon
Stats
  • Total Posts: 12812
  • Total Topics: 1743
  • Online Today: 29
  • Online Ever: 168
  • (July 01, 2007, 09:30:02 PM)
Users Online
Users: 5
Guests: 18
Total: 23
WeZoN
DJKRose
Crazy
TinyPortal v1.0 beta 3 © Bloc

Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC
| NewDef design by Bloc
Page created in 0.214 seconds with 35 queries. (Pretty URLs adds 0.039s, 4q)
Loading...