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

Autocomplete with Remote Data Source

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-12bebc-32.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 = 102628 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: Autocomplete with Remote Data Source

maenthoven pro asked 6 years ago

Are there any demos for the new autocomplete from a remote data source, with objects as the end output?

I'm trying to make a "Author Search" component. This is an autocomplete component that binds to an Author. Authors have the structure of {id: number; name: string;}.

So, I want the user to select an author from the autocomplete dropdown (searching from the server).

When the user selects an author, the [(ngModel)] is now set to that author. ANY changes to the text make it so that the author is voided out.


Arkadiusz Idzikowski staff commented 6 years ago

https://mdbootstrap.com/docs/angular/forms/autocomplete/#remoteData

We use string in our example, however the use of the object should not affect funcionality of the component in any way. Could you provide some html/ts code on which we will be able to reproduce this problem?


Please insert min. 20 characters.

FREE CONSULTATION

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

Status

Open

Specification of the issue
  • User: Pro
  • Premium support: No
  • Technology: MDB Angular
  • MDB Version: 8.3.0
  • Device: All
  • Browser: All
  • OS: All
  • Provided sample code: No
  • Provided link: No