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

Plus d'informations
il y a 2 ans 8 mois #142324 par 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!

Connexion ou Créer un compte pour participer à la conversation.

LimeSurvey Partners
Plus d'informations
il y a 2 ans 8 mois - il y a 2 ans 8 mois #142325 par 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
Dernière édition: il y a 2 ans 8 mois par jelo.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 8 mois #142327 par 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:

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!