FUDforum: FUDforum 3.0+ » Error Message

Home » FUDforum Development » FUDforum 3.0+ » Error Message

Show: Today's Messages :: Polls :: Message Navigator

Error Message [message #3371]

Wed, 19 June 2002 22:37

heidiott

Messages: 34
Registered: May 2002

Karma: 0

Member

I'm getting an error message when replying to posts on Today's posts. It only seems to happen on pages 2+ of Today's Posts. When I click on the reply button I get the error I have pasted below. I have not made any modifications to the script. Can you help me fix this problem?
Thank you,
Heidi

--------------------------------------
Error in function/script: db.inc
has caused the following error: query failed: %( SELECT HIGH_PRIORITY
fud_msg.*,
fud_thread.locked,
fud_thread.root_msg_id,
fud_thread.last_post_id,
fud_thread.forum_id,
fud_users.id AS user_id,
fud_users.login,
fud_users.invisible_mode,
fud_users.posted_msg_count,
fud_users.join_date,
fud_users.last_visit AS time_sec
FROM
fud_msg
INNER JOIN fud_thread
ON fud_msg.thread_id=fud_thread.id
LEFT JOIN fud_users
ON fud_msg.poster_id=fud_users.id
WHERE
fud_msg.id IN)
ORDER BY id ASC )% because %( You have an error in your SQL syntax near ')
ORDER BY id ASC' at line 20 )%
while processing script name: /home/sites/www.crafterscommunity.net/web/forum/post.php
the error occured at: 19/06/2002 22:10:39 GMT
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
User Ip: 68.83.20.162
Script Accessed: /home/sites/www.crafterscommunity.net/web/forum/post.php

Query Failed: SELECT HIGH_PRIORITY fud_msg.*, fud_thread.locked, fud_thread.root_msg_id, fud_thread.last_post_id, fud_thread.forum_id, fud_users.id AS user_id, fud_users.login, fud_users.invisible_mode, fud_users.posted_msg_count, fud_users.join_date, fud_users.last_visit AS time_sec FROM fud_msg INNER JOIN fud_thread ON fud_msg.thread_id=fud_thread.id LEFT JOIN fud_users ON fud_msg.poster_id=fud_users.id WHERE fud_msg.id IN) ORDER BY id ASC
Reason: You have an error in your SQL syntax near ') ORDER BY id ASC' at line 20
From: /home/sites/www.crafterscommunity.net/web/forum/post.php
Server Version: 3.23.48

Report message to a moderator

Re: Error Message [message #3372 is a reply to message #3371]

Wed, 19 June 2002 22:39

heidiott

Messages: 34
Registered: May 2002

Karma: 0

Member

Also, this only seems to happen in Today's Posts. If you go to the post throught the forums instead of Today's Posts and reply the error doesn't occur.
Heidi

Report message to a moderator

Re: Error Message [message #3374 is a reply to message #3372]

Thu, 20 June 2002 01:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I cannot seem to replicate this problem on FUDforum 2.1, however I see what it 'could' happen. Let me look over the source code to see why it could happen.

I actually I had just visited www.crafterscommunity.net forum, which is running FUDforum 2.0.2, it had 3 pages of Today's Posts for me. After browsing those 3 pages extensively not once did I get a query failure.

Are any other options besides Today's Posts turned on when this bug is happening?

FUDforum Core Developer

[Updated on: Thu, 20 June 2002 01:17]

Report message to a moderator