PDO::__construct(): MySQL server has gone away

Mehr
2 Jahre 11 Monate her #142324 von david7788
Hello,

I am trying to install LimeSurvey (2.52) on a Windows 7 desktop computer (4GB RAM) running XAMPP (Apache 2.4 / PHP 5.6.11 / 5.6.25).

I am able to get to the Pre-installation check screen, and everything checks out, but when I hit "Next", it gives me a "PDO::__construct(): MySQL server has gone away" error after a few minutes of trying to process.

Here is my settings in my.ini file. I did increase them based on other recommendations I've found on this forum.
[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql" 
tmpdir = "C:/xampp/tmp" 
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
skip-external-locking
key_buffer = 384M
table_open_cache = 4096
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 128M
thread_cache_size = 8
query_cache_size = 256M
net_read_timeout = 600
net_write_timeout = 600
wait_timeout = 28800

I also have increased the variable for "max_allowed_packet" at the bottom of the file:
[mysqldump]
quick
max_allowed_packet = 512M

Any help or assistance would be greatly appreciated - I am looking forward to trying out LimeSurvey!

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
2 Jahre 11 Monate her - 2 Jahre 11 Monate her #142325 von jelo
What did you enter as servername for the database during the installation of LimeSurvey?
If it is localhost, try 127.0.0.1 instead.

In my.ini add under [mysqld]:
max_allowed_packet = 20M

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Letzte Änderung: 2 Jahre 11 Monate her von jelo.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Jahre 11 Monate her #142327 von david7788
Thank you, that worked!. It was the domain name. I ended up having to use the name of the computer on our network and it worked.

You're a hero for the day. :cheer:

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha