WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-141169-1a6.MAI' (Errcode: 28 "No space left on device")]
SELECT p.*, o.option_value, GROUP_CONCAT(DISTINCT CONCAT(m.meta_key, "::", m.meta_value) separator "::::") as seo_meta, t.slug, tr.language_code as language FROM wp_posts p JOIN wp_postmeta m ON p.ID = m.post_id JOIN wp_options o ON o.option_name = "siteurl" JOIN wp_term_relationships r ON r.object_id = p.ID JOIN wp_term_taxonomy x ON x.term_taxonomy_id = r.term_taxonomy_id JOIN wp_terms t ON t.term_id = x.term_id JOIN wp_icl_translations tr ON p.ID = tr.element_id WHERE post_type = "page" AND post_status = "publish" AND tr.language_code = 'en' AND t.slug IN ('jquery') AND x.taxonomy = "page_cat" AND tr.element_type = "post_page" AND meta_key IN ("_yoast_wpseo_title", "_yoast_wpseo_metadesc") GROUP BY p.ID

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-141169-1a7.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

Edit table issue

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-141169-1a8.MAI' (Errcode: 28 "No space left on device")]
SELECT p.* FROM wp_mdb_forum_posts AS p LEFT JOIN wp_mdb_forum_posts AS q ON( q.Id = p.ParentId AND p.Id = q.AcceptedAnswerId ) WHERE p.PostTypeId = 2 AND p.ParentId = 124420 GROUP BY p.Id ORDER BY CASE WHEN q.Id IS NOT NULL THEN 1 ELSE 0 END DESC, p.UpvoteCount DESC, p.CreationDate ASC


Topic: Edit table issue

Wladi79 pro premium priority asked 2 years ago

Expected behavior Loading data into table from JSON at site startup and normal operation

Actual behavior Loading data into the table when the site starts, but action icons don't appear, and when you click on the "Add" button - all loaded fields disappear, but action buttons appear![

      document.addEventListener("DOMContentLoaded", function () {
        function insertDataToTable(tableId, data) {
            const table = document.querySelector(`#${tableId} tbody`);
            if (!table) {
                console.error(`Table with id ${tableId} not found!`);
                return;
            }
            for (const key in data) {
                const row = document.createElement("tr");

                const commCell = document.createElement("td");
                commCell.textContent = data[key].communication[0];
                row.appendChild(commCell);

                const seqCell = document.createElement("td");
                seqCell.textContent = data[key].sequence[0];
                row.appendChild(seqCell);

                const excCell = document.createElement("td");
                excCell.textContent = data[key].exception[0];
                row.appendChild(excCell);

                table.appendChild(row);
            }
        }

        fetch('data.json') 
            .then(response => {
                if (!response.ok) {
                    throw new Error("HTTP Error: " + response.status);
                }
                return response.json();
            })
            .then(data => {
                console.log(data)
                const jsonData = data
                for (const tableId in jsonData.data) {
                    insertDataToTable(tableId, jsonData.data[tableId]);
                }

            })
            .catch(error => {
                console.error(error);
            });
    });

Resources (screenshots, code snippets etc.) enter image description here


Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Answered

Specification of the issue
  • User: Pro
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 6.4.1
  • Device: Laptop
  • Browser: Electron
  • OS: Windows
  • Provided sample code: No
  • Provided link: No