openadvent

hi 4evrblu,
hope it helps ??

WT,

you need to copy the function checkconnection()
as well.

and also alter your query function to call checkconnection before query:

function query($query) {
// filter the query, if filters are available
// NOTE: some queries are made before the plugins have been loaded, and thus cannot be filtered with this method

$this->checkconnection();

https://www.openadvent.com/blog/?p=30#more-30

hi,

the problem isn’t on the host
it’s more due to the problem of mysql server.

if you refer to https://www.vbulletin.com/forum/showthread.php?t=43505

it shows that mysql might time out on your connection.
especially when mysql_connect in php actually reuse your old connection when calling mysql_connection (which is alike ms$ connection pooling )

so, my suggested solution is to set the 4th parameter of mysql_connection to true, to makesure php does not reuse existing connection.
and then do a ping to the server.

mysql_ping

do the ping on query function, right before query is done.

For my modified file:

https://www.openadvent.com/blog/?p=30