MySQL 5 Application Error

[Mulugeta Maru]

Table structure:

CREATE TABLE `players` (
  `PLAYERNO` smallint(6) NOT NULL default '0',
  `NAME` char(15) NOT NULL default '',
  `INITIALS` char(3) default NULL,
  `YEAR_OF_BIRTH` smallint(6) default NULL,
  `SEX` char(1) default NULL,
  `YEAR_JOINED` smallint(6) NOT NULL default '0',
  `STREET` char(15) NOT NULL default '',
  `HOUSENO` char(4) default NULL,
  `POSTCODE` char(6) default NULL,
  `TOWN` char(10) NOT NULL default '',
  `PHONENO` char(10) default NULL,
  `LEAGUENO` char(4) default NULL,
  PRIMARY KEY  (`PLAYERNO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1