Hi, Please pardon me for this n00b question. I just acquired this directory (running phpLD v2.1.2) from a fellow DP member and have been diligently approving the submitted links for the past few days. I noticed a very queer problem. Say at the end of Day 1, I would have the following under statistics: Active Links: 2300 Pending Links: 60 At the beginning of Day 2, I would have: Active Links: 2249 Pending Links: 120 So after approving the 120 pending links, at end of Day 2, I would have Active Links: 2369 Pending Links: 0 However, on beginning of Day 3, I would have something like 2340+ active links. Why is this happening? I really cant figure it out, I have randomly checked and quite sure it is not due to the links having expired - or does the phpLD expires links automatically? Please help, I am seeing my hard work going down the drain if this carries on. I should have more than 3000links currently, but it is only 2300+ now. Thanks in advance.
Hm, never seen that problem with the directory I have running phpLD - my best advice is to ask at phpLD's own forums, as the script owner no longer posts here (though he is 'active' here almost every day). Try using the Search function on their forum, perhaps someone's had the same problem before?
run this query via phpMyAdmin: UPDATE PLD_LINK_SEQ SET ID = (SELECT `ID` FROM `PLD_LINK` ORDER BY `ID` DESC LIMIT 1)+1
Yes, the same can also happen to the category table when using a category dump, however, this appears to be a links table issue rather than a category table issue
someone probably imported a database of links and didnt change the SEQ thats gonna just be quality content alright
Just tried an0n's tip. Not too sure if it is working correctly since I will know only in a few hours time (probably). Thanks for the tip though. David has contacted me directly offering help. Nice chap, gives me confidence in phpLD and may use the v3 for my future directories sites. Thanks everyone for your kind help/tips, very very much appreciated. cheers, eddie