Mass delete of accounts record failed!

[john.luat]

Hi,

Just want to ask how to resolve this issue.

When i mass delete from the accounts tab, the update query fails saying this msg "Query Failed:UPDATE racct_recent_accounts SET deleted=1, date_modified='2009-01-30 19:54:09' WHERE accounts_idb= 'blah-blah-blah'::MySQL error 1146: Table 'sugarcrm.racct_recent_accounts' doesn't exist"

i understand that the table really does not exist in my database and I would like to know the schema of the table "racct_recent_accounts"

Thanks and more power!~

OS: winxp
Sugar ver: SugarCRM community Ed 5.2.0
Webserver: IIS 6
PHP: 5
MySQL: 5

[SergeiLo]

Hi,

I had the same problem when I tried to delete more than 15K records at one time. Then I figured out that I can delete only 3K records at one time and in 5 steps I deleted them all.
Thus, if you have more than 3K records, so mass delete won't work. Try to delete 1K-3K records at one time. It should work.

Regards,
Sergei

[crmsiva]

If you are deleting through interface, the records will be marked as deleted = 1 in DB and it will not be deleted from DB. So 15k records are simply sitting in DB without any use. It is an extra load to the DB. If you think that data may be useful in future, you can simply take a backup and the truncate the accounts related tables.