[Roosh]

(09-03-2013 07:18 PM)aphelion Wrote:  

Exact repro steps for the crash error:

From browsing the Everything Else forum
http://www.rooshvforum.network/forum-4.html

clicking on the Main tab results in a MyBB error.
http://www.rooshvforum.network/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.network 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.

[ryanf]

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.

[Roosh]

(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.

[Kickb]

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?

[Roosh]

(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.

[Kickb]

It worked. Thanks.

[Acute Angle]

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

[placer]

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

[DirectDanger]

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:

[Roosh]

Yeah the sessions table crashed.

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

[Zeus]

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

[Pacesetter20]

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

[Thomas the Rhymer]

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

[scorpion]

Tons of errors going on right now.

[BoneDaddy]

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

[Cattle Rustler]

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

[eradicator]

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.

[DirectDanger]

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

[BoneDaddy]

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.

[GameTheory]

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

[Roosh]

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

[Cattle Rustler]

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

[Acute Angle]

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

[placer]

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'

[GameTheory]

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