FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » Error Message
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Error Message [message #3371] Wed, 19 June 2002 18:37 Go to next message
heidiott is currently offline  heidiott   United States
Messages: 34
Registered: May 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
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
Re: Error Message [message #3372 is a reply to message #3371] Wed, 19 June 2002 18:39 Go to previous messageGo to next message
heidiott is currently offline  heidiott   United States
Messages: 34
Registered: May 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
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
Re: Error Message [message #3374 is a reply to message #3372] Wed, 19 June 2002 21:14 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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: Wed, 19 June 2002 21:17]

Report message to a moderator

Re: Error Message [message #3375 is a reply to message #3374] Wed, 19 June 2002 21:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Ok never mind, I see the bug... I just didn't follow the whole process needed to replicate the bug heh...

FUDforum Core Developer
Re: Error Message [message #3376 is a reply to message #3375] Wed, 19 June 2002 22:40 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Fixed in latest CVS (4.1.0) tree.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Need help with groups
Next Topic: One change that might make it easier for newbies
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 21 13:54:19 EDT 2017

Total time taken to generate the page: 0.00587 seconds