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

Datatable cell wrapping

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-129228-16.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 = 118771 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: Datatable cell wrapping

RossK1 pro premium priority asked 3 years ago

Hello, I am creating a datatable with 8 columns. Two of these columns have strings of ~40 characters. I need be able to show the full string by wrapping the text within the cell.

Expected behavior With a column width define, the cell text is wrapped to fit. Where it wraps (between words, on whitespace, hard character split) is not particularly important for this application, but wrapping on whitespace would be nice. I have tried manually wrapping by inserting
at appropriate locations in the string. This does cause the text to wrap, but it is still being truncated.

Actual behavior Text outside the column width (or perhaps with some preset constant) is truncated with "..." on the end.

Resources (screenshots, code snippets etc.) The example on the website will work fine for demonstration, So take the table here, I would like the entire message to be displayed as wrapped text.

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: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 3.10.1
  • Device: PC
  • Browser: Chrome 100
  • 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
Angular 9 , table examples not working
2
DataTables and ajax
1
Table Editor Example
About author
RossK1
Pro User Premium support
5Support score
6Questions 3Answers
0Snippets likes 5Snippets