- Posts: 2
- Thank you received: 0
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
- Topic Author
- Offline
- New Member
Less
More
7 years 6 months ago #142324
by david7788
PDO::__construct(): MySQL server has gone away was created 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.
I also have increased the variable for "max_allowed_packet" at the bottom of the file:
Any help or assistance would be greatly appreciated - I am looking forward to trying out LimeSurvey!
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
7 years 6 months ago - 7 years 6 months ago #142325
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic PDO::__construct(): MySQL server has gone away
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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
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.
You're a hero for the day.
The topic has been locked.