Remove Block Directly From Database - Drupal 7

Question

I created a block and put in some invalid PHP code resulted in entire site not accessible at all.

I'm fairly new to Drupal and I'm not a back-end programmer either. Much appreciated if you can provide a clear step-by-step guide on how to delete that particular block directly from the Database (PhpMyAdmin).

Answer 1

• Login into PHPMy Admin with admin credentials
• Search for the block table; in this table search for the block which you have created
• Change the value of status column form 1 to 0
• Delete all the content from the cache_bootstrap table

Answer 2

To delete a block programmatically using the Database API, try this:

$module = 'block';
$delta = 1;

// Get the block id (bid) required to delete the correct block from table 'block_custom'
$result = db_select('block', 'b')
         ->fields('b', array('bid'))
         ->condition('module', $module)
         ->condition('delta', $delta)
         ->execute();
$bid = $result->fetchField();

db_delete('block_custom')
  ->condition('bid', $bid)
  ->execute();

db_delete('block')
  ->condition('module', $module)
  ->condition('delta', $delta)
  ->execute();

db_delete('block_role')
  ->condition('module', $module)
  ->condition('delta', $delta)
  ->execute();

When creating custom blocks through the Drupal Block UI, the module name is block and the delta value is an integer. Be sure to use the correct delta value to delete the desired block.

Answer 3

just use this simple query to delete the block.

delete from block where module = 'MODULE' and title = 'TITLE'

Replace MODULE with the name of the module creating the block, and TITLE with the block title.

If the block doesn't have a title, you could use only delete from block where module = 'MODULE'.

Answer 4

delete from block where delta = '[DELTA]';

If you created the block programmatically you should be able to recreate the delta value with the same logic you used to create it. It's the value you passed as the KEY to your blocks array for example $blocks['myblock'] -- myblock is the value stored in delta.

On an aside, I personally think its a good idea to prefix this name with your module prefix. When I look in my Blocks table, I can see mymodule_myblock for my delta and there is no ambiguity.