Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

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

More
10 years 1 month ago #142324 by 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.
Code:
[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:
Code:
[mysqldump] quick max_allowed_packet = 512M

Any help or assistance would be greatly appreciated - I am looking forward to trying out LimeSurvey!
The topic has been locked.
More
10 years 1 month ago - 10 years 1 month ago #142325 by 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
Last edit: 10 years 1 month ago by jelo.
The topic has been locked.
More
10 years 1 month ago #142327 by 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:
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose