The last two times I deleted a page I got an error like this.
WordPress database error: [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 ‘WHERE post_id=295’ at line 1]
DELETE FROM WHERE post_id=295
The same error came up on the screen about 4 times with different post IDs each time.
Although I get the error, the posts are actually deleted as their IDs no longer appear in the database.
I deleted another page and discovered that the numbers are corresponding to the number of the page I am deleting and the three previous (ie all) autosaved revisions.
I tried again with a test page, got the same error, but noticed an additional error at the bottom (this was possibly in the others and I missed it)
Warning: Cannot modify header information – headers already sent by (output started at /home/alter871/public_html/wp-includes/wp-db.php:517) in /home/alter871/public_html/wp-includes/pluggable.php on line 850
Now have found lots of entries for this error and am working my way thru them.
(Deleting rogue spaces at the start or end of the files mentioned.)
Don’t want to get flamed for conducting an insufficient search
Now the world can see my thought process at work……
I fiddled around with all of those file to no avail.
Then I decided to unload all of the plugins and the error went away.
I loaded the plugins again and the error came back.
By removing the plugins one at a time it turned out to be the Broken-Link-Checker plugin that was causing the problem. This is not a 100% satisfactory answer though because another of my sites uses this plugin without error.