[NLP-er]

Hi.

My mod is taking data from Google. Usually it is fast, still sometimes it took long enough that MySQL is going away (error 'MySQL hs gone away').

I wrote code to reestablish connection, but it seems that it doesn't work for all.

PHP Code:

if (!mysql_ping($vbulletin->db->connection_recent)) {
  $vbulletin->db->close();

  // make database connection
  $vbulletin->db->connect(
  $vbulletin->config['Database']['dbname'],
  $vbulletin->config['MasterServer']['servername'],
  $vbulletin->config['MasterServer']['port'],
  $vbulletin->config['MasterServer']['username'],
  $vbulletin->config['MasterServer']['password'],
  $vbulletin->config['MasterServer']['usepconnect'],
  $vbulletin->config['SlaveServer']['servername'],
  $vbulletin->config['SlaveServer']['port'],
  $vbulletin->config['SlaveServer']['username'],
  $vbulletin->config['SlaveServer']['password'],
  $vbulletin->config['SlaveServer']['usepconnect'],
  $vbulletin->config['Mysqli']['ini_file'],
  $vbulletin->config['Mysqli']['charset']
   );
      
   if (!empty($vbulletin->config['Database']['force_sql_mode'])){
     $vbulletin->db->force_sql_mode('');
   }
} 


The code is mostly taken from vB, so there is no configuration/typo issue. Some have issue with mysql_ping - error tells that $vbulletin->db->connection_recent is wrong object. And some still have MySql server has gone away - like reconnection didn't occurs...

What is wrong? And how to made reconnection?