Layer7 API Management

Expand all | Collapse all

Developer Portal - Forum Query Error

Jump to Best Answer
  • 1.  Developer Portal - Forum Query Error

    Posted 10-17-2016 10:16 AM

    Context - API Gateway (v9.1) and Portal (v3.5) images within AWS with RDS.

     

    Forum Admin Control Panel.

     

    When the Message Approving link is clicked... An error is thrown with the following message...

    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'f.forum_id' in 'on clause'

     

    The query that is being executed is...

     

    SELECT c.categories_id, c.title, f.forum_id, n.forum_name, COUNT(p.post_id) AS total
    FROM jforum_categories c, jforum_forums f, jforum_posts p
    JOIN jforum_forum_names n on n.forum_id = f.forum_id and n.lang = 'en'
    WHERE p.need_moderate = 1 AND p.forum_id = f.forum_id AND f.categories_id = c.categories_id
    GROUP BY c.categories_id, c.title, f.forum_id, n.forum_name

     

    if I change this query to include parenthesis around the "FROM" statement it works...

     

    SELECT c.categories_id, c.title, f.forum_id, n.forum_name, COUNT(p.post_id) AS total
    FROM (jforum_categories c, jforum_forums f, jforum_posts p)
    JOIN jforum_forum_names n on n.forum_id = f.forum_id and n.lang = 'en'
    WHERE p.need_moderate = 1 AND p.forum_id = f.forum_id AND f.categories_id = c.categories_id
    GROUP BY c.categories_id, c.title, f.forum_id, n.forum_name

     

    Is this a BUG?  How/Where can I update this query?



  • 2.  Re: Developer Portal - Forum Query Error
    Best Answer

    Posted 10-17-2016 06:20 PM

    This is a known problem (DE231429) will be fixed at 3.5 CR3