MX User Login Forum :: MySQL server has gone away - What is happening?

function needHelp() { if (confirm('Some data will be submitted to InterAKT. Do you want to continue?')) { var rand = Math.random().toString().substring(3, 10); var wnd = window.open('includes/tng/pub/blank.html', 'KTDebugger_' + rand, ''); try { var doc = wnd.document; } catch(e) { alert("The popup could not be opened. Please configure your pop-up blocker software to allow this."); return; } var frm = utility.dom.createElement( "FORM", { 'action': 'http://www.interaktonline.com/error/', 'method': 'POST', 'style': "display: none" }, wnd ); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'err', 'value': 'Internal error.'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'devNotes', 'value': 'tNG_update.getLocalRecordset:
Error message:
MySQL server has gone away
SQL statement:
SELECT Builder_email, Builder_email as kt_pk_builders FROM builders WHERE Builder_email =\'stephenson_amy@hotmail.com\' (UPD_RS)'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'os', 'value': 'Linux'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'webserver', 'value': 'Apache'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'servermodel', 'value': 'PHP MySQL 4.3.11'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'installation', 'value': 'cgi-fcgi'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'extensions', 'value': 'array (\n 0 => \'zip\',\n 1 => \'xml\',\n 2 => \'tokenizer\',\n 3 => \'sybase\',\n 4 => \'standard\',\n 5 => \'session\',\n 6 => \'pcre\',\n 7 => \'overload\',\n 8 => \'mysql\',\n 9 => \'mcrypt\',\n 10 => \'gettext\',\n 11 => \'gd\',\n 12 => \'ftp\',\n 13 => \'domxml\',\n 14 => \'curl\',\n 15 => \'ctype\',\n 16 => \'calendar\',\n 17 => \'bcmath\',\n 18 => \'zlib\',\n 19 => \'openssl\',\n 20 => \'Zend Optimizer\',\n)'}, wnd)); setTimeout(function() { wnd.document.body.appendChild(frm); frm.submit(); }, 5); } //return false; }

Hi,

Read here:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

Ionut

Its wierd that the form works perfectly fine until I put in a send email function. The mail server works fine.  I have been working on getting this fixed for some time. Normally I get a email server error.  I can send you the tng info if you need.  Please let me know.  Thanks, Amy

Hello

Your Database is slow. 

If you have root access, edit the file my.cnf 

Look at the section

log slow queries and thread_worker

If log slow queries is on, hav a look at the log and the execution time. You find a high execution time. edit your DB with some performance setting that mentioned in MySQL Ref Book. 

bennos

My Sites: 

jobbörse - strom - webhosting - eeepc - geschenke