betobeto

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter betobeto

    (@betobeto)

    No one has a clue or a “tried and true” solution to this?

    Hi all,

    I’ve been using a customized version of the Yet Another Photoblog plugin, which has also been hit by the 2.3 post2cat gotcha. The author’s forum is regrettably having problems at this moment so I’m giving this place a try. ??

    As part of my customizations I’ve got a Query variable that looks like this (and I’m sure is what is causing the choking at this time):

    $query = "SELECT p.* FROM $wpdb->post2cat p2c LEFT JOIN $wpdb->posts p ON p2c.post_id = p.ID WHERE p2c.category_id = $categoryId AND p.post_status = 'publish' ORDER BY post_date DESC" . $limit;

    Since I don’t speak MySQL :P, how should this string be built so I can stop getting the “table not found” message?

    Thanks in advance for any help.

Viewing 2 replies - 1 through 2 (of 2 total)