By csilver on

Yes, I know there is the warning, but I ignored it thinking I had a good backup. My host company deleted my backup, so now I'm stuck.

I'm playing with php and used the $url variable. Now whenever I try to save any block, I get an invalid url error:

http://foo.com/$url

(I was trying to create a link to foo.com)

Is there anyway to recover? I can't delete the block or make any changes to any block.

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

Edit your database with phpMyAdmin

Look at the 'boxes' table, find the row where the body contains your failing PHP code, note the bid.

Now in the 'blocks' table find the row with the bid from the previous step. Edit the record and set status to 0. Save the changes. You should be able to access your site.

If you can not access the site, empty the 'cache_block' table (that's empty, not drop).

csilver’s picture

csilver commented

Thanks for the suggestions, but that didn't work. The site still shows, but I still can't do most administrative functions like deleting or editing blocks. I'm still getting the invalid url.

Can I delete the block from the boxes table? I don't think that will help, but will it hurt? Any other suggestions?

nevets’s picture

nevets commented

You could try clearing the body field (you will need to clear the block cache again).