MX Calendar Forum :: MX Shop

I need help with MX Shop. When I try to add options I get a syntax error that I can't figure out how to fix - can you help? the error is:

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': 'FreeBSD'}, 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.4.1'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'installation', 'value': 'apache'}, wnd)); frm.appendChild(utility.dom.createElement('INPUT', {'type': 'hidden', 'name': 'extensions', 'value': 'array (\n 0 => \'xslt\',\n 1 => \'xmlrpc\',\n 2 => \'xml\',\n 3 => \'wddx\',\n 4 => \'tokenizer\',\n 5 => \'standard\',\n 6 => \'sockets\',\n 7 => \'session\',\n 8 => \'pspell\',\n 9 => \'posix\',\n 10 => \'pcre\',\n 11 => \'overload\',\n 12 => \'mysql\',\n 13 => \'ming\',\n 14 => \'mhash\',\n 15 => \'mcrypt\',\n 16 => \'mbstring\',\n 17 => \'imap\',\n 18 => \'iconv\',\n 19 => \'gettext\',\n 20 => \'gd\',\n 21 => \'ftp\',\n 22 => \'exif\',\n 23 => \'domxml\',\n 24 => \'curl\',\n 25 => \'ctype\',\n 26 => \'calendar\',\n 27 => \'bz2\',\n 28 => \'bcmath\',\n 29 => \'zlib\',\n 30 => \'openssl\',\n 31 => \'apache\',\n 32 => \'Zend Optimizer\',\n)'}, wnd)); setTimeout(function() { wnd.document.body.appendChild(frm); frm.submit(); }, 5); } //return false; }

Hi,

Please check this similar thread.

Regards,
Ionut

The suggested thread does not help - it wanders off into where you can get the shopping cart and does not answer the question. Can you help me to fix this?

George, the answer form that  thread is:

From the looks of the error message, you are using MySQL 4.0.

If you do not have the right to create temporary tables, MX Shop will try to create a fake recordet using subselectes and unions. Unfortunately, this is not possible on MySQL 4.0, as it does not support subselects. To make this work for MySQL 4.0, you will have to allow the right to create and drop temporary tables.

Ionut