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

DataTables - Hide page size dropdown

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-2532-297afcd-7.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 = 103391 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 React
Topic: DataTables - Hide page size dropdown

DevPaulLeon asked 5 years ago

Hello,

Is there currently any way to remove the page size selector the same way there is with the search bar? I'd love to use the pagination of the data table but I want the size to stay consistent. While I can have an empty array for entriesOptions, I would like to have no dropdown or element at all.

Thanks!

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: MDB React
  • MDB Version: 4.21.1
  • Device: PC
  • Browser: Chrome
  • OS: Windows 10
  • Provided sample code: No
  • Provided link: No
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
Angular 9 , table examples not working
2
DataTables and ajax
1
Large Dependencies Should Not Be Bundled
About author
DevPaulLeon
22Support score
4Questions 0Answers
0Snippets likes 0Snippets