[SOLVED] Mysqll

[Daney11]

Hey, my mysql table only allows 127 entrys. It is InnoDB and when i try and add more than 127 entries they dont go in?

 

Any ideas

 

CREATE TABLE `logs` (

  `log_id` tinyint(100) NOT NULL auto_increment,

  `log_ip` varchar(100) NOT NULL,

  `log_site` varchar(100) NOT NULL,

  `log_user` varchar(100) NOT NULL,

  `log_type` varchar(100) NOT NULL,

  `log_body` text NOT NULL,

  PRIMARY KEY  (`log_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;

 

[fenway]

For any one who's interested, the problem was the tinyint as the PK... UNSIGNED INT or bigger should have been the choice of datatype.