• I’ve been running WordPress for several years on tons of sites, and this problem just showed up after I installed some more plugins on one of my bigger sites (1700+ posts, 18K comments). When a new comment is posted (whether I’m logged in or not), I get:

    WordPress database error: [Unknown column 'ID' in 'where clause']
    SELECT * FROM wp_comments WHERE ID = '18686'

    WordPress database error: [Unknown column 'ID' in 'where clause']
    UPDATE wp_comments SET comment_content = '' WHERE ID = '18686'

    In this case, 18686 is the comment ID.

    The comment is posted successfully if you hit back and refresh the page, so I don’t know what this error is referring to.

    Any ideas? I’m using these plugins:
    Ultimate Tag Warrior
    CG-Amazon
    LMB^Box Comment Quicktags
    Never Moderate Admin or Post Author
    Recent Comments
    Recent Posts
    RunPHP
    Scripturizer Remix
    Spam Karma 2 – Reloaded

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter justinbaeder

    (@justinbaeder)

    Also, I’m running WP 1.5.2, php4.3.10-2.4, and MySQL 3.23.58-16.FC2.1

    d0ngle

    (@d0ngle)

    Scripturizer Remix causes this. I’m not sure how, but it does.

    Thread Starter justinbaeder

    (@justinbaeder)

    Thank you, d0ngle! That’s it exactly – I deactivated the plugin, and the error is gone.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Comment posting error: Unknown column ‘ID’ in ‘where clause’’ is closed to new replies.