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

How can I change the dropdown and search bar of DataTables?

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-160870-337.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 = 102398 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 jQuery
Topic: How can I change the dropdown and search bar of DataTables?

.jodadev. pro asked 6 years ago

Hello,

So I'm using DataTables downloaded from the original site because the one included in MDB is lacking some functionalities (like buttons, etc.). However, this unfortunately results in some errors in the styling. Specifically two errors:

1) The drop-down of the 'show entries' is not showing, so I would like to add the material select https://mdbootstrap.com/docs/jquery/forms/select/ to it. How can I do this?

2) I'm trying to change the search bar for it to show the material input: https://mdbootstrap.com/docs/jquery/forms/inputs/ .

Any idea on how to change both the dropdown of show entries and the search bar of search to work with the material design ones?

Here is a snippet: https://mdbootstrap.com/snippets/jquery/jonathan-2/1084811?view=side#css-tab-view.

Thanks in advance.

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: Pro
  • Premium support: No
  • Technology: MDB jQuery
  • MDB Version: 4.8.7
  • Device: PC
  • Browser: Chrome
  • OS: Windows 10
  • Provided sample code: No
  • Provided link: Yes
Tags
datatables
Related topics
6
Datatables server-side sorting and pagination
3
Please add support for server side pagination hook as well as it is difficult to fetch huge data from server.
2
DataTables and ajax
2
Angular 9 , table examples not working
1
Table Editor Example
About author
.jodadev.
Pro User
41Support score
15Questions 1Answers
0Snippets likes 1Snippets