BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: detomb on November 24, 2006, 09:56:59 pm

Title: Problems with MySQL error adding guests.
Post by: detomb 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 :)

Title: Re: Problems with MySQL error adding guests.
Post by: Malosar 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.

Title: Re: Problems with MySQL error adding guests.
Post by: detomb 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 ;)