Hercules Elf Bot - Nov 5, 2007 17:05
Originally posted by [b]Lordeh[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=374
in main.sql, line 482:
[codebox]`status` tinyint(2) unsigned NOT NULL default '0',[/codebox]
in upgrade_svn11582.sql, line 1:
[codebox]ALTER TABLE `mail` CHANGE `read_flag` `status` TINYINT(2) NOT NULL default 0;[/codebox]
I happened to delete my old mail table and recreate it using the entry in main.sql,
only to discover that it uses a unsigned int for "status", and from what i can tell from the resulting error
messages, negative values are used for this status indicator (-1).
Does not affect people using the upgrade_xxx.sql, but would affect new sql setups.
Cheers,
Simon.