WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-15348f-22a.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-15348f-22b.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

MDBSelect

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-15348f-22c.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 = 123412 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

Petr Urban pro premium priority asked 2 years ago

Expected behavior Should work without error in console log. Actual behavior I'm using the MDBSelect component and I'm getting the following error in console:

Uncaught TypeError: scrollableParent is null scrollToInput MDBSelect.vue:516 open MDBSelect.vue:392 setTimeout handler*open MDBSelect.vue:390 toggle MDBSelect.vue:359

Resources (screenshots, code snippets etc.) Here is my component:

 <MDBRow class="mt-4 grey-text text-center">
  <MDBCol col="2"/>
  <MDBCol col="8" class="d-flex justify-content-center">
      <MDBSelect class="mb-0 col-6"
                 v-model:options="batchIdOptions"
                 v-model:selected="selectedBatchId"
                 @change="getBatchIdInfo"
                 @clear="clearBatchIdSelection"
                 :clear-button="true"
                 :preselect="false"
                 color="info"
                 filter
                 id="batchIdSelect"
                 data-cy="batchIdSelect"
                 :disabled="calculationIsRunning || !smartDatabaseEnabled">
      </MDBSelect>
  </MDBCol>
  <MDBCol col="2"/>
</MDBRow>

and here how I get the data:

setup() {
const eventBuss = inject('eventBuss');
const axioss = inject('axioss');  // inject axios
const batchIdOptions = ref([
  {text: '-- Please select an option --', value: null, disabled: true}
]);
const selectedBatchId = ref("");

const getBatchIds = () => {
  let url = "/batch-ids";
  let i = 1;
  axioss
      .get(url)
      .then(response => {
        batchIdOptions.value.push(...response.data.map(k => ({
          text: 'Batch ID ' + k.batch_id + ' at time ' + k.log_date,
          value: k.batch_id,
          selected: false,
          mdbKey: i++
        })));
        if (batchIdOptions.value.length === 0) {
          eventBuss.$emit("globalInfo", "No batch IDs found. Probably using portable version without DB support.");
        }
      })
      .catch(error => {
        console.log(error);
        eventBuss.$emit("globalError", error.response.data["error"]);
      });
}

return {
  batchIdOptions,
  selectedBatchId,
  getBatchIds,
};

},

Should I include the MDBSelect into another special tag or something?

Thanks for any tip/help.

BR, Petr


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 Vue
  • MDB Version: MDB5 4.0.0
  • Device: MacBook
  • Browser: Firefox
  • OS: MacOS Ventura
  • Provided sample code: No
  • Provided link: No
Tags