CiviCRM Community Forums (archive)

Dear community,

after successfully installing CiviCRM on WordPress I tried to run it by clicking the CiviCRM button in the admin menu. But unfortunately it doesn't work. I hope you can help me!

After exactly 60 seconds the script gives me an error message "DB Error: no database selected".
I then had a look into the file wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.55ee1d3fbbbd8ca6a7c214dba73ee427.log where I found some more interesting details. I found out that a MySQL error caused the problem:

nativecode=2006 ** MySQL server has gone away

The full text including backtrace is attached!
By the way the error shows only on first run. The second time I get no error message at all. To reproduce the error I have to delete the wp-content/plugins/files/civicrm directory.

I guess that the MySQL "wait_timeout" set to 60 seconds is too low. Is there a way to tell CiviCRM to manually set the timeout to somewhat higher? As I'm in a shared environment I can't set the variable in the MySQL configuration. I have to set it from within the PHP code.

Thanks in advance for your help!

No, 60 seconds is not low at all. Something is going wrong if it takes that long. Did you ask your host what might be happening?

Thanks for your answer!
Can you really be sure here? I mean, on first run CiviCRM seems to build up some things. And why should MySQL return error 2006 (server has gone away)? Did you have a look at the log file?
I think there is no way my host can tell me what exactly is going on, because I installed the software all on myself. No way further here

As the host doesn't support software hostet on the webspace this would really be just one of the last options I would take.
As a next step I would like to set MySQL's wait_timeout to about 120 to test things out a little.... But I don't know where. Does anyone know?