By bryancasler on

My site is perminantly stuck in offline mode. I left an open <table> element in a block. It subsequently crashed my site. I then deleted the block directly from my blocks table in my database. I then did the following based on the instructions here: http://drupal.org/node/56995

I deleted the variables value from my cache table
I set my offline_variable to s:1:"0";

My site URL: http://www.ivawsandbox.com.php5-5.dfw1-1.websitetestlink.com/node

If anyone could throw me a lifeline, I would be utterly grateful.

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

It looks like it is back.

bryancasler’s picture

bryancasler commented

I just created a new database and will do it from scratch again. Any idea how I can look in my old database and tell what modules were enabled ?

jscoble’s picture

jscoble commented

Log into your database using a client and query it directly. You should be able to recover everything by finding the offending record and updating the record with the

element inserted in the proper place.

The DB client you use will depend on what your backend DB is.

sklein121’s picture

sklein121 commented

Were you able to figure this out?

I've tried everything - /user, /?q=user, etc...

I've also tried the MySQL approach and am getting the same result, where 'site_offline' is missing -

UPDATE variable SET value = 's:1:"0";' WHERE name = 'site_offline';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM cache WHERE cid = 'variables';# Affected rows: 1

Does anyone know what can be done to correct this? does it make sense to add 'site_offline' to the table?

Thanks for any help!