L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 01, 2008, 11:39:05 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 0.3 support > Topic: MySQL error running 0.3.4 svn
Pages: [1]   Go Down
« previous next »
Print
Author Topic: MySQL error running 0.3.4 svn  (Read 866 times)
0 Members and 1 Guest are viewing this topic.
Vallaroo
Freshman
*
Offline Offline

Posts: 10


MySQL error running 0.3.4 svn
« on: June 30, 2006, 12:52:49 PM »

When i start the bot i get the following errors:

Connected to MySQL
MySQL error (# 0) on query: ALTER TABLE admin_groups ADD description VARCHAR(80)

Duplicate column name 'description'
MySQL error (# 1) on query: ALTER TABLE admin_groups ADD short VARCHAR(5)

MySQL error (# 2) on query: ALTER IGNORE TABLE guests ADD COLUMN name VARCHAR(25
) NOT NULL AFTER id
Duplicate column name 'name'
MySQL error (# 3) on query: ALTER IGNORE TABLE guests ADD COLUMN timeadd INT NOT
 NULL AFTER name
Duplicate column name 'timeadd'
MySQL error (# 4) on query: ALTER IGNORE TABLE guests ADD COLUMN addby VARCHAR(2
5) NOT NULL AFTER timeadd
Duplicate column name 'addby'

and a few:

MySQL error (# 5) on query: SELECT nickname, level, rank_name, profession, id, a
ilevel FROM members WHERE id = 790755685
Table 'polbot2.members' doesn't exist

Looking at the DB the members table doesnt exist.

I installed 0.3.4 in an empty database.

Another thing too, all commands only work in tells. How can i allow them to work in gc ?
Logged
Khalem
BeBot Founder
Administrator
Grandmaster
********
Offline Offline

Gender: Male
Posts: 670



WWW
Re: MySQL error running 0.3.4 svn
« Reply #1 on: June 30, 2006, 01:54:52 PM »

The ALTER MySQL errors can be ignored.
You can comment out those queries from the modules that call them since they are only needed to be run once.

Error #5 is likely from the Online module.
I just committed a fix for that issue to svn, so do an update.

To adjust commands access, /tell botname !commands

When running svn versions, be sure to keep an eye on http://bebot.shadow-realm.org/index.php/topic,147.105.html for any information related to SVN being broken etc.
Logged

BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
Vallaroo
Freshman
*
Offline Offline

Posts: 10


Re: MySQL error running 0.3.4 svn
« Reply #2 on: July 01, 2006, 07:08:31 AM »

Thank you for the fast response Smiley

I updated online.php as you suggested, and the previous error #5 is gone. On the other hand, i now have a new one:

MySQL error (# 5) on query: SELECT nickname, level, org_rank, profession, id, de
fender_rank_id FROM whois WHERE id = 790755685
Unknown column 'nickname' in 'field list'


Also my bot.conf files currently contain 3 SA`s, when i do a /tell mybot admin groups, all groups come up emtpy. So there are no admins/SAs on my bot atm.
Logged
Ainen
Rookie
**
Offline Offline

Posts: 22



Re: MySQL error running 0.3.4 svn
« Reply #3 on: July 03, 2006, 04:56:27 AM »

Think of the bot.conf SA's as hardcoded backdoors. The admin groups command reads from the database and that doesn't include what was put in the conf file.

It's handy for making org non-members SA's.  Wink
Logged

BeBot 0.3.4 svn 91 // PHP 4.3.9 // MySQL 4.1.12
Vallaroo
Freshman
*
Offline Offline

Posts: 10


Re: MySQL error running 0.3.4 svn
« Reply #4 on: July 03, 2006, 01:04:14 PM »

Well my bot doesnt listen to anyone, and i get "you must be superadmin..." a lot. And i AM superadmin. Btw. in 2.5 those hardcoded guild or not guild SA`s appear in the list. So there is something wrong with my installation running 0.3.4.
Logged
Ainen
Rookie
**
Offline Offline

Posts: 22



Re: MySQL error running 0.3.4 svn
« Reply #5 on: July 03, 2006, 04:14:54 PM »

My mistake. Mine are there. Are you sure they're in the right format? When I changed from .2.5 to .3 I didn't move my Bot.conf over because I noticed some changes to how it was laid out and stuff (don't exactly remember now), I just re-entered the information.

Code:
$super_admin["Ainen"] = true;

Sometimes you have to check that the lines aren't accidentally commented out.
Logged

BeBot 0.3.4 svn 91 // PHP 4.3.9 // MySQL 4.1.12
Vallaroo
Freshman
*
Offline Offline

Posts: 10


Re: MySQL error running 0.3.4 svn
« Reply #6 on: July 07, 2006, 04:25:06 AM »

Yep, there are 3 SAs in the conf file, but they dont get added to the DB. And the lines are correct.
Logged
Vallaroo
Freshman
*
Offline Offline

Posts: 10


Re: MySQL error running 0.3.4 svn
« Reply #7 on: July 07, 2006, 05:06:05 AM »

I added them manually to the DB, works like a charm now.
Logged
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot 0.3 support > Topic: MySQL error running 0.3.4 svn
« previous next »
 
Jump to:  

Recent
[request] Raid timers
by Elesar1
[Today at 04:41:09 PM]

Shared DB online list
by Temar
[Today at 01:55:47 AM]

relay colors
by Temar
[Today at 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]

Change to Bid.php
by Temar
[November 30, 2008, 11:41:44 AM]

OnlineOrg
by Jiheld
[November 29, 2008, 12:44:27 PM]

Silly Newbie Question.
by Temar
[November 29, 2008, 12:00:02 PM]

massive_pvp_time_table 1
by gerborg
[November 29, 2008, 06:55:35 AM]

Bot not see Guild Chat
by Delvar
[November 28, 2008, 08:30:34 AM]

Starting Bot
by Allisande
[November 28, 2008, 07:08:21 AM]
Stats
Members
Total Members: 1243
Latest: Whackoeng
Stats
Total Posts: 11144
Total Topics: 1505
Online Today: 21
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 0
Guests: 17
Total: 17

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.293 seconds with 29 queries. (Pretty URLs adds 0.026s, 4q)
Loading...