View Single Post
  #1  
Old 02-07-2009, 04:47 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default mailkey on STRICT mode MySQL

I discovered today that new characters being created on my server were being denied due to the new character_.mailkey column being set to NOT NULL, but not getting a value during character create (or maybe that's something I have configured wrong?). This is because my MySQL runs in STRICT_ALL_TABLES mode, so when a field is deemed NOT NULL, it really means, do not allow inserts if there is no value for this field.

For now, I took off the NOT NULL, but hoping someone can tell me if a) this is a bug in as much as the field is just too forgiving, or b) if this is a result of the fact I do not have the mail/chat systems working yet. I do not know if that key actually gets generated *IF* the system is running.

Thanks
Reply With Quote