2. PHPRunner General questions
  3. Error executing query. MySQL Server has gone away.
This topic is locked

Error executing query. MySQL Server has gone away.

 		12/11/2014 1:17:59 PM
PHPRunner General questions
C
 cigrenada author

I am running the latest version of phpRunner 8.0 and I kept getting the following error: "Error executing query. MySQL Server has gone away." when I click RESULTS tab in QUERY section. I am using phpRunner's built-in server. I tried on three different computers and getting the same error, using Windows 7 Pro OS. Is there any solution? I appreciate your help.
Sergey Kornilov admin 12/11/2014

PHPRunner doesn't come with MySQL server. "MySQL Server has gone away" means MySQL server needs to be restarted. There are also some additional troubleshooting tips at http://stackoverflow.com/questions/12425287/mysql-server-has-gone-away-when-importing-large-sql-file
A
 		Anapolis 12/12/2014



I am running the latest version of phpRunner 8.0 and I kept getting the following error: "Error executing query. MySQL Server has gone away." when I click RESULTS tab in QUERY section. I am using phpRunner's built-in server. I tried on three different computers and getting the same error, using Windows 7 Pro OS. Is there any solution? I appreciate your help.


You don't say if this is your very first time with a brand new project in PHPRunner 8.

Have you run other PHPRunner projects before version 8?
My first thought, since you say it happened on 3 other computers, is that there is something seriously wrong with your query. The MySql server installed with PHPRunner 8 tries to process your query, loops around and around, and finally, as a protective measure the server times out.
I run 8 on a Windows OS 7.
I always make sure I have installed something like Xampp on Windows. With PhpMyAdmin to run queries and see the database directly and make tables and type changes to fields.
It's the "three different computers" line that makes me think your have created an "impossible" query.
Installing a separate MySql server with phpMyAdmin is a MUST. Especially to test queries running in the same database and tables as your PHPRunner project.
S
 		safesurf 12/12/2014

I had to add AcceptFilter http none to the end of httpd.conf.template file. The PHPRunner 8_23092 embedded server 2.4.10 would not work on my windows 7 machine.

C:\Program Files (x86)\PHPRunner8.0\EmbeddedServer\conf\httpd.conf.template

AcceptFilter http none

AcceptFilter https none