collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Weird bug  (Read 10208 times)

0 Members and 1 Guest are viewing this topic.

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Weird bug
« on: June 21, 2007, 07:23:25 am »
[2007-06-21 04:02:45]   [GROUP] [MSG]   [All Towers] 0: Cyborg Lieutenant Genera
l just attacked the omni organization Transcendence's tower in Perpetual Wastela
nds at location (3796, 2559).

MySQL error (# 0) on query: INSERT INTO tower_attack (time, off_guild, off_side,
 off_player, off_level, off_profession,
                                      def_guild, def_side, zone, x_coord, y_coor
d) VALUES ('1182398566', '', '',
                                      'Cyborg Lieutenant General', '0', 'Unknown
', 'Transcendence', 'Omni',
                                      'Perpetual Wastelands', '3796', '2559')
Data too long for column 'off_player' at row 1

what the heckler ?
-*tinkers*-

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Weird bug
« Reply #1 on: June 21, 2007, 09:20:25 am »
off_player can hold 20 letters. The mob name was longer. Anyways, it's no character so I doubt it should be entered into the table anyways.

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Re: Weird bug
« Reply #2 on: June 21, 2007, 05:45:45 pm »
off_player can hold 20 letters. The mob name was longer. Anyways, it's no character so I doubt it should be entered into the table anyways.

Or we should trim the input before inserting as mob attacks on towers happen often enough.

Offline Ebag333

  • Contributor
  • *******
  • Posts: 134
  • Karma: +0/-0
Re: Weird bug
« Reply #3 on: June 21, 2007, 06:02:40 pm »
Indeed using a charmed mob or a pet to attack is an old trick.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Weird bug
« Reply #4 on: June 21, 2007, 09:20:53 pm »
easy thing is just make the mysql field bigger

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: Weird bug
« Reply #5 on: June 21, 2007, 10:13:10 pm »
And even simpler, just check if its a valid character name (ie, if it contains spaces, its a mob) and if not, insert just NPCMonster as the attacker in the database.
BeBot Founder and Fixer Kingpin

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Re: Weird bug
« Reply #6 on: June 22, 2007, 03:26:38 pm »
How about :
[Helpbot]: Moqtada (L 24/AL 0), opifex Fixer, Clan, Applicant of Good Spirits
while my bot goes : www.anarchy-online.com was too slow to respond ? xD
mine goes like that even with my guildies :o 2.11 running on 6.0 mysql
-*tinkers*-

Offline Khalem

  • BeBot Founder
  • Administrator
  • ********
  • Posts: 1169
  • Karma: +0/-0
    • http://www.ancarim.com
Re: Weird bug
« Reply #7 on: June 22, 2007, 05:03:59 pm »
Sounds like your bot is unable to connect to Funcom servers at all if you never get a response, you have been blocked by Funcom (not all that likely), or MySQL 6 which is Alpha software is causing issues.
BeBot Founder and Fixer Kingpin

Offline tonyuh

  • BeBot User
  • **
  • Posts: 48
  • Karma: +0/-0
Re: Weird bug
« Reply #8 on: June 22, 2007, 06:13:23 pm »
I do have that problem sometimes when the character has been created on the same day. So I assume FC's database hasn't been updated to include that char yet.

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Re: Weird bug
« Reply #9 on: June 22, 2007, 07:15:15 pm »
Nope had same problem with bot pre upgrade to 2.11 and mysql -> 6.0
also then it didnt show who attacked what where, and went completely boinkers when we got attacked
-*tinkers*-

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Weird bug
« Reply #10 on: June 22, 2007, 08:21:32 pm »
Maybe ur running Local Whois but arnt Getting Name for ur Local Database?

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Re: Weird bug
« Reply #11 on: July 05, 2007, 07:12:04 pm »
Maybe ur running Local Whois but arnt Getting Name for ur Local Database?
Maybe I'm running what ? It says Anarchy online's database aint working not mine lol
-*tinkers*-

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Re: Weird bug
« Reply #12 on: July 12, 2007, 11:47:29 am »
How do I disable Local Whois if that's what my bot is doing ?
-*tinkers*-

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Weird bug
« Reply #13 on: July 12, 2007, 12:14:21 pm »
If you haven't installed the whois cache module you got no lookup cache at all in 0.2.

Otherwise it does look like you got some connection problems to the FC website.

Offline Aesgaard

  • BeBot Apprentice
  • ***
  • Posts: 82
  • Karma: +0/-0
  • .:.Alpha.:.
Re: Weird bug
« Reply #14 on: July 12, 2007, 12:35:24 pm »
Does bebot need port forwarding ?
-*tinkers*-

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 495
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal