From: Kir Kolyshkin (no email)
Date: Mon Jan 13 2003 - 07:04:09 EST
wrote:
> I think I've goofed up.
>
> Trying to delete some urls from index, i've deleted them
> from 'sites' table, then -- from 'urlword' table.
Hmm...you should have used index -C with url limit.
> Now I have some search results garbled up, without titles
> and excerpts. Links are effectively void, too.
>
> I've ran 'index -X1', 'index -X2' and 'index -H', to the
> same result.
>
> ===
> 2. No title [0.99995]
> ......
> 13 Kb Text version
>
> No title [0.99995]
> ......
> 13 Kb Text version
>
>>>More results from (6692 documents)
>>
> ===
>
> Is there any way to fix it without re-creating the database
> from scratch? (It would be too time-consuming.)
The last resort is to try restarting searchd, but I doubt this will help.
I'm sorry but I think if index -X2 and index -H doesn't help either, you
are screwed up and should start reindexing from scratch :( Next time,
remember to backup your data before doing anything potentially harmful.
> P.S. MySQL base is checked against errors -- found none.
--
== kir_at_asplinux.ru == 7551596_at_ICQ == 6722750_at_sms.beemail.ru ==
Dream like you'll live forever...Love like you've never been hurt...
Work like you don't need the money...and Dance like nobody is watching!
-- Satchel Paige
|
|
|