Diego Montalvo �����(�): > Alexander, > > Going back to the Japanese Shift-JIS search > capability, all I need to do is compile 120,000+ > japanese terms (words) > > exmple: dog, cat, house, weird etc.... > > But of course in Japanese? I may be able to compile > that data. >
Yes, in Japanese ideographs. > > Diego > > --- Alexander F Avdonkin <[EMAIL PROTECTED]> wrote: > > Add "sum(deleted=0)" to select list of your query. > > Records are not deleted from "urlword" table, but > > field "deleted" is set to 1. > > > > > > Alexander. > > > > Elsner �����(�): > > > > > I tried to delete some URLs which should not be > > indexed: > > > > > > $ ./index -C -u > > http://vs1.rz.uni-osnabrueck.de/video/% > > > ...(many Delete ...) > > > Delete url: > > > > > > http://vs1.rz.uni-osnabrueck.de/video/ub/work/Info_Clips/QuickTime4_Required.mov > > > Saving real-time database ... done. > > > Saving delta files > > [..................................................] > > done. > > > Saving real-time ... done > > > Saving redirects ... done > > > Splitting href delta file ... done > > > Saving href delta files ... done > > > Saving direct href delta files ... done > > > Calculating ranks > > [................................................] > > done. > > > Saving lastmods ... done > > > Generating word site .Unsupported protocol in > > > /users/physik/theo3/severien/abstract.html:/// > > > .. done > > > Deleted 44198 urls > > > --- > > > > > > OK, this number (44198) seems to be alright. > > > But mysql monitor shows: > > > > > > mysql> select sites.site, count(url) as 'Anzahl' > > from urlword,sites where > > > url like 'http://vs1%/video/%' and status=200 and > > > sites.site_id=urlword.site_id group by > > urlword.site_id order by sites.site; > > > +----------------------------------+--------+ > > > | site | Anzahl | > > > +----------------------------------+--------+ > > > | http://vs1.rz.uni-osnabrueck.de/ | 43534 | > > > +----------------------------------+--------+ > > > 1 row in set (1.40 sec) > > > > > > This number should be zero, as everything in > > /video/ was deleted. > > > (I checked with: > > > select url from urlword where status=200 and url > > like 'http://vs1.%/video/%'; > > > and got many results, too.) > > > > > > How can I really delete these URLs? > > > What command is necessary to update the urlword > > table in the > > > aspseek12 database.? > > > > > > Thanks for comments. > > > Yours Frank > > > > > > > > > #-------------------------------------------------------# > > > Dipl.-Math. Frank Elsner > > > Universitaet Osnabrueck (University of Osnabrueck) > > > - Rechenzentrum - (Computing Center) > > > Albrechstrasse 28, AVZ > > > D-49076 Osnabrueck > > > Deutschland (Germany) > > > > > > Tel. (Phone): ++49 (0)541/969-2343 Fax: -2470 > > > E-Mail: [EMAIL PROTECTED] > > > > > > #-------------------------------------------------------# > > > > __________________________________________________ > Do You Yahoo!? > NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. > http://geocities.yahoo.com/ps/info1
