SGTrains Forums
[Bug] Groups 'Today's Posts' link - Printable Version

+- SGTrains Forums (http://forums.sgtrains.com)
+-- Forum: Official Forums (http://forums.sgtrains.com/forumdisplay.php?fid=1)
+--- Forum: Welcome to SGTrains (http://forums.sgtrains.com/forumdisplay.php?fid=2)
+---- Forum: Help Center/Bug Reports/Suggestions (http://forums.sgtrains.com/forumdisplay.php?fid=30)
+---- Thread: [Bug] Groups 'Today's Posts' link (/showthread.php?tid=1707)



Groups 'Today's Posts' link - Mark4211 - 06 June 2012

At http://forums.sgtrains.com/groups.php
Clicking 'Today's Posts' will lead you to a myBB SQL error.
'MyBB has experienced an internal SQL error and cannot continue.'

SQL Error:
1064 - 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 '2,0,3,11,0,12) AND p.time>='1338869958' AND p.approved='1' AND c.approved='1' ' at line 7
Query:
SELECT p.*, c.*, g.*, u.*, ug.* FROM mybb_sgposts p LEFT JOIN mybb_sgconversations c ON (p.conid=c.conid) LEFT JOIN mybb_socialgroups g ON (c.sgid=g.sgid) LEFT JOIN mybb_users u ON (p.uid=u.uid) LEFT JOIN mybb_usergroups ug ON (u.displaygroup=ug.gid) WHERE g.sgid IN(,2,0,3,11,0,12) AND p.time>='1338869958' AND p.approved='1' AND c.approved='1' ORDER BY p.time DESC


RE: Groups 'Today's Posts' link - Flip - 08 June 2012

Hi, it seems like it's working well for me (as of today), no errors or whatsoever. Could you try again and revert back?
Thanks!


RE: Groups 'Today's Posts' link - C651 Lover - 08 June 2012

Looks like I got the same thing! :\


RE: Groups 'Today's Posts' link - Rudolph - 08 June 2012

Cannot reproduce error here for me. Am using Chrome.


RE: Groups 'Today's Posts' link - C651 Lover - 08 June 2012

(08 June 2012, 08:47 AM)9V-STS Wrote:   Show/Hide

I using Chrome too wor :\


RE: Groups 'Today's Posts' link - SMB157S - 10 June 2012

Erm... error reproduced.

O.O

Firefox user here


RE: Groups 'Today's Posts' link - Mark4211 - 13 June 2012

It still produced an error for me.
http://forums.sgtrains.com/groups.php?action=todayposts

Using:
Google Chrome 19.0.1084.56 (Official Build 140965) m
OS Windows
WebKit 536.5 (@119244)
JavaScript V8 3.9.24.29
Flash 11,3,300,257
User Agent Mozilla/5.0 (Windows NT 6.0) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.56 Safari/536.5


RE: Groups 'Today's Posts' link - SMB157S - 17 June 2012

Strangely, it now works for me. Is it due to some issue that makes it such that staff members don't find any problem?



RE: Groups 'Today's Posts' link - Mark4211 - 17 June 2012

I'm still seeing it...