How can I remove a block that corrupts my site?
This is what I did:
1) I added a custom block with the function theme_relativity_block_link_operations
2) Changed input format to php and saved the block
Boom, now I only see blank pages if I write http://localhost:8080, http://localhost:8080/?q=admin etc.
This is the error I recieve if I run update.php:
user warning: Table 'myloc3_mysql.relativity_access' doesn't exist query: SELECT nid FROM relativity_access WHERE uid = 1 in C:\Drupal\includes\database.mysql.inc on line 172.
user warning: Table 'myloc3_mysql.relativity_access' doesn't exist query: SELECT * FROM relativity_access WHERE nid = 307 in C:\Drupal\includes\database.mysql.inc on line 172.
Nothing changes if I run the update.php however. Also, nothing happens if I remove the relativity or relativity_access folders from the modules folder.
Can I remove this block somehow?
Found a solution
I deleted the block from the table called boxes. I tried my way out by following some commands from http://www.pantz.org/database/mysql/mysqlcommands.shtml
You have saved my tail ...
I do not know who you are, or if you will ever see this.
But God bless you for taking the time to write down the answer to your question.
I put a php script in a block, and created a fatal crash on loading the home page.
Nothing could get around it, until I found this.
I used phpmysql tools offered by 1&1 , table name =boxes, field name = body
In appreciation
Alex
PS - my fix was to replace the script in the table with the word "hello" - the block could now load without error - and I have my site back - 1-45am ......
Caught me by surpise as well
I'm glad to hear that it solved your problem. I did the exact same thing as you and had my whole site crash as well. I was surpised how "dangerous" it can be to add a php script in a block, since so many people suggest you to do so. But at least there is a way to save your tail...
One tip is to take the php
One tip is to take the php code and firstly put it in a new page with format set to php. Then click [Preview] NOT submit if it workd great if it crashes you have not submitted it so your site isnt broken. Perhaps we should request a [Preview] button on blocks
Thank you all for this thread.
As stated in one of the above posts. Thank you all for taking the time to post. Bad php block snipit crashed my site. Sure enough went the dbase and found BOXES and there was the little bugger, deleted it and voila. Thank you.