Closed (fixed)
Project:
Site Documentation
Version:
6.x-1.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
24 Jul 2009 at 14:35 UTC
Updated:
2 Mar 2010 at 18:10 UTC
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
Comment #1
nancydruI added a semicolon.