Welcome Guest ( Log In | Register ) Resend Validation Email


  Reply to this topicStart new topicStart Poll

Thread Rating: 0 votes, 0.00 average.  Rate:  
  • Thread Rating: 0 votes, 0.00 average.  Rate:  
  • 1
  • 2
  • 3
  • 4
  • 5
> Issue while gathering new posts
GT3 RS
Posted: Jul 16 2012, 09:48 PM
Quote Post


WME King Cat
**********

Group: Core Members
Posts: 5,050
Member No.: 5,053
Joined: Apr 16th 2009
Location: DFW





Am I the only one getting this? It only does it when I click the "View New Posts" option. I can browse the forums just fine when I don't click the new posts option. The refresh button on this screen doesn't work.
(IMG:http://i50.tinypic.com/k239f.jpg)

Full text.

CODE
mySQL query error: SELECT DISTINCT(p.author_id) AS author_id, t.*, f.id AS forum_id, f.name AS forum_name
       FROM ibf_topics t
         LEFT JOIN ibf_forums f ON (f.id = t.forum_id)
         LEFT JOIN ibf_posts p ON (t.tid = p.topic_id AND p.author_id = '5053')
       WHERE t.tid IN(0,,0)
       ORDER BY t.pinned DESC, t.last_post desc
       LIMIT 0,25

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0)
       ORDER BY t.pinned DESC, t.last_post desc
       LIMIT 0,25' at line 5
mySQL error code:
Date: Monday 16th 2012f July 2012 10:47:32 PM
PM
Top
E86
Posted: Jul 16 2012, 11:47 PM
Quote Post


Lead Administrator
Group Icon

Group: ADMINISTRATOR
Posts: 587
Member No.: 2
Joined: Dec 22nd 2006
Location: San Leandro, CA





Thank you for reporting that, GT3!

The error has now been fixed. Please let me know if you see any other similar errors. :)
PMEmail PosterUsers Website
Top
GT3 RS
Posted: Jul 17 2012, 07:45 PM
Quote Post


WME King Cat
**********

Group: Core Members
Posts: 5,050
Member No.: 5,053
Joined: Apr 16th 2009
Location: DFW





No problem. Funny thing was, after I posted it, the new posts option worked, and this thread showed up in the new posts. However, when I marked the forums as read and tried again, that screen would come up.
PM
Top
E86
Posted: Jul 17 2012, 11:02 PM
Quote Post


Lead Administrator
Group Icon

Group: ADMINISTRATOR
Posts: 587
Member No.: 2
Joined: Dec 22nd 2006
Location: San Leandro, CA





That error only came up when there were no new posts. Rest assured, it's fixed now. :D
PMEmail PosterUsers Website
Top

Topic Options  Reply to this topicStart new topicStart Poll