collapse collapse
Menu
  • Home
  • Archives
    • * 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
    « previous next »
    Pages: [1]   Go Down

    Author Topic: Auto reinvite not setting (MySQL error)  (Read 4395 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?
    Logged

    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
    Logged

    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
    Logged
    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
    Logged

    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.
    Logged
    Pages: [1]   Go Up
    « previous next »
     
    * 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: 287
    • 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