MYSQL Error 1062 duplicate entry Help

[houseplant2]

I could use some info. im importing info with navicat from an xcell file ad keep getting error 1062 duplicate entry '255' for key 1. I dont understand why im getting this error. The index numbers are different. i tried making them higher and still get this error. I tried copy and pasting the info in and still get the error. obviosly im just not seeing the problem. any help would be appreciated. thanks.

here is the error log:

[2009-02-17 05:08:45] [Msg] Import start
[2009-02-17 05:08:45] [Msg] Import type - Excel file
[2009-02-17 05:08:45] [Msg] Import from - C:\WOM\New Folder\New Folder\n-playercreateinfo.xls
[2009-02-17 05:08:45] [Msg] Import table [playercreateinfo]
[2009-02-17 05:08:45] [Err] 1062 - Duplicate entry '255' for key 1
[2009-02-17 05:08:45] [Err] insert into `playercreateinfo` (`Index`,`race`,`factiontemplate`,`class`,`mapID`,`zoneID`,`positionX`,`position Y`,`positionZ`,`displayID`,`BaseStrength`,`BaseAgility`,`BaseStamina`,`BaseIntel lect`,`BaseSpirit`,`BaseHealth`,`BaseMana`,`BaseRage`,`BaseFocus`,`BaseEnergy`,` attackpower`,`mindmg`,`maxdmg`) values ('0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0'),('500','55','5','1','0','85','1676.35','1677.45','121.67','60330', '22','18','23','18','25','70','0','1000','0','0','27','4','5'),('501','55','5',' 2','530','3430','10349.6','-6357.29','33.4026','60330','19','22','20','24','20','38','140','1000','0','100', '21','4','4'),('502','55','5','3','1','14','-618.518','-4251.67','38.718','60330','21','25','22','16','22','66','81','0','0','0','16','5 ','7'),('503','55','5','4','0','85','1676.35','1677.45','121.67','60330','20','2 1','22','18','25','65','0','0','0','100','30','4','4'),('504','55','5','5','0',' 85','1676.35','1677.45','121.67','60330','19','18','21','20','28','62','130','0' ,'0','0','30','4','4'),('505','55','5','7','1','14','-618.518','-4251.67','38.718','60330','22','22','22','17','23','67','72','0','0','0','30','4 ','4'),('506','55','5','8','0','85','1676.35','1677.45','121.67','60330','19','1 8','21','21','27','62','135','0','0','0','30','4','4'),('507','55','5','9','0',' 85','1676.35','1677.45','121.67','60330','19','18','22','20','27','63','110','0' ,'0','0','30','4','4'),('508','55','5','11','1','215','-2917.58','-257.98','52.9968','60330','26','15','22','17','24','74','67','0','0','0','30','4 ','4')
[2009-02-17 05:08:45] [Msg] Processed:10, Added:0, Updated:0, Deleted:0, Errors:10
[2009-02-17 05:08:45] [Msg] Finished - Unsuccessfully

[stoneharry]

It means something with that entry is already there. Either delete the playercreateinfo that already has that or use a different entry.

[houseplant2]

i tried using different entries and got the same results....its like it gets to the 255 mark and hits a wall. is there a limit to the number of entries i can have in the database? can i change it if there is? im 100% sure there are no index numbers that are the same. i have quadruple checked it.

[waymirec]

Check your table schema and make sure your Index field didn't somehow get set to a tinyint.

[houseplant2]

AH-HA! i think you are right...But it wont let me change it? under the tables@information_schema the number of rows is set to 245. i can highlight it but it wont let me type anything in...how do i change that?

EDIT:
Ok Yea I really have no idea what im doing...I was just looking at another databases creation sql and see tinyint(3) for the index. can i re-create the table and set the tinyint to something larger? how do i fix this?

[Vindicated]

Right click the table name and choose design to change the column type to something bigger/smaller

[houseplant2]

rock on! thanks it worked great!

[waymirec]

You're welcome. As an FYI when I said to check your "schema" I wasn't referring to the information_scheme database. If you execute a "describe playercreateinfo" it will show you the schema for that table and indicate whether Index is an tinyint or int, which can then be changed via a GUI tool as explained above or by executing a mysql "alter table" command (i.e. ALTER TABLE playercreateinfo MODIFY `Index` int unsigned not null auto_increment). Another thing to consider is that should you update your databse in the future you may need to reapply that change as the database is designed with a tinyint, most likely becuase it should never have more than 255 records in it.

[houseplant2]

ok thank you. i can now add more records but its got some other problems apperently. starting characters have items they shouldnt and spells and skills they shouldnt. this is before i even enter in starting items skills ans spells for that race. I usually login before i do all that just to see it works ok. its confusing and i dont know if its a database limitation or a core limitation. i guess 26 races is all i will be able to have for the time being. I was just not expecting to hit this wall. if someone has an idea i would love to hear them but otherwise im frustrated with it for the moment. thanks for all the help.