PDA

View Full Version : Fix: Bug In the Add Links


halfpint
01-26-2008, 01:32 PM
Hi I have around 70 Links added and have set the links to show to 200 But when I try and add any more links I get this message now "Bad query: Duplicate entry '127' for key 1" Even though the links are not duplicated and I have tried updating the cache. Can anyone shed any light on what is causing this

Cheers

blank
01-28-2008, 11:52 AM
The fix has to be done in phpmyadmin and is this:


ALTER TABLE `links` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT


it is due to the ID field being a tinyint which apparently ends at the number 127, I am going through the script to see if there are any other examples of this happening for additional queries that will need to be run.

halfpint
01-28-2008, 11:59 AM
Thanks for the swift reply :)