Post: #26

I just got two errors that a simple reload fixed. Attached.

First one: Entering "everything else" board.
   

Second one: Entering this thread.
   

Full text of second one:

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT * FROM mybb_attachments WHERE pid IN('523297','523300','523301','523303','523305','523306','523327','523382','5234​21','523433','523439','523440','523441','523442','523451','523463','523465','523​476','523479','523480','523494','523495','523532','523535','523536')

Please contact the MyBB Group for support.

Post: #27

The text of the errors are fine. Screenshots are not necessary.

Post: #28

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1194 - Table 'mybb_threads' is marked as crashed and should be repaired
Query:
SELECT tid FROM mybb_threads WHERE tid IN(24884,27558,27569,27558,27558,27558,27558,27558,27529,27560,27561,27558,27562​,27300,27558,27558,27558,27553,27519,27547,27547,24884,27

Post: #29

And;

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '4' AND (lastpost >= '1377889542' OR sticky=1) AND visible='1' ORDER BY lastpost DESC

Post: #30

Im getting these all day today:

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: #31

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT pid FROM mybb_posts WHERE tid='20433' ORDER BY pid DESC LIMIT 1

Please contact the MyBB Group for support.

Post: #32

I couldn't connect for a while, getting this error, which I presume has been fixed:

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.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>'1377902431' ORDER BY u.username ASC, s.time DESC

Please contact the MyBB Group for support.

Post: #33

I wonder if some white knight reddit techno nerd is upset about the abortion article

Post: #34

(08-30-2013 06:51 PM)calihunter Wrote:  I wonder if some white knight reddit techno nerd is upset about the abortion article

I was thinking nearly the exact same thing

Post: #35

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:2006 - MySQL server has gone awayQuery:SELECT pid FROM mybb_posts WHERE tid='27558' ORDER BY pid DESC LIMIT 1

Post: #36

Right now the forum seems to run somewhat okay, but then when the software does a normal check, it crashes and then closes itself.

Post: #37

(08-30-2013 11:36 AM)Roosh Wrote:  ......... it's my top priority right now after banging.....

I really got a kick out of the above statement.


Within the last 1/2 hour when i attempted to load two separate pages, I received the below two messages. I hit refresh, and I was thereafter taken to the appropriate RVF page.

Page Error 1:

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT template FROM mybb_templates WHERE title='video_youtube_embed' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1

Page Error 2:

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT u.username, u.usergroup, u.displaygroup, tyl.* FROM mybb_g33k_thankyoulike_thankyoulike tyl LEFT JOIN mybb_users u ON (u.uid=tyl.uid) WHERE tyl.pid IN('523297','523300','523301','523303','523305','523306','523327','523382','5234​21','523433','523439','523440','523441','523442','523451','523463','523465','523​476','523479','523480','523494','523495','523532','523535','523536') ORDER BY dateline ASC

Post: #38

Every hour the forum runs a script to check the tables. It finds a problem and then automatically shut down the forum, and then I have to open the board back up. So now we must check what's causing this problem.

Post: #39

It's :58 past the hour. I think the forum will crash in 2 minutes. Around the turn of the hour, make sure you copy your post to clipboard in case it doesn't go through.

Post: #40

Okay it did crash. So I have to be at the computer every hour.

Post: #41

Talk about a cockblock.

Post: #42

The forum is somewhat stable right now. A big test will be to see what at :00 past the hour.

Post: #43

Still had a shutdown on the hour.

Post: #44

If the forum data is lost it'll no less rival the burning of the Library of Alexandria. Members will be thrown back 500 years and enter the player dark ages. Where only fatties and feminist exist.

Post: #45

Note:
The software version of the MyBB may not be compatible with your (old?) MySQL server version.

Post: #46

(08-31-2013 12:10 PM)Menace Wrote:  Still had a shutdown on the hour.

Yes. The new guy I got won't be able to address this until Sunday, so we will be limping for the resting of Saturday.

Post: #47

Worst case is we have to roll back the site to Thursday afternoon.

Post: #48

This bulletin board is currently closed. The Administrator has specified the reason as to why below.

MyBB is automatically repairing a crashed table.

Post: #49

Still trying to narrow down what's causing the closure. Every hour I try something different and then see if the board shuts down. I won't have a server guy able to look at it until Sunday.

Post: #50

(08-31-2013 02:31 PM)Roosh Wrote:  Still trying to narrow down what's causing the closure. Every hour I try something different and then see if the board shuts down. I won't have a server guy able to look at it until Sunday.

Those database errors may mean something wrong at the hosting level. It looks like the forum software can't connect to the mysql database.

Check the mysql.connect_timeout option. It may be timing out and need to be increased.