WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Query problem in get_adjacent_post (2 posts)

  1. Sir-Uli
    Member
    Posted 6 years ago #

    I am running WordPress 2.5 (Database-Prefix: wu_) (Theme K2 SVN-669) on PHP 5.2.6-rc2 with mod_fcgid on Gentoo.

    When i call WordPress as a User (when logged in), i get the following errors in my apache-log-files:

    [Sat Apr 19 16:50:14 2008] [warn] mod_fcgid: stderr: 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 'p  WHERE p.post_date < '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu' at line 1 for query SELECT p.* FROM (wu_posts LEFT JOIN wu_postmeta as pl_wu_postmeta ON (wu_posts.ID = pl_wu_postmeta.post_id)) AS p  WHERE p.post_date < '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu_posts.post_status = 'publish' OR (wu_posts.post_status = 'private' AND (pl_wu_postmeta.meta_key = 'post_level' AND pl_wu_postmeta.meta_value <= 0 )))  ORDER BY p.post_date DESC LIMIT 1 made by get_adjacent_post
    [Sat Apr 19 16:50:14 2008] [warn] mod_fcgid: stderr: 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 'p  WHERE p.post_date > '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu' at line 1 for query SELECT p.* FROM (wu_posts LEFT JOIN wu_postmeta as pl_wu_postmeta ON (wu_posts.ID = pl_wu_postmeta.post_id)) AS p  WHERE p.post_date > '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu_posts.post_status = 'publish' OR (wu_posts.post_status = 'private' AND (pl_wu_postmeta.meta_key = 'post_level' AND pl_wu_postmeta.meta_value <= 0 )))  ORDER BY p.post_date ASC LIMIT 1 made by get_adjacent_post
    [Sat Apr 19 16:50:14 2008] [warn] mod_fcgid: stderr: 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 'p  WHERE p.post_date < '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu' at line 1 for query SELECT p.* FROM (wu_posts LEFT JOIN wu_postmeta as pl_wu_postmeta ON (wu_posts.ID = pl_wu_postmeta.post_id)) AS p  WHERE p.post_date < '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu_posts.post_status = 'publish' OR (wu_posts.post_status = 'private' AND (pl_wu_postmeta.meta_key = 'post_level' AND pl_wu_postmeta.meta_value <= 0 )))  ORDER BY p.post_date DESC LIMIT 1 made by get_adjacent_post
    [Sat Apr 19 16:50:14 2008] [warn] mod_fcgid: stderr: 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 'p  WHERE p.post_date > '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu' at line 1 for query SELECT p.* FROM (wu_posts LEFT JOIN wu_postmeta as pl_wu_postmeta ON (wu_posts.ID = pl_wu_postmeta.post_id)) AS p  WHERE p.post_date > '2008-04-19 15:01:09' AND p.post_type = 'post' AND p. (wu_posts.post_status = 'publish' OR (wu_posts.post_status = 'private' AND (pl_wu_pos
    [Sat Apr 19 16:50:14 2008] [warn] mod_fcgid: stderr: tmeta.meta_key = 'post_level' AND pl_wu_postmeta.meta_value <= 0 )))  ORDER BY p.post_date ASC LIMIT 1 made by get_adjacent_post

    I found some other Hints, but none helped to fix this Problem. I ran the Query in phpMyAdmin and it failed with the following message:
    /* SQL 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 'p WHERE t_t.taxonomy ='post_tag' AND t_t.term_taxonomy */

    Any chance to solve this?

  2. Sir-Uli
    Member
    Posted 6 years ago #

    post_level-Plugin was the Problem.

Topic Closed

This topic has been closed to new replies.

About this Topic