Support » Fixing WordPress » Commenter url incorrect and posts skip numbers

  • When I post a comment to my blog, the url that my username links to sometimes shows up as just http:/// (with three slashes) even though I know I entered the correct url. I don’t mind when it happens to me because I can edit it, but I don’t want it to happen to readers of my blog.

    Also, my posts are not sequentially numbered. Some numbers are skipped, and if I try to view a post that would correspond to one of the numbers that are not used, I get this error message:

    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 ‘ORDER BY post_date ASC LIMIT 1’ at line 1]
    SELECT ID, post_title FROM wp_posts WHERE post_date > ” AND post_type = ‘post’ AND post_status = ‘publish’ AND ID != ORDER BY post_date ASC LIMIT 1

    I used Fantastico to install WordPress, and I haven’t touched the database.

    Should I just not worry about it or will this cause problems down the line? If I just reinstall WordPress will I lose the posts and comments that have been posted so far? (My blog is less than a month old so I’d rather do it now if I have to.)

Viewing 2 replies - 1 through 2 (of 2 total)
  • Yes, re-installing means losing all your previous data.

    Isn’t possible you don’t remember correctly about the empty URL? Some themes/versions do that: put only http:// when the field is left empty.

    As for the post ID numbers – forget it. Who cares about them? (if you delete a post, that number is skipped, if you have a Page, that also takes a “number” etc.)

    I won’t worry about the posts skipping numbers, but the commenter url keeps on not appearing. It does sometimes but not others. Also, someone has told me they tried commenting and were unable to comment altogether.

    There are several errors on my site but I don’t know how to fix them. None seem to have anything to do with comments though.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Commenter url incorrect and posts skip numbers’ is closed to new replies.