tdid sql maker error

Printable View

07-07-13
Pancake Face

tdid sql maker error

Hey there, well I've been using tdid's sql maker and it was all going well until I got this error for every sql I put in after half way; #1062 - Duplicate entry '65535' for key 'PRIMARY'.

The id's aren't even 65535 so I have no idea why it's doing this? This is one of the current sql's I'm trying to do;

Code:

INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `allow_group_item`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('450912', '450912', 'mystics_gtile1', 'mystics_gtile1', 's', '1', '1', '0', '1', '0', '0', '1', '1', '1', '1', '1', '0', 'default', '0', '');

Any help guys:)?
07-07-13
Emily

Re: tdid sql maker error

Quote:

Originally Posted by Pancake Face

Hey there, well I've been using tdid's sql maker and it was all going well until I got this error for every sql I put in after half way; #1062 - Duplicate entry '65535' for key 'PRIMARY'.

The id's aren't even 65535 so I have no idea why it's doing this? This is one of the current sql's I'm trying to do;

Code:

INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `allow_group_item`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('450912', '450912', 'mystics_gtile1', 'mystics_gtile1', 's', '1', '1', '0', '1', '0', '0', '1', '1', '1', '1', '1', '0', 'default', '0', '');

Any help guys:)?

The reason that happens is because I think your id is on tinyint/smallint, change it to normal int.
07-07-13
Pancake Face

Re: tdid sql maker error

as much as I appreciate your help, I actually have no idea how to do that. Mind explaining it?
09-07-13
Emily

Re: tdid sql maker error

Quote:

Originally Posted by Pancake Face

as much as I appreciate your help, I actually have no idea how to do that. Mind explaining it?

Go to PHPMyAdmin, to your database, table items_base, structure, then edit the value of id from tinyint/smallint to int.