DB Insert -- Insert Query Errors out but insert happens???

[eluser]drewbee[/eluser]
It is of int(10);

-- Database Structure Dump:

Code:

CREATE TABLE IF NOT EXISTS `accounts` (
  `account_id` tinyint(10) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `company_name` varchar(50) default NULL,
  `email` varchar(50) NOT NULL default '',
  `first_name` varchar(50) NOT NULL default '',
  `middle_initial` char(1) NOT NULL default '',
  `last_name` varchar(50) NOT NULL default '',
  `address_1` varchar(50) NOT NULL default '',
  `address_2` varchar(50) NOT NULL default '',
  `country` char(3) default NULL,
  `city` varchar(50) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zipcode` varchar(10) NOT NULL default '0',
  `created` int(10) unsigned default '0',
  `modified` int(10) unsigned default '0',
  `account_type` tinyint(2) unsigned NOT NULL default '1',
  `account_group` tinyint(2) unsigned NOT NULL default '0',
  `account_lastlogin` int(10) unsigned NOT NULL default '0',
  `account_status` tinyint(2) unsigned default NULL,
  PRIMARY KEY  (`account_id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;