default install gives sql/headers error on comment

  • 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 comment_author_email = ” ORDER BY comment_date DESC LIMI]
    SELECT comment_date FROM WHERE comment_author_email = ” ORDER BY comment_date DESC LIMIT 1
    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 comment_author_url = ‘https://jael.bluewire.net.nz’ ORDER ]
    SELECT comment_date FROM WHERE comment_author_url = ‘https://jael.bluewire.net.nz’ ORDER BY comment_date DESC LIMIT 1
    Warning: Cannot modify header information – headers already sent by (output started at /home/hosted/kani/jael.bluewire.net.nz/public_html/wp-includes/wp-db.php:80) in /home/hosted/kani/jael.bluewire.net.nz/public_html/wp-comments-post.php on line 89
    This happens when you click submit and post a new comment. The comment is posted fine, but you get this mess instead of being sent back to the comments list.
    I am using a default 1.2.1 installation with a slightly-modified index.php and wp-comments.php. I’ve never touched wp-db.php or wp-comments-post.php (or indeed any files except wp-config.php, index.php and comments.php). There is no extra whitespace in vars.php.
    Can anyone see the problem?

Viewing 9 replies - 1 through 9 (of 9 total)
  • estara

    (@estara)

    Hmm, something similar happens to me but I use 1.3 alpha-2, and I have tried to fiddle with some Post plugins, mainly Alex Kings Last Visit. However, I uploaded original files from the installation when that only got me major errors and then implemented Recent Comments by MTDewvirus.
    Like you said, you get an error and then you can still read the comment afterwards. My error looks a bit different though.
    Quote:
    `Warning: Unknown modifier ‘C’ in /www/htdocs/marhaba/wp-includes/functions.php on line 1415′
    (Repeat errors)
    Are some of our permissions wrong? I have never touched functions.php though…

    Thread Starter Anonymous

    Running upgrade.php returns:

    Fatal error: Cannot redeclare maybe_add_column() (previously declared in /home/hosted/kani/jael.bluewire.net.nz/public_html/wp-content/plugins/subscribe-to-comments.php:252) in /home/hosted/kani/jael.bluewire.net.nz/public_html/wp-admin/upgrade-functions.php on line 56

    :\

    estara

    (@estara)

    Podz, I love you. That was exactly what was wrong:
    https://www.bookish.net/archives/2004/11/06/an-ode-to-worpress-support
    I can’t even spell ; ;

    @kani – deactivate that plugin, then run the upgrade ?
    @estara – I’m blushing ??

    Thread Starter Anonymous

    podz: I disabled the plugin, ran upgrade.php again, and it still gives the same errors when you post a new comment ??

    Thread Starter Anonymous

    *bump*
    still not fixed, need ideas please ??

    Is your blog new to wp ? I ask because of the archives, and I’m wondering if you have recently installed a plugin that could have caused this ?

    Thread Starter Anonymous

    No. I was using some older version of wordpress (0.71?), and finally upgraded last week.

    Thread Starter Anonymous

    I’ve fixed it. I found the erroneous SQL statements in two plugins; Charles Gagalac’s Flood Protection by email and Flood Protection by URL. Thanks for your help podz! ??

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘default install gives sql/headers error on comment’ is closed to new replies.