When cleaning up blocks (using provided SQL statement) mySQL reports error.
Maybe a missing blank.

 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{blocks} WHERE theme='testtheme' AND module='advpoll' AND delta='latest_poll'DELE' at line 1

DELETE FROM {blocks} WHERE theme='testtheme' AND module='advpoll' AND delta='latest_poll'DELETE FROM {blocks_roles} WHERE module='advpoll' AND delta='latest_poll'DELETE FROM {blocks} WHERE theme='testtheme' AND module='aggregator' AND delta='category-1'DELETE FROM {blocks_roles} WHERE module='aggregator' AND delta='category-1'DELETE FROM {blocks} WHERE theme='testtheme' AND module='aggregator' AND delta='feed-3'DELETE FROM {blocks_roles} WHERE module='aggregator' AND delta='feed-3'DELETE FROM {blocks} WHERE theme='testtheme' AND module='aggregator' AND delta='feed-4'DELETE FROM {blocks_roles} WHERE module='aggregator' AND delta='feed-4'DELETE FROM {blocks} WHERE theme='testtheme' AND module='comment' AND delta='0'DELETE FROM {blocks_roles} WHERE module='comment' AND delta='0'DELETE FROM {blocks} WHERE theme='testtheme' AND module='custom_links' AND delta='0'DELETE FROM {blocks_roles} WHERE module='custom_links' AND delta='0'DELETE FROM {blocks} WHERE theme='testtheme' AND module='custom_pager[...] 

Comments

nancydru’s picture

Status: Active » Fixed

I added a semicolon.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.