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 :)
vBulletin® v3.7.3, Copyright ©2000-2010, Jelsoft Enterprises Ltd.