+- The UK Babe Channels Forum (https://www.babeshows.co.uk)
+-- Forum: General (/forumdisplay.php?fid=19)
+--- Forum: Information On This Website & Help (/forumdisplay.php?fid=103)
+---- Forum: Forum Help & Advice (/forumdisplay.php?fid=91)
+---- Thread: Slow Board & "MyBB SQL Errors" (/showthread.php?tid=15660)
RE: Slow Board & "MyBB SQL Errors" - simplymarko - 12-01-2011 22:19
when clicking to view a profile:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
5 - Out of memory (Needed 5241216 bytes)
Query:
SELECT COUNT(post.dateline) AS postcount, post.uid, user.uid, user.username, user.usergroup, user.displaygroup FROM mybb_posts AS post JOIN mybb_users AS user ON (post.uid=user.uid) WHERE dateline > 1294780748 GROUP BY post.uid ORDER BY postcount DESC LIMIT 18
RE: Slow Board & "MyBB SQL Errors" - bombshell - 12-01-2011 22:27
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
5 - Out of memory (Needed 5241036 bytes)
Query:
SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1294866225' AND location1='114' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
Please contact the MyBB Group for support.
Third time in ten minutes.
RE: Slow Board & "MyBB SQL Errors" - gazfc - 12-01-2011 22:59
had the above error a few times in the last hour
RE: Slow Board & "MyBB SQL Errors" - Rael 74 - 12-01-2011 23:21
Now this trying to log out @ 22:16........
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
5 - Out of memory (Needed 5241216 bytes)
Query:
SELECT COUNT(post.dateline) AS postcount, post.uid, user.uid, user.username, user.usergroup, user.displaygroup FROM mybb_posts AS post JOIN mybb_users AS user ON (post.uid=user.uid) WHERE dateline > 1294784277 GROUP BY post.uid ORDER BY postcount DESC LIMIT 18
RE: Slow Board & "MyBB SQL Errors" - rover - 13-01-2011 00:19
For the last few days I've been getting error after error mainly "500 internal server" errors plus some of those posted above no matter what part of the forum I'm looking at.
The forum at the moment has become unbearable to use because of all the errors.
I know Admin is trying to sort it out but it is very frustrating.
RE: Slow Board & "MyBB SQL Errors" - admin. - 13-01-2011 00:57
Thanks to all those who have posted error messages. With your help it looks like the problem has now been fully diagnosed.
PS to Chimpy - you are correct, it is indeed a memory problem (although the scrolling message doesn't really qualify as a contributory factor).
PS to rover - Just to clarify something, I am not 'trying' to sort it out, I am sorting it out.
RE: Slow Board & "MyBB SQL Errors" - aceman65 - 13-01-2011 21:45
Well, I don't know if this is because your working on it right now or not. But I just got this:
![[Image: mybbsql05.jpg]](http://www.imagechunk.com/images/mybbsql05.jpg)
Three times within the space of a minute, at 20:42pm.
RE: Slow Board & "MyBB SQL Errors" - gazfc - 13-01-2011 22:32
I was getting the same error round about the same time when viewing the sports section
RE: Slow Board & "MyBB SQL Errors" - Krill Liberator - 13-01-2011 22:42
Yes, I too got the "Out of memory, yada yada yada" message. When I was on the "Who's next for an Ofcomming?" thread about, ooh, 21:15ish.
Hope this helps!
PS - the only 'MyBB SQL error' I'd experienced previously was when I took My BBgun and BLSTD a tree-rat, only to then discover it was a R/SQL, rather than the despised G/SQL that I had taken it to be.
How foolish I felt.
RE: Slow Board & "MyBB SQL Errors" - simplymarko - 13-01-2011 22:56
i notice the currently online users lists seems to have vanished so maybe that will stop some of the errors