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

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

Author Topic: Auto reinvite not setting (MySQL error)  (Read 4396 times)

0 Members and 1 Guest are viewing this topic.

Offline taconis

  • BeBot User
  • **
  • Posts: 34
  • Karma: +0/-0
Auto reinvite not setting (MySQL error)
« on: August 29, 2008, 05:42:56 am »
MySQL error (# 0) on query: UPDATE online SET reinvite = '0' WHERE nickname = 'toon name' AND botname = 'bot name'
Unknown column 'reinvite' in 'field list'

would this be in table botname_users?

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Auto reinvite not setting (MySQL error)
« Reply #1 on: August 29, 2008, 10:58:36 am »
no reinvite should be online table, this is reinvite for bot restart/crashes
Yours online table should have the field reinvite no idea why it doesnt, i have checked the code and it seems fine

Offline Nytridr

  • BeBot Expert
  • ****
  • Posts: 262
  • Karma: +0/-0
    • Rising Sun
Re: Auto reinvite not setting (MySQL error)
« Reply #2 on: August 29, 2008, 08:01:53 pm »
drop your online table and restart your bot.  Let the bot rebuild it and see if you still get the same message
Co-Prez of Rising Sun RK1 (1st & only org I will ever belong to)

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Auto reinvite not setting (MySQL error)
« Reply #3 on: August 29, 2008, 09:12:59 pm »
or prevent any messing up of online bots, edit the table_version table and change the online version to 3 and restart 1 bot

Offline taconis

  • BeBot User
  • **
  • Posts: 34
  • Karma: +0/-0
Re: Auto reinvite not setting (MySQL error)
« Reply #4 on: August 30, 2008, 04:10:50 pm »
Dropping table online and restarting worked.  Odd how the column was never created in the table on first run.

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


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


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

* Who's Online
  • Dot Guests: 293
  • 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