Delete all Targets isn't working

[JimF]

I have over 14,000 targets. It is possible to select them all, and press Delete; however, even though Delete issues a confirmation message asking if I'm really sure that I want to delete all 14020 targets, in fact only 57 targets are actually deleted. This seems like a pretty clear bug.

How do I really delete all the targets? Is there a workaround by going into mySql and deleting all the rows from some table?

/JimF

[JimF]

Here's a reply to my own thread. I was able to work around the problem as follows:

1. went to mySql web page, downloaded and installed the mySql client GUI
2. connected to the sugarcrm database using mySql query browser, logged in as root, set default schema to sugarcrm
3. there is a table there named 'prospects'. select count(*) from prospects shows the number of rows,
delete from prospects
4. confirmed the rows were deleted by issuing another select count(*) from prospects
5. back in SugarCE, went to Targets and issued another Search. Verfiied that Targets were properly deleted.