I've been trying to update my drupal installation with the security patch from 7.20 to 7.26 using a patch file. Problem is I cannot get out of maintenance mode. I've tried everything indicated in other posts: http://example.com/index.php?q=user, http://example.com/user/login. Also tried to go the DB route, but that does not work either since the variable do not seem to contain anything with the "site_offline" name. This is very frustrating. I've also backtracked on the changes by reinstalling the DB and site from backup, but unfortunately I had already put the site in maintenance mode when I took the backups. Grrr. Any help greately appreciated.
The name entry in variable table is supposed to be
maintenance_mode following updates in D7 after which
site_offline_message were replaced with
maintenance_mode_message. Refer the inline comments in
update_fix_d7_requirements in update.inc
// Rename 'site_offline_message' variable to 'maintenance_mode_message' // and 'site_offline' variable to 'maintenance_mode'. // Old variable is removed in update for system.module, see // system_update_7072().
Assuming you have access to the database or drush try updating the variable which is likely set as 1 to 0.
drush vset maintenance_mode 0
UPDATE variable SET value = 's:1:"0";' WHERE name= 'maintenance_mode';
You might also want to ensure that this value is not set as 1 with a
$conf variable in your site's settings.php.
Many users with similar issue also suggest even clearing the cache table entries named variables for this to work after changing the variable value. If things go well this should bring your site back online.