[sr #110825] All forum posts show a database error message at the end

[Bruno Haible]

URL:
  <https://savannah.nongnu.org/support/?110825>

                 Summary: All forum posts show a database error message at the
end
                 Project: Savannah Administration
               Submitter: haible
               Submitted: Fri 27 Jan 2023 12:49:40 PM CET
                Category: Savannah website
                Priority: 5 - Normal
                Severity: 3 - Normal
                  Status: None
             Assigned to: None
        Originator Email: 
        Operating System: None
             Open/Closed: Open
         Discussion Lock: Any


    _______________________________________________________

Follow-up Comments:


-------------------------------------------------------
Date: Fri 27 Jan 2023 12:49:40 PM CET By: Bruno Haible <haible>
At the end of forums posts, such as
https://savannah.gnu.org/forum/forum.php?forum_id=10255
or
https://savannah.gnu.org/forum/forum.php?forum_id=10287
a database error is shown:

db_query: SQL query error in [ SELECT u.user_name, u.realname,
f.has_followups, u.user_id, f.msg_id, f.group_forum_id, f.subject,
f.thread_id, f.body, f.date, f.is_followup_to, g.group_id FROM forum f, user
u, forum_group_list g WHERE f.group_forum_id = '10255' AND user.user_id =
forum.posted_by AND forum.is_followup_to = 0 AND g.group_forum_id =
f.group_forum_id ORDER BY forum.date DESC LIMIT 0, 26] Unknown column
'user.user_id' in 'where clause'


Indeed it is invalid SQL. In the WHERE clause, the part

user.user_id = forum.posted_by AND forum.is_followup_to = 0

should be replaced with

u.user_id = f.posted_by AND f.is_followup_to = 0









    _______________________________________________________

Reply to this item at:

  <https://savannah.nongnu.org/support/?110825>

_______________________________________________
Message sent via Savannah
https://savannah.nongnu.org/