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

bootstrap5 + jQuery3 Select control does not work after ajax - Material Design for Bootstrap

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

bootstrap5 + jQuery3 Select control does not work after ajax

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-592cd2-dd.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 = 117126 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

  1. MDB Home Page
  2. Support Main Page
  3. MDB Standard
Topic: bootstrap5 + jQuery3 Select control does not work after ajax call responsive

ktakiya pro premium priority asked 4 years ago

Expected behavior

Actual behavior

Resources (screenshots, code snippets etc.)as you can see, the select controls do not work after the ajax render the html page. top section is static code, but bottom section is ajax dynamical data.

Dawid Wajszczuk staff commented 4 years ago

Hi. Are these selects hidden or added after the page loads? If so, you need to initialize them manually with something like this:

document.querySelectorAll('.select').forEach((select) => {
  mdb.Select.getOrCreateInstance(select)
});

Providing a snippet would help a lot https://mdbootstrap.com/snippets/ :)

ktakiya pro premium priority commented 4 years ago

Thanks, let me try this point.

BTW Do you have Javascript API for these guides? I didn't find these documents on website.

ktakiya pro premium priority commented 4 years ago

I got this error, Uncaught TypeError: mdb.Select.getOrCreateInstance(select) is not a function...

but I can mdb.Select.getInstance(select)

is there any API documents talk about refresh and reinitial the html control ?

Dawid Wajszczuk staff commented 4 years ago

In order to use getOrCreateInstance you need to update to MDB5 3.10.0 or newer as it is new feature. Or you can try this

document.querySelectorAll('.select').forEach((select) => {
  const instance = mdb.Select.getInstance(select)
  if (!instance) {
    new mdb.Select(select)
  }
});

You need to check API tab of a component that you want to initialize as it differs between each of them. Basically if any component is non-existent or hidden when page loads, it needs to be initialize manually. We have put information about it here
https://mdbootstrap.com/docs/standard/forms/input-fields/#section-update as it is the most common case.

ktakiya pro premium priority commented 4 years ago

Hi Dawid,

it is working well right now, you saved my life. Thank you for your help.

Do you have a guide to upgrade mdb pack to be the latest version? I mean mdb-standard version with pro. I think I was on 3.9 version, it seems you guys have 3.10 version already.

Dawid Wajszczuk staff commented 4 years ago

Hi. You just need to download the latest version and replace all MDB UI KIt's files in your current project with the new one. Nothing else to do ;) If there will be new version with breaking changes (the version number will start with 4.x.x instead of 3.x.x), you will find the instructions here https://mdbootstrap.com/docs/standard/getting-started/migration/.

ktakiya pro premium priority commented 4 years ago

Dawid, Thank you so much!
Write
Create snippet
Please insert min. 20 characters.

FREE CONSULTATION

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

Resolved

Specification of the issue
  • User: Pro
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 3.9.0
  • Device: Mac
  • Browser: FF
  • OS: MacOS
  • Provided sample code: No
  • Provided link: No
Tags
multiselect select mdb-select
Related topics
0
MDBSelect multiple optionsSelectedLabel for React
0
Multiple select all option selected language
0
How to set both value and name in multiselect?
0
Bug with select
0
Change "x options selected" text in select component with multiselect activated
About author
ktakiya
Pro User Premium support
90Support score
10Questions 4Answers
0Snippets likes 1Snippets

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

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