[SPT/CWIS] "Empty" Search results

[Edward Almasy]

On Jul 26, 2007, at 4:38 AM, Ale Fernandez wrote:
> The way we remove duplicate or test resources is simply deleting them
> from the resources table on the database. I think this is probably not
> enough?

    No, that will leave orphaned values
    behind in other tables.  Why not just
    use the "Delete Resource" button?


> The problem we have now is if you go to the advanced search and search
> by keyword, a lot of now deleted items still come up, as empty  
> records,
> but still taking up spaces in the search results.

    You can fix this by deleting the contents
    of the SearchWords and SearchWordCounts
    tables (via SQL) and rebuilding the search
    database (via the option available on the
    Administration page).

    Ed


---
    Edward Almasy                             ealmasy at scout.wisc.edu
    Co-Director                                 1210 W Dayton Street
    Internet Scout                                  Madison WI 53706
    Computer Sciences Department                608-262-6606 (voice)
    University of Wisconsin - Madison             608-265-9296 (fax)