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

mdb-select keeps nesting select-wrapper after dynamically op

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-14e6c9-4.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 = 107419 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: mdb-select keeps nesting select-wrapper after dynamically option insertion

Jorge Nuñez Malledo asked 5 years ago

Hello friends,

Hope you are doing ok in Poland.

When dynamically adding option via jquery script, mdb-select keeps nesting select-wrapper's divs outside original select, in an exponential way. Eventually, the session crashes. In the snipped below, session crashes after the 10th option insertion. By the time, the number of nested select-wrapper's div is... 512!

Am I doing something wrong?

Thank you and take care

Resources (screenshots, code snippets etc.)

https://mdbootstrap.com/snippets/jquery/jorge_nunez_malledo/1946445


Grzegorz Bujański commented 5 years ago

Hi. We fine, thanks. I add this case to our to do list. We will look at this and fix as soon as possible.


Jorge Nuñez Malledo commented 5 years ago

Glad to hear that,

This behavior continues even after material select is destroyed, as if there's a listener upon select changes. Is there any chance to temporary disable such a listener? If so, I could try to workaround this by

  1. Disabling the listener
  2. Performing select modifications
  3. Re-enabling the listener

(Probably complemented with material select destroy/init)


Grzegorz Bujański commented 5 years ago

Unfortunately we don't have any method to disable listeners in material select.


Jorge Nuñez Malledo commented 5 years ago

Ok,

Since you're unable to provide a workaround for this issue, please make sure that the fix is included in the next product release

Cheers


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: Free
  • Premium support: No
  • Technology: MDB jQuery
  • MDB Version: 4.15.0
  • Device: Lenovo T480
  • Browser: Mozilla Firefox 74.0.1 (64-bit)
  • OS: Windows 10
  • Provided sample code: No
  • Provided link: Yes