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

Datatables rows per page select-dropdown-container

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-15c376-145.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 = 120849 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: Datatables rows per page select-dropdown-container

Popeanu pro premium priority asked 3 years ago

Expected behavior

On pressing Rows per page button a with class select-dropdown-container is generated with a calculated transform translate, as shown in screenshot "good" and positioned somewhere around the button.

Actual behavior

Installed the mdb-ui-kit-pro-advanced with ssh, added it and all plugins. Created a simple table with class datatable and alot of rows. Pressing the rows button for 200 per page expands the table and scrolling down automatically to the end of the table. After that pressing the Rows per page again the container select-dropdown-container is somewhere in the middle of the table (or page), and not around the button at the end of te table, as shown in screenshot "bad".

Resources (screenshots, code snippets etc.)

Good

Bad

Snippet Code ( just for copy-paste, in there is working well )

https://mdbootstrap.com/snippets/standard/popeanu/4450618

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 5.0.0
  • Device: PC
  • Browser: Chrome
  • OS: Windows
  • Provided sample code: No
  • Provided link: Yes
Tags
datatables pagination
Related topics
1
Issues with pagination
0
DataTable Pagination
0
Dynamic Pagination on Large Tables
0
datatable How to Jump to last page?
0
Datatable throws an error when trying to sort a row and when pagination is disabled
About author
Popeanu
Pro User Premium support
15Support score
2Questions 2Answers
0Snippets likes 1Snippets