Support » Fixing WordPress » Error, I think this is a BUG

  • Resolved minimo

    (@minimo)


    Hi, first sorry by my bad english.

    For some days ago I am receiving an error in the log of my blog. This is the error:

    [22-Jan-2008 13:11:34] 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 ‘AND comment_approved = ‘1’ ORDER BY comment_date_gmt DESC LIMIT 10′ at line 1 for query SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = AND comment_approved = ‘1’ ORDER BY comment_date_gmt DESC LIMIT 10

    Tresting and testing to discover what happens, activating, deactivating plugins, etc… I discovered the error appears when I add feed to the pagination, for example

    / page / number / feed

    I put spaces to be able to publish the message.

    Finally I installed a new blog for make test with a new database and none plugin activated

    www . pruebas . minimalnet . org / page / 2 / feed

    My surprise has been big when I have seen again the same problem, for this reason I think this must be a bug of wordpress.

    I am using 2.3.2 version of the software, if somebody can replay to me I will be happy.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    You should not attempt to append /feed to other pages like that, that’s not a valid request. You can add /feed onto *most* URL’s and it’ll work, but it will not work on all of them.

    I admit that it is a problem that it shows the resulting SQL query, but it’s a known issue.

    See these for more info:
    http://trac.wordpress.org/ticket/5185
    http://trac.wordpress.org/ticket/5471
    http://trac.wordpress.org/ticket/5473

    Thread Starter minimo

    (@minimo)

    Hi Otto42, thanks for answer but I do not understand fine, the tickets information are too much complicated for my knowledge, totally amateur.

    Do you say that this is normal in wordpress?, then have not I to of worrying?.

    I want say that this error appears before I know how “provoke” it. I think will be some user then?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    I’m saying that it is a known problem and it is being worked on. You don’t have to worry about it. Just don’t use that URL.

    Thread Starter minimo

    (@minimo)

    Ok thanks, but every days I have this error in my log, why some user is using this URLs?.

    Is dangerous or bad for the database that somebody use this url?, I cannot control that.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    No, it’s not particularly dangerous or anything. Could be mildly annoying, I suppose.

    Thread Starter minimo

    (@minimo)

    Ok, thank you very much, finally I can be relaxed 😀

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error, I think this is a BUG’ is closed to new replies.