Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Bug] Groups 'Today's Posts' link
#1
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
Mark4211
Hi there! I am a railway technology enthusiast.

North South Line for openBVE [NB: MSP - BSH]
Reply
#2
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!
- Flip
/人◕ ‿‿ ◕人\
Reply
#3
Looks like I got the same thing! :\
C651 Lover | A SGTrains Member


Station Rep: NS2 Bukit Batok

Reply
#4
Cannot reproduce error here for me. Am using Chrome.
[Image: sognature_edited-1.jpg]
Reply
#5
(08 June 2012, 08:47 AM)9V-STS Wrote:   Show/Hide

I using Chrome too wor :\
C651 Lover | A SGTrains Member


Station Rep: NS2 Bukit Batok

Reply
#6
Erm... error reproduced.

O.O

Firefox user here
-SMB157S

BEEP. THIS IS MAGNEMITE, YOUR LOCAL FORUM OVERLORD. FAILURE TO COMPLY WITH RULES MAY RESULT IN A BAN FROM THE FORUMS. BEEP.

★chinese new year: im a magnemite

★EREEN: ****

★EREEN: pokemon control pokemon

★chinese new year: i have magnet pull

★chinese new year: these klefkis are my slaves
Reply
#7
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
Mark4211
Hi there! I am a railway technology enthusiast.

North South Line for openBVE [NB: MSP - BSH]
Reply
#8
Strangely, it now works for me. Is it due to some issue that makes it such that staff members don't find any problem?
-SMB157S

BEEP. THIS IS MAGNEMITE, YOUR LOCAL FORUM OVERLORD. FAILURE TO COMPLY WITH RULES MAY RESULT IN A BAN FROM THE FORUMS. BEEP.

★chinese new year: im a magnemite

★EREEN: ****

★EREEN: pokemon control pokemon

★chinese new year: i have magnet pull

★chinese new year: these klefkis are my slaves
Reply
#9
I'm still seeing it...
Mark4211
Hi there! I am a railway technology enthusiast.

North South Line for openBVE [NB: MSP - BSH]
[-] The following 1 user Likes Mark4211's post:
  • gs97
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  [Suggestion] Embedding Google Docs into Posts Ethan777 1 2,782 08 February 2015, 10:04 PM
Last Post: nakanoben
  [Bug] Directed to Random Malicious Websites When Clicking 'View New Posts' habiTAT 77 51,604 18 November 2013, 04:53 AM
Last Post: Mark4211
  [Bug] Why is the Mobile Version link not there anymore? SMB323D 7 4,026 20 November 2012, 11:41 PM
Last Post: nakanoben
  [Suggestion] Increase Image Limit in Posts Ethan777 15 9,726 09 January 2012, 02:15 PM
Last Post: SMB145B
  [Suggestion] Open the forum link in the same tab in the countdown page SBS7322B 3 3,231 28 September 2011, 08:54 PM
Last Post: SBS7322B
  Disable post counts located above user's posts. joeyfjj 6 4,641 05 July 2011, 04:01 PM
Last Post: boylush
  Not found link bug. Mark4211 1 2,249 13 March 2011, 04:31 PM
Last Post: joeyfjj

Forum Jump:


Users browsing this thread: 1 Guest(s)