Unknown Colum ‘p.ID’

  • 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?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter innerbrat

    (@innerbrat)

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

    Thread Starter innerbrat

    (@innerbrat)

    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?

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

    Thread Starter innerbrat

    (@innerbrat)

    Tried searching for that before I posted ?? but with no success.

    Thread Starter innerbrat

    (@innerbrat)

    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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Unknown Colum ‘p.ID’’ is closed to new replies.