- 
    Bug 
- 
    Resolution: Fixed
- 
    Major 
- 
    3.0.7
- 
    None
- 
    PHP Environment:
 Database: PostgreSQL 8.3.9
Postgres returns error when a feed is open:
ERROR:  invalid reference to FROM-clause entry for table "p" at character 285
HINT:  There is an entry for table "p", but it cannot be referenced from this part of the query.
STATEMENT:  SELECT f.forum_id, f.forum_name, p.post_id, p.topic_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield,
p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, u.username, u.user_id FROM phpbb_posts p, phpbb_users u
LEFT JOIN phpbb_forums f ON (f.forum_id = p.forum_id) WHERE p.topic_id IN (3666, 3832, 3830, 1655, 3587, 3828, 2876, 3815,
3829, 367, 3761, 3827, 3826, 3175, 3451, 3632, 3822, 3823, 3597, 3824)
AND (p.post_approved = 1
OR p.forum_id IN (2, 3, 4, 6, 7, 8, 10, 11, 14, 15, 16, 17, 18, 23, 24))
AND p.post_time >= 1266952354
AND u.user_id = p.poster_id ORDER BY p.post_time DESC
LIMIT 20 OFFSET 0
Switching the two tables in the FROM part did the trick:
— feed-old.php        2010-03-03 23:49:23.637834100 +0100
+++ feed.php    2010-03-03 23:49:30.523762619 +0100
@@ -783,8 +783,8 @@
                                                        'p.post_id, p.topic_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .
                                                        'u.username, u.user_id',
                        'FROM'          => array(
- POSTS_TABLE             => 'p',
 USERS_TABLE => 'u',
 + POSTS_TABLE => 'p',
 ),
 'LEFT_JOIN' => array(
 array(
- is duplicated by
- 
                    PHPBB-9569 General Error in board-wide feed with PostgreSQL (+patch) -         
- Closed
 
-         

