Deep trouble with spidering
 

Hi Folks, I am having some problems with the spider.
My computer crashed when I was spideringa web site, when I logged back online and went back to the admin page it appears that all the web sites in my list or URL's were now "Locked" and the only way I can unlock them is to do each one, one by one and this is taking ages.
I have tried to delete a site (Without a name) which should clear the temp table but I can't seem to find a way to stop PHPDIG spidering all the web sites I have spidered before.
So I can't clear dashes, or the distionary because it says "Closed due to spidering!"
SO I was wondering if someone could help me out and give me a way to stop the spider, spidering evrything again.

Some web site I have already spidered appear to have lost the previous spidering data, when I look at them to unlock them in the admin apnel it shows (0) pages indexed when before it had contained some data.

Any clues Folks?

All the best
Dave Andrews

If you can get into php mysql, you can use sql to set the 1 under `locked` to 0. That's what I had to do.

PHP Admin
 

Yes in the end I had to go into the PHPADMIN of my web host and sit and edit out all the entries just like you suggested, so thanks for your advice it worked.
One small point that I would mention is that when I first tried to clean the index of dashes, it appeared to lock all the files again. But then after a few minutes it finally cleared itself it must have been a slow connection at my end but it did make me sweat for a while!

Thanks for your help

Many regards
Dave A