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

Home » FUDforum Development » Bug Reports » upgrade 2.6.4 rdf.php fails
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
upgrade 2.6.4 rdf.php fails [message #19360] Tue, 13 July 2004 22:50 Go to next message
hemna is currently offline  hemna   United States
Messages: 10
Registered: October 2002
Location: Pilot Hill, CA
Karma: 0
Junior Member

I just recently upgraded to 2.6.4 and now my rdf.php feed is not working. I get the following error

[Tue Jul 13 15:45:53 2004] [error] PHP Fatal error:  SQL Error has occurred, please contact the 
<a href="mailto:waboring(at)buildabetterweb(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in 
/mnt/apache/htdocs/phphtmllib.newsblob.com/html/forums/rdf.php on line 63

[Updated on: Tue, 13 July 2004 22:51]

Report message to a moderator

Re: upgrade 2.6.4 rdf.php fails [message #19362 is a reply to message #19360] Tue, 13 July 2004 23:02 Go to previous messageGo to next message
hemna is currently offline  hemna   United States
Messages: 10
Registered: October 2002
Location: Pilot Hill, CA
Karma: 0
Junior Member

Here is the error I get in the error log view from the control panel

(/mnt/apache/htdocs/phphtmllib.newsblob.com/html/forums/rdf.php:135
/mnt/apache/htdocs/phphtmllib.newsblob.com/html/forums/rdf.php:424
) 1064: You have an error in your SQL syntax near '' at line 21
Query: SELECT m.*, u.alias, t.forum_id, p.name AS poll_name, p.total_votes, m2.subject AS th_subject, m3.subject AS reply_subject, f.name AS frm_name, c.name AS cat_name FROM fud23_msg m INNER JOIN fud23_thread t ON m.thread_id=t.id INNER JOIN fud23_forum f ON t.forum_id=f.id INNER JOIN fud23_cat c ON c.id=f.cat_id INNER JOIN fud23_msg m2 ON t.root_msg_id=m2.id LEFT JOIN fud23_msg m3 ON m3.id=m.reply_to LEFT JOIN fud23_users u ON m.poster_id=u.id LEFT JOIN fud23_poll p ON m.poll_id=p.id WHERE t.moved_to=0 AND m.apr=1 AND m.post_stamp >=1089673281 ORDER BY m.post_stamp DESC LIMIT 0,
Server Version: 3.23.56
Re: upgrade 2.6.4 rdf.php fails [message #19365 is a reply to message #19362] Wed, 14 July 2004 02:44 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
You need to check your RDF settings and make sure you have a max limit set.

FUDforum Core Developer
Re: upgrade 2.6.4 rdf.php fails [message #19384 is a reply to message #19360] Wed, 14 July 2004 17:35 Go to previous message
hemna is currently offline  hemna   United States
Messages: 10
Registered: October 2002
Location: Pilot Hill, CA
Karma: 0
Junior Member

kewl that was it, thanks Smile
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Duplicate key violates unique constraint ...
Next Topic: registration email issues
Goto Forum:
  

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

Current Time: Wed Nov 27 13:40:46 GMT 2024

Total time taken to generate the page: 0.02537 seconds