SQL & JavaScript Error Resolution

Job ID: 37700075

Budget: €8 – €30 EUR

I'm currently experiencing a set of issues, namely a syntax issue in a SQL file, as well as a critical JavaScript error which is preventing me from uploading the code.

The issues at hand are:
- SQL syntax error that needs rectification
- A sudden, fatal JavaScript error preventing code upload

The exact error message I receive during the JavaScript code upload is stating 'JavaScript Fatal Error'. The error is produced when I attempt the upload process, preventing successful completion.

I'm looking for a professional who has significant experience in solving both SQL and JavaScript coding issues. Ideally, you are:

- Proficient in JavaScript and SQL
- Able to quickly troubleshoot and resolve coding errors
- Highly detail-oriented and accurate

Your role will involve rectifying these errors promptly so that my code upload can proceed without further issues.
Here is the error response in phpMyadmin
"{
"pma_version": "5.2.1",
"browser_name": "CHROME",
"browser_version": "121.0.0.0",
"user_os": "Win",
"server_software": "cpsrvd 11.116.0.10",
"user_agent_string": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36",
"locale": "en",
"configuration_storage": "disabled",
"php_version": "8.1.26",
"script_name": "index.php",
"exception_type": "js",
"exception": {
"mode": "stack",
"name": "QuotaExceededError",
"message": "Failed to execute 'setItem' on 'Storage': Setting the value of 'autoSavedSql_rareme_testing' exceeded the quota.",
"stack": [
{
"func": "Sql.autoSave",
"line": "51",
"column": "27",
"context": [
" */",
"Sql.autoSave = function (query) {",
" if (query) {",
" var key = Sql.getAutoSavedKey();",
" if (isStorageSupported('localStorage')) {",
" window.localStorage.setItem(key, query);",
" } else {",
" Cookies.set(key, query);",
" }",
" }",
"};"
],
"uri": "js/dist/sql.js?v=5.2.1",
"scriptname": "js/dist/sql.js"
},
{
"func": "?",
"line": "235",
"column": "13",
"context": [
" Sql.setShowThisQuery();",
" }",
" $(function () {",
" if (codeMirrorEditor) {",
" codeMirrorEditor.on('change', function () {",
" Sql.autoSave(codeMirrorEditor.getValue());",
" });",
" } else {",
" $('#sqlquery').on('input propertychange', function () {",
" Sql.autoSave($('#sqlquery').val());",
" });"
],
"uri": "js/dist/sql.js?v=5.2.1",
"scriptname": "js/dist/sql.js"
},
{
"func": "?",
"line": "2089",
"column": "45",
"context": [
" } else {",
" list = orphanDelayedCallbacks = [];",
" setTimeout(fireOrphanDelayed, 0);",
" }",
" var loop = function ( i ) {",
" list.push(function () { return arr[i].apply(null, args); });",
" };",
"",
" for (var i = 0; i < arr.length; ++i)",
" loop( i );",
" }"
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "fireCallbacksForOps",
"line": "2046",
"column": "24",
"context": [
" // Calls delayed callbacks and cursorActivity handlers until no",
" // new ones appear",
" var callbacks = group.delayedCallbacks, i = 0;",
" do {",
" for (; i < callbacks.length; i++)",
" { callbacks[i].call(null); }",
" for (var j = 0; j < group.ops.length; j++) {",
" var op = group.ops[j];",
" if (op.cursorActivityHandlers)",
" { while (op.cursorActivityCalled < op.cursorActivityHandlers.length)",
" { op.cursorActivityHandlers[op.cursorActivityCalled++].call(nul//..."
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "finishOperation",
"line": "2060",
"column": "11",
"context": [
"",
" function finishOperation(op, endCb) {",
" var group = op.ownsGroup;",
" if (!group) { return }",
"",
" try { fireCallbacksForOps(group); }",
" finally {",
" operationGroup = null;",
" endCb(group);",
" }",
" }"
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "endOperation",
"line": "3832",
"column": "15",
"context": [
" }",
"",
" // Finish an operation, updating the display and signalling delayed events",
" function endOperation(cm) {",
" var op = cm.curOp;",
" if (op) { finishOperation(op, function (group) {",
" for (var i = 0; i < group.ops.length; i++)",
" { group.ops[i].cm.curOp = null; }",
" endOperations(group);",
" }); }",
" }"
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "runInOp",
"line": "3961",
"column": "15",
"context": [
" // Run the given function in an operation",
" function runInOp(cm, f) {",
" if (cm.curOp) { return f() }",
" startOperation(cm);",
" try { return f() }",
" finally { endOperation(cm); }",
" }",
" // Wraps a function in an operation. Returns the wrapped function.",
" function operation(cm, f) {",
" return function() {",
" if (cm.curOp) { return f.apply(cm, arguments) }"
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "handlePaste",
"line": "8221",
"column": "11",
"context": [
" function handlePaste(e, cm) {",
" var pasted = e.clipboardData && e.clipboardData.getData(\"Text\");",
" if (pasted) {",
" e.preventDefault();",
" if (!cm.isReadOnly() && !cm.options.disableInput && cm.hasFocus())",
" { runInOp(cm, function () { return applyTextInput(cm, pasted, 0, nu//...",
" return true",
" }",
" }",
"",
" function triggerElectric(cm, inserted) {"
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
},
{
"func": "HTMLTextAreaElement.<anonymous>",
"line": "9394",
"column": "36",
"context": [
" if (ie && ie_version >= 9 && this$1.hasSelection) { this$1.hasSelecti//...",
" input.poll();",
" });",
"",
" on(te, \"paste\", function (e) {",
" if (signalDOMEvent(cm, e) || handlePaste(e, cm)) { return }",
"",
" cm.state.pasteIncoming = +new Date;",
" input.fastPoll();",
" });",
""
],
"uri": "js/vendor/codemirror/lib/codemirror.js?v=5.2.1",
"scriptname": "js/vendor/codemirror/lib/codemirror.js"
}
],
"uri": "index.php?route=%2Fdatabase%2Fsql"
}
}"
Related categories: JavaScript SQL MySQL Database Administration phpMyAdmin