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


Messages In This Thread
Groups 'Today's Posts' link - by Mark4211 - 06 June 2012, 12:20 PM
RE: Groups 'Today's Posts' link - by Flip - 08 June 2012, 01:23 AM
RE: Groups 'Today's Posts' link - by C651 Lover - 08 June 2012, 08:11 AM
RE: Groups 'Today's Posts' link - by Rudolph - 08 June 2012, 08:47 AM
RE: Groups 'Today's Posts' link - by C651 Lover - 08 June 2012, 08:53 AM
RE: Groups 'Today's Posts' link - by SMB157S - 10 June 2012, 09:11 PM
RE: Groups 'Today's Posts' link - by Mark4211 - 13 June 2012, 12:46 PM
RE: Groups 'Today's Posts' link - by SMB157S - 17 June 2012, 08:17 PM
RE: Groups 'Today's Posts' link - by Mark4211 - 17 June 2012, 08:34 PM

Possibly Related Threads...
Thread Author Replies Views Last Post
  [Suggestion] Embedding Google Docs into Posts Ethan777 1 2,783 08 February 2015, 10:04 PM
Last Post: nakanoben
  [Bug] Directed to Random Malicious Websites When Clicking 'View New Posts' habiTAT 77 51,605 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,727 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)