No More Than 100 rows???

[steffield]

I have a database and it has suddenly stopped adding to it on row 100. I have no idea why I can't add anymore to it.

Any ideas, what do you need to know about it???


Regards
Gunter

[Justin]

Hi,

Can you paste the db structure in here? Also, have you tried running this query through phpMyAdmin? If so, what error did you get?

[steffield]

The error message i get in PHPMyAdmin is:
Error

SQL-query :
INSERT INTO `messages` ( `m_id` , `m_important` , `m_name` , `m_email` , `m_title` , `m_message` )
VALUES (
'', '0', 'Ian Gunter', 'ian@thedesignroom.net', 'Tester', 'Tester Tester Tester'
);

MySQL said:
Duplicate entry '127' for key 1
The database structure is:
CREATE TABLE messages (
m_id tinyint(4) NOT NULL auto_increment,
m_important tinyint(4) NOT NULL default '0',
m_name varchar(250) NOT NULL default '',
m_email varchar(250) NOT NULL default '',
m_title varchar(250) NOT NULL default '',
m_message text NOT NULL,
PRIMARY KEY (m_id)
) TYPE=MyISAM;
The Row Statistics are:
Row Statistic : Statements Value
Format : dynamic
Rows : 100
Row length ø : 174
Row size ø : 195 Bytes
Next Autoindex : 127

When adding a new message to the table, I set the m_id to NULL and the rest as whatever it is and it normally adds, but even though it is up to m_id 127 I have deleted some of these and there is exactly 100 rows in the database

Gunter

[Gijs]

Hi,

info on: http://www.mysql.com/doc/en/Column_types.html

TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

HIH,

Gijs