Post: #101

(09-03-2013 07:18 PM)aphelion Wrote:  Exact repro steps for the crash error:

From browsing the Everything Else forum
/forum-4.html

clicking on the Main tab results in a MyBB error.
/forum-1.html

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1194 - Table 'mybb_sessions' is marked as crashed and should be repaired
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 > '1378252864' AND location1='1' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC

However, navigating to the Main Forum by simply going to http://www.rooshvforum.com works as expected.

Try now.

(09-03-2013 07:23 PM)TheSlayer Wrote:  The forum is still very slow for me and I am also getting crash errors. Also had a couple of 500 Internal Server errors or whatever those are called.

Can you paste the crash errors so I can troubleshoot.

Post: #102

If heavy traffic is causing the sessions table to lock up, it's probably a MyISAM table. You could flip that table to the memory engine, would probably alleviate heavy traffic issues.

Sessions tables don't need to be saved to the disk, since sessions data is volatile (non-permanent). I poked around a bit on this particular error.

Post: #103

(09-03-2013 10:47 PM)ryanf Wrote:  If heavy traffic is causing the sessions table to lock up, it's probably a MyISAM table. You could flip that table to the memory engine, would probably alleviate heavy traffic issues.

Sessions tables don't need to be saved to the disk, since sessions data is volatile (non-permanent). I poked around a bit on this particular error.

Excellent I'll keep that in mind. It was the first time it ever happened.

Post: #104

Is anyone having trouble uploading avatars?

I have a good one but when I try to upload, a message pops up telling me the file is invalid. Please upload a valid file.

I just got a new phone, but it uses the same OS as my old galaxy. I save the files as jpegs. Maybe it is my phone?

Post: #105

(09-04-2013 09:13 AM)kickboxer Wrote:  Is anyone having trouble uploading avatars?

I have a good one but when I try to upload, a message pops up telling me the file is invalid. Please upload a valid file.

I just got a new phone, but it uses the same OS as my old galaxy. I save the files as jpegs. Maybe it is my phone?

Try to duplicate the program using a normal browser.

Post: #106

It worked. Thanks.

Post: #107

Just now: "The maximum server load limit has been reached. Please check back later once the server is less busy."

Post: #108

Just a minute ago:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Query:
[READ] Unable to connect to MySQL server

Post: #109

Just got this error...



MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
126 - Incorrect key file for table './rooshvf_forum/mybb_sessions.MYI'; try to repair it
Query:

Post: #110

Yeah the sessions table crashed.

Within the next two days I'll have another IT guy look at the server.

Post: #111

I keep getting errors Everytime i click. Lifestyle, everything etc. I refresh and it's ok. Here's one of the errors
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='4' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40

Post: #112

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Query:[READ] Unable to connect to MySQL server
Please contact the MyBB Group for support.

Been happening to me over the past five minutes

Post: #113

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT p.*, u.username AS userusername FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE pid IN (529951,529948,527620,526606,526346,526330,526327,526260,526101,525995,525984,52​5976,525973,525948,525866,525844,525773,525746,525737,525697,525695,525678,52472​5,524152,524076) ORDER BY dateline DESC

Post: #114

Tons of errors going on right now.

Post: #115

I've been getting this one frequently over the last few minutes:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server

Post: #116

Ironically while trying to see BoneDaddy's post I got this message:


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='13863' LIMIT 1

Post: #117

Just reading the new threads(so far just everything else and game forums) and get these

everything else
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='13566' LIMIT 1


and this

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
145 - Table './rooshvf_forum/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE uid='13566'

and this was for the game forum

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='2' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40

sometimes just refreshing like you suggested fixes it, sometimes not.

Post: #118

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1378838838' ORDER BY u.username ASC, s.time DESC

Post: #119

Got the same error again:

yBB has experienced an internal SQL error and cannot continue.

SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server

I should note that I can always recover by refreshing the page.

Post: #120

i just got a My BB Error message. i switched my browser to Compatibility View, and was able to log on again

Post: #121

New server guy has been working on the server today. Please leave any error messages you get from this point on.

Post: #122

I got this a minute ago.

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL serve

Post: #123

Just now:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='4' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40

Post: #124

At the bottom of a page I was reading:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
UPDATE mybb_users SET lastactive='1378927526', timeonline=timeonline+86 WHERE uid='13137'

Post: #125

i just got the error,

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
SELECT * FROM mybb_sessions WHERE sid='8a62c34952f4a452994f75a39d941df6' AND ip='130.182.26.199' LIMIT 1




switched on to Compatibility View, smooth as silk now