Table won't add more than 127 rows!!!!!

[lunac]

Please help. I designed a directory manager for a client. It was working absolutely perfectly with test data. Now that we're ready to go to production, I tried to add their actual data. BUT... for some reason it won't add more than 127 rows to the table. I need at least 300.

It gives me error: [color=red]#1062 - Duplicate entry '127' for key 1[/color]

What am I doing wrong?

Here's the table schema:

[code]
CREATE TABLE `directory` (
  `directory_id` tinyint(8) NOT NULL auto_increment,
  `area` varchar(255) NOT NULL default '',
  `lname` varchar(255) NOT NULL default '',
  `fname` varchar(255) NOT NULL default '',
  `lname2` varchar(255) NOT NULL default '',
  `fname2` varchar(255) NOT NULL default '',
  `traffic` enum('yes','no') NOT NULL default 'no',
  `house_num` int(255) NOT NULL default '0',
  `street_name` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `notes` mediumtext NOT NULL,
  `new_neighbor` enum('yes','no') NOT NULL default 'no',
  `shca_board` enum('yes','no') NOT NULL default 'no',
  `shca_volunteer` enum('yes','no') NOT NULL default 'no',
  `vacant` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`directory_id`)
) TYPE=MyISAM
[/code]

[effigy]

Your auto incrementing id is a TINYINT; try INT.

[lunac]

Ahh! yes... that did it. I'm such a dork! :(

Thanks.

[fenway]

And an UNSIGNED one would be better, too.