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] > #-------------------------------------------------------#
