Hi
I got the error below when I click on the options button at the products admin area:
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_fields.getFakeRecordset:
SQL error: Error creating fake recordset:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'SELECT 1 AS tmp) AS tmptable where tmptable.tmp = 2\' at line 1
SQL:
SELECT * FROM (SELECT 1 AS tmp) AS tmptable where tmptable.tmp = 2 (FIELDS_FAKE_RS_ERROR)'}, 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; }
Developer Details:
tNG_fields.getFakeRecordset:
SQL error: Error creating fake recordset:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT 1 AS tmp) AS tmptable where tmptable.tmp = 2' at line 1
SQL:
SELECT * FROM (SELECT 1 AS tmp) AS tmptable where tmptable.tmp = 2 (FIELDS_FAKE_RS_ERROR)
tNG Execution Trace - VIEW
The server (GoDaddy) does not allow temtable what is the solution?
Thanks
Carlos
