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.
user posted image

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. smile.gif
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. biggrin.gif
PMEmail PosterUsers Website
Top

Topic Options  Reply to this topicStart new topicStart Poll