Finding links in non existing categories ???

[Frank71]

Hello,

I did my own dmoz import, because dmoz extr. from here is buggy and now I have round about 20000 categories and 150000 links imported.
I fixed the categories, but I think I have still a lot of links in non existing categories, because update numbers of links never finish (may be indexu is at the limit ).

So I need a way to search all links which are added to an not existing category - do you have any idea how to find them ?

Regards
Frank

[dody]

20000 categories

Indexu use recursive iteration to calculate number of links and finding its children. It's a huge number. I suggest to have less categories and large number of links.

With a little trick you can search uncategorized link.
- make a category named 'no_category' and find its category_id
- do query to populate these links

update idx_link set category_id - '30000' where category_id = ''

where 30000 is your no_category id
- do search link in admin panel

[Frank71]

Hellol,

thanks, but my problem is, that I have links from an old dmoz import which have a categoryID which doesn't exist !

You remember your dmoz script can't handle special letters so I found, changed and deleted all categories with special letters.
Now I have ~ 20000 categories and ~150000 links left ( after a lot of work, I must use this database !) and I know tousands of links has a categoryID setting which doesn't exist and I must find them !

That means while you count the links I must write down and delete all links which exist in a non existing category - do you understand ?

By the way in v5 your dmoz tool completely fail, no mor eimports possible...

Regards
Frank

[dody]

I see. I have an idea, the custom php script will help you.

1. find unused category id from idx_link (by comparing one by one with idx_category)
2. update category_id from idx_link which has unused category_id, make it empty
3. do as my idea from my first post above

[Frank71]

Hi,

yes, but do you have such a script ?
I can fix small things, but I'm not to able to write such a script..

Regards
Frank

[dody]

You can ask zubby to do custom work

[Frank71]

I sent two small job descriptions yesterday...

Frank