duplicate key?

mykg4orce

ok i am getting this error when adding a row to the database:

MySQL said:

Duplicate entry '127' for key 1

Some details:
Row Statistic:
Statements Value
Format dynamic
Rows 117
Row lengthø 72
Row size _ø 90 Bytes

Next_Autoindex 127

I got this error before too, but i have no idea what it means. Please help.

philipolson

Look at your db schema, looks like your keys are from a tinyint data type. Change that to int(6) or similar.

mykg4orce

ok here: i changed the tinyint to 6 from 4:

Table structure for table `mike_comics`

CREATE TABLE mike_comics (
ID tinyint(6) NOT NULL auto_increment,
comic_order tinyint(6) NOT NULL default '0',
comic_name mediumtext NOT NULL,
comic_caption mediumblob NOT NULL,
comic_month tinytext NOT NULL,
comic_year tinytext NOT NULL,
comic_file tinytext NOT NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;

and php tells me this error now:
1064: You have an error in your SQL syntax near '('', '', 'TEST', '', 'Jan', '2000', 'error.gif')' at line 1

[deleted]

Change it to INT, not TINYINT, and leave off the brackets.

TINYINT never goes higher than 128 signed or 255 unsigned. INT goes into the billions.

mykg4orce

ahhh, it works! Damn.....how little i know🙁

[deleted]

"Damn.....how little i know"

.. or how badly MySQL informs it's users.

MySQL tend to encourage using the tinyint because it is so small. But they neglect to mention that it's so f*cking small it's of hardly any use whatsoever 🙂

philipolson

:-)

Sxooter

Tinyint is part of MySQL's "performance over all else" philosophy.

funny thing is that with the overhead of an auto-increment primary key, the time and space saved by a tinyint over a regular int is quite insignificant.

mykg4orce

see, I had this problem before and i searched their site but found nothing. Only references to it came up, no reasons or anything else. So when this problem came up again I posted here. Thanks!

Now im gonna have to change all my 'TinyInt' fields...i think thats gonna take hours....is there a faster way?? like making mysql change all 'TinyInt's to 'Ints' any such commands?

i'll search it I guess 🙂