| 00:21.10 | *** join/#uphpu infobot (ibot@rikers.org) |
| 00:21.10 | *** topic/#UPHPU is Meeting: Thursday Jan 14th - SkiPHP Jan 14th & 15th | Utah PHP Users Group | uphpu.org |
| 00:21.10 | *** mode/#UPHPU [+v infobot] by ChanServ |
| 03:21.41 | *** join/#uphpu ninnypants (~ninnypant@unaffiliated/ninnypants) |
| 03:21.41 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 13:58.28 | *** join/#uphpu romanovic (~romanovic@unaffiliated/romanovic) |
| 13:58.28 | *** mode/#UPHPU [+v romanovic] by ChanServ |
| 14:56.58 | *** join/#uphpu ninnypants (~ninnypant@unaffiliated/ninnypants) |
| 14:56.58 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 15:06.04 | *** join/#uphpu josephscott (~josephsco@192.0.80.201) |
| 15:51.44 | *** join/#uphpu dezertol (~dezertol@wsip-72-215-204-140.ph.ph.cox.net) |
| 16:00.16 | *** join/#uphpu Heartsbane (tsharpe@shell.xmission.com) |
| 16:00.16 | *** join/#uphpu Heartsbane (tsharpe@unaffiliated/heartsbane) |
| 16:00.16 | *** mode/#UPHPU [+v Heartsbane] by ChanServ |
| 20:36.47 | *** join/#uphpu tierra_ (tierra@ibaku.net) |
| 20:36.47 | *** mode/#UPHPU [+v tierra_] by ChanServ |
| 20:55.48 | *** join/#uphpu JacobEdmondKerr_ (~JacobEdmo@23-30-61-134-static.hfc.comcastbusiness.net) |
| 20:56.17 | JacobEdmondKerr_ | Hey does anyone know of a good solution for the "MySQL Server Has Gone Away" error using PDO? |
| 20:57.39 | JacobEdmondKerr_ | "General error: 2006 MySQL server has gone away" for long running scripts :'( royal pain in the ars... |
| 20:59.18 | unum | sounds like a timeout issue |
| 21:00.09 | unum | http://stackoverflow.com/questions/21403082/setting-a-connect-timeout-with-pdo |
| 21:00.20 | JacobEdmondKerr_ | I have been setting my PDO connection to NULL then resetting it in my code after each loop and now I'm getting "SQLSTATE[08004] [1040] Too many connections" |
| 21:00.24 | unum | the question is the opposite of what you want, but I bet the answer is the same |
| 21:00.50 | unum | you should be disconnecting rather than setting it to null |
| 21:01.29 | JacobEdmondKerr_ | Yeah I have mine set to: PDO::ATTR_TIMEOUT => 86400 |
| 21:01.52 | JacobEdmondKerr_ | K, thank you. Updating code now :) |
| 21:04.07 | JacobEdmondKerr_ | Looks like there is no disconnect for PDO everything I have found suggest setting the object to null |
| 21:04.50 | unum | huh |
| 21:06.24 | unum | I guess that destroys the object and the destructor closes the connection |
| 21:49.43 | JacobEdmondKerr_ | I just set wait_timeout to 7200 LOL 2 hours. |
| 21:50.13 | JacobEdmondKerr_ | If everything slows down a ton I will know why... |
| 22:06.35 | JacobEdmondKerr_ | I believe setting wait_timeout in the my.cf file fixed the problem :) |
| 22:32.38 | *** join/#uphpu devhen (~devhen@codr.org) |