WordPress.org

Ready to get started?Download WordPress

Forums

Unknown Colum 'p.ID' (6 posts)

  1. innerbrat
    Member
    Posted 6 years ago #

    I am using WP 2.2 as 2.3 does not currently work on my mySQL database.

    Every single blog entry page gives an error message along the lines:

    WordPress database error: [Unknown column 'p.ID' in 'IN/ALL/ANY subquery']
    SELECT ID, post_title FROM wp_posts WHERE post_date < '2008-02-21 21:29:06' AND post_type = 'post' AND post_status = 'publish' AND p.ID NOT IN (SELECT postID FROM wp_gigs_gig) ORDER BY post_date DESC LIMIT 1

    I have absolutely no knowledge of mySQL at all and don't know how to begin understanding this error message. Any help?

  2. innerbrat
    Member
    Posted 6 years ago #

    Anyone? Even just a pointer to where I need to be looking tio fix this?

  3. innerbrat
    Member
    Posted 6 years ago #

    I'm still desperately trying to figure out what it is causing this error message. If I need to supply more information, can someone at least tell me which information I should be supplying?

  4. moshu
    Member
    Posted 6 years ago #

    See if searching the forums for "p.ID" brings up any results

  5. innerbrat
    Member
    Posted 6 years ago #

    Tried searching for that before I posted :-) but with no success.

  6. innerbrat
    Member
    Posted 6 years ago #

    Chatting elsewhere, as the problem appears to be with the 'next' and 'previous' post links, so I have commented out that part of single.php.

    However, as I'd like to actually fix whatever the function is that's causing this crash, if anyone can help, I'm not marking the topic as resolved.

Topic Closed

This topic has been closed to new replies.

About this Topic