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

    Author Topic: Problems with MySQL error adding guests.  (Read 1796 times)

    0 Members and 1 Guest are viewing this topic.

    Offline detomb

    • BeBot Rookie
    • *
    • Posts: 2
    • Karma: +0/-0
    Problems with MySQL error adding guests.
    « on: November 24, 2006, 09:56:59 pm »
    When I try to add new guests now, this is what I get:

    MySQL error (# 0) on query: INSERT guests (id) VALUES (1738987736)
    Field 'timeadd' doesn't have a default value

    This happened all of a sudden, and nothing has changed on bot/been restarted.
    All old guests can still join and leave.

     ???   Any help would be appreciated :)
    Logged

    Offline Malosar

    • BeBot Expert
    • ****
    • Posts: 259
    • Karma: +0/-0
      • http://www.lowerdimension.com
    Re: Problems with MySQL error adding guests.
    « Reply #1 on: November 27, 2006, 09:46:38 pm »
    Sounds like "timeadd" requires a value and it's not adding one in the code. You could check the code to see whether it's putting a time() in the insert statement, or a variable with the timestamp stored.

    You could also alter the table to make a default value for timeadd.
    Logged
    Eternalist
    General of The Syndicate

    Offline detomb

    • BeBot Rookie
    • *
    • Posts: 2
    • Karma: +0/-0
    Re: Problems with MySQL error adding guests.
    « Reply #2 on: November 27, 2006, 10:30:10 pm »
    I might be missing something that's right infront of me here. But where is the code for this?

    Nvm, it was right infront of me ;)
    « Last Edit: November 27, 2006, 10:31:52 pm by detomb »
    Logged
    Pages: [1]   Go Up
    « previous next »
     
    * 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: 756
    • 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