categories disappeared

[Richie_Ni]

Just now I was adding some new categories to my directory,after a few minutes I found the "business" category and all the subcategories were gone....Well,I've had this problem a few times,and I thought I need to post it here now.
Anyone have had the same problem?
Probably it's a bug in phpld?

[britishguy]

You already know who has the answer
Where's an0n ;)

[login]

Are you sure you made the categories active ?

[Richie_Ni]

Alive Directory (http://www.livelydirectory.com/alive-business-web-directory-link-16.html) is now in the Art category which was in the Business category before... http://img92.imageshack.us/img92/3548/cryinganimlu0.gif

Where's an0n
He's sleeping.... :(

Are you sure you made the categories active ?
Of course!

[just-4-teens]

have u re-built category cache?

[vegabond]

Must be you are facing problem with CATEGORY_SEQ, Is that getting the last number of Category ID?

{edit}
Just got this post at phpLD forum, Posted by anOn
http://www.phplinkdirectory.com/forum/showpost.php?p=20315&postcount=7

Hope this can help you :)
{/edit}

[Richie_Ni]

have u re-built category cache?
No,I didn't do that.

[Richie_Ni]

Must be you are facing problem with CATEGORY_SEQ, Is that getting the last number of Category ID?

{edit}
Just got this post at phpLD forum, Posted by anOn
http://www.phplinkdirectory.com/forum/showpost.php?p=20315&postcount=7

Hope this can help you :)
{/edit}
Hey Shabu,
Thanks for your help!
But I'm not sure what Rob meant,I'll wait for Rob and see what he says..
It would be great if he could help me!

I should have added the categories manually..:(

[popotalk]

Try running virus scan on computer. Happened to me before. If it helps then proceed adding category and fix the links.

[Richie_Ni]

Try running virus scan on computer. Happened to me before. If it helps then proceed adding category and fix the links.
Read this:http://www.phplinkdirectory.com/forum/showpost.php?p=20315&postcount=7

:DAnyway,it's my fault...I'll be rebuilding the category structure soon.

[ccoonen]

I'm not sure how phpLD is coded, or its nuances but I've seen this issue before from personal development. Did you by chance, change the structure in some way, then click the Browser Back button then try to re-save? This might have screwed up the New ID associations? (just a far-out-there guess)

[an0n]

good morning.


go into your phpMyAdmin and run this:


UPDATE PLD_CATEGORY_SEQ SET ID = (SELECT `ID` FROM `PLD_CATEGORY` ORDER BY `ID` DESC LIMIT 1)+1

[syted]

I had this problem only on my first directory which I used a dump, an0n's fix has resolved it. Since then I've added all categories to my directories manually which takes a little time but is definitely the way to go I'd say.

[Richie_Ni]

good morning.


go into your phpMyAdmin and run this:


UPDATE PLD_CATEGORY_SEQ SET ID = (SELECT `ID` FROM `PLD_CATEGORY` ORDER BY `ID` DESC LIMIT 1)+1
Thanks,Rob!

That's all?

[an0n]

yip, that's all :)