SGTrains Forums

Full Version: Groups 'Today's Posts' link
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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!
Looks like I got the same thing! :\
Cannot reproduce error here for me. Am using Chrome.
(08 June 2012, 08:47 AM)9V-STS Wrote: [ -> ]Cannot reproduce error here for me. Am using Chrome.

I using Chrome too wor :\
Erm... error reproduced.

O.O

Firefox user here
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
Strangely, it now works for me. Is it due to some issue that makes it such that staff members don't find any problem?
I'm still seeing it...