Query problem in get_adjacent_post
-
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?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Query problem in get_adjacent_post’ is closed to new replies.