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

Autocomplete

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-15026d-4a.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 = 94143 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. General Bootstrap questions
Topic: Autocomplete

john.tazam asked 7 years ago

I've added the MDB Autocomplete for the user to select a country. Is it possible to change the settings (or use an MDB alternative) to achieve the following:

1) I only want the answer to be selected from the list. Currently if the user types in anything (that's not on the list) then it will be retained.

2) Ideally when the user selects a country then I would also like the country code to be displayed either in the selection or another field/hidden variable. (This requirement is not so important but would be really useful)

I don't think this is an unusual request but I can't find a solution on the MDB website - sorry if I've missed it

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

Answered

Specification of the issue
  • User: Free
  • Premium support: No
  • Technology: General Bootstrap questions
  • MDB Version: -
  • Device: PC
  • Browser: Chrome
  • OS: Windows
  • Provided sample code: No
  • Provided link: No
Tags
force-a-selection
About author
john.tazam
10Support score
2Questions 0Answers
0Snippets likes 0Snippets