MyBB Community Forums

Hi. The installation went smooth, however after it finished and I went to URL, it says this:

Quote:MySQL error: 2013
Lost connection to MySQL server during query
Query: DELETE FROM mb_sessions WHERE uid=0 AND time<='1165910705'

and

Quote:MySQL error: 2013
Lost connection to MySQL server during query
Query: SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM mb_sessions s LEFT JOIN mb_users u ON (s.uid=u.uid) WHERE s.time>'1165996213' ORDER BY u.username ASC, s.time DESC

Quote:MySQL error: 2013
Lost connection to MySQL server during query
Query: DELETE FROM mybb_sessions WHERE uid=0 AND time<='1165911999'

I tried with a clean new database and and still the same error. I just removed the install directory and uploaded it again and tried a new install and I chose the right cookie settings. I am using Netfirms btw. But still same kind of errors.

It changes every time you refresh. Why is that?

I wanna use MyBB and so is this happening. Damnit.

---

I'm sure it has nothing to do with MyBB, it must defenetly is the MySQL server your host is using... So you might want to contact them or change host.

Yes, your MySQL server is broke. Your host should be able to fix it.

wierd, I had posted something and now the post is gone...

No I merged it with the other post. For better viewing of the thread.

Uhh.. Why did you do that crakter? He was giving advice to another person. They weren't the same people :|

I am sure the DB isn't broke. It works with other scripts such as Drupal.

This definitely isn't a MyBB Problem, at least.

http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html

The most common reason for the MySQL server has gone away error

1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:

mysqladmin -u root -p version

3. or simply your host restarted mysql.. i'd contact your web host

Tikitiki Wrote:This definitely isn't a MyBB Problem, at least.

http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html

The most common reason for the MySQL server has gone away error

1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:

mysqladmin -u root -p version

3. or simply your host restarted mysql.. i'd contact your web host

Alright. Thanks. I have contacted my webhost and I am waiting for answers.