PDA

View Full Version : Link is being deleted when another is added


dino_ld
06-22-2007, 02:15 AM
I have version 2.1.2 running beautifully on my dedicated server. I install the PageRank updater module and it works without a hitch. I start pounding in links and I hit around 480 and it starts acting funny. I thought the count of links were incorrect, but I continued anyways. Still finding it funny the link count wasn't going up, I checked MySQL. Indeed, the number of rows in PLD_LINK wasn't going up.

To my shock, a row was being deleted each time a new link was added. I had been using the administrative backend to input links. I tried the frontend's submission form and received the same result. I did a direct insert via myPHPAdmin and it worked fine. I just had to try. I then tried adding via the backend just to see if the bug somehow fixed itself. It didn't. Any other ideas I could try?

James
06-22-2007, 02:38 AM
http://www.phplinkdirectory.com/kb/Oh_My_God_-_My_Categories_are_disappearing.html

dino_ld
06-22-2007, 03:35 AM
This did it. Thanks! I'll send you a donation.

UPDATE PLD_LINK_SEQ SET ID = (SELECT `ID` FROM `PLD_LINK` ORDER BY `ID` DESC LIMIT 1)+1