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/
