Stuck cron job in elysa cron

Just go and run this into devel/php

db_query("update elysia_cron set running = 0 where name = 'search_cron'");

where in this case I am unstucking cron job for search indexing.

Reset (wipe) search index

If you want to wipe out current search index, because you maybe made custom search module to quickly wipe out search tables run this into devel/php and you are starting from scratch

Running a query with devel module

If you need to check something quickly with devel module. You can use db_query and put any sql command in it. Like

$query = db_query("SELECT * FROM `block` WHERE `delta` LIKE 'main_menu' ORDER BY `theme` DESC"); foreach($query as $result) { dpm($result); }

and dpm results to see what are the values.

Quick database variable check

With devel/php you can go to some site and quickly found out value of some variable in DB that might concern you. So to do that you can go and write

Placholders in t('')

This one is easily overlooked but pretty important, strings in translation function can have arguments that can be replaced in 3 ways.

$text = t("This is !name's website", array('!name' => $username));
$text = t("This is @name's website", array('@name' => $username));
$text = t("This is %name's website", array('%name' => $username));

Truncate all cache tables with drush or code

Drush

echo "SHOW TABLES LIKE 'cache%'" | $(drush sql-connect) | tail -n +2 | xargs -L1 -I% echo "TRUNCATE TABLE %;" | $(drush sql-connect) -v

Here's how to do this from the command line...