How to delete all statuses? [#2488354]

Hello, i want to delete all statuses, so i created a view of statuses updates and added the field VBO. When i select all statuses and try to delete them i get a WSOD and in log messages i get "Could not determine the entity type for VBO field on views base table statuses".

Any advice? Thanks.

Comments

Comment #1

Snehal Brahmbhatt CreditAttribution: Snehal Brahmbhatt at AddWeb Solution Pvt. Ltd. commented 14 May 2015 at 07:39

Hi haunted,

Please check permission "Delete all statuses - Delete statuses created by anyone" is checked or not.

Let me know if you face any query regarding this.

Thanks,
Snehal Brahmbhatt | AddWeb Solution
Email: contact@addwebsolution.com

Comment #2

haunted CreditAttribution: haunted commented 14 May 2015 at 11:02

Yes, the permission "Delete all statuses" is checked for the Administrator.

Comment #3

IceCreamYou CreditAttribution: IceCreamYou commented 20 May 2015 at 02:49

Status:

Active

» Fixed

It looks like VBO integration doesn't work in D7 because D7 VBO only works with objects that are Entities, and Statuses are not.

One way to delete all statuses is to reinstall the module. Another way is to use Statuses' integration with the Devel Generate submodule which provides an option to delete all statuses. Another would be to run this code:

  $result = db_select('statuses')
    ->fields('statuses', array('sid'))
    ->execute()
    ->fetchAll();
  foreach ($result as $status) {
    statuses_delete_status($status->sid);
  }
  drupal_set_message(format_plural(count($result), 'Deleted one status', 'Deleted @count statuses'));

Yet another way would be to run DELETE FROM statuses in your database, but you'd need to clean up after yourself with any submodules that also install tables that relate to statuses.