Welcome to the LimeSurvey Community Forum

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

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

  • david7788
  • david7788's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months 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
7 years 6 months ago - 7 years 6 months 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: 7 years 6 months ago by jelo.
The topic has been locked.
  • david7788
  • david7788's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months ago #142327 by david7788
Replied by david7788 on topic PDO::__construct(): MySQL server has gone away
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.

Lime-years ahead

Online-surveys for every purse and purpose