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

MDBDatatable Dynamic Data Links

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-5916e1-1ff.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 = 108180 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: MDBDatatable Dynamic Data Links

kalmservices pro premium asked 6 years ago

Expected behavior Passing a JSON object with string values into the table data, the HTML would be parsed out into a link.

Actual behavior The literal string is being put into the column data, this is how it works within traditional datatables, so I'm looking for a solution to do this here. The data is all provided from an API which provides the json object asynchronously after page load, and the JSON object will not always look the same, so I need to code with the expectation that the table can handle the json object for columns an the json object for the rows.

Resources (screenshots, code snippets etc.)

This is what the table drops out, just a string literal anchor tag

Piotr Glejzer staff commented 6 years ago

do you have data from API to show to test it?

kalmservices pro premium commented 6 years ago

{"columns":[{"field":"DETAIL","label":""},{"field":"FULLNAME","label":"Name"},{"field":"PROMOTIONALIAS","label":"Promotion"},{"field":"VENDORTYPES","label":"Type"},{"field":"CONTACT","label":"Primary Contact"},{"field":"WEBADDRESS","label":"Web Address"},{"field":"STATUS","label":"Status"}],"rows":[{"FULLNAME":"bname","PROMOTIONALIAS":null,"VENDORTYPES":"Promotion","WEBADDRESS":null,"CONTACT":null,"STATUS":"Button","DETAIL":"[]"},{"FULLNAME":"test promo 1","PROMOTIONALIAS":null,"VENDORTYPES":"Promotion","WEBADDRESS":null,"CONTACT":null,"STATUS":"Button","DETAIL":"[]"},{"FULLNAME":"wcfc csdc sc cdfc sc d","PROMOTIONALIAS":null,"VENDORTYPES":"Promotion","WEBADDRESS":null,"CONTACT":null,"STATUS":"Button","DETAIL":"[]"},{"FULLNAME":"wreewrwer","PROMOTIONALIAS":null,"VENDORTYPES":"Promotion","WEBADDRESS":null,"CONTACT":null,"STATUS":"Button","DETAIL":"[]"}]}

kalmservices pro premium commented 6 years ago

Previous comment is the json being passed back, this is the react component I'm passing that into:

                    <MDBDataTable
                        btn
                        striped
                        bordered
                        hover
                        data={this.data}
                    />

Piotr Glejzer staff commented 6 years ago

I will try to test it and resolve this problem.

kalmservices pro premium commented 5 years ago

So we have premium support, and I asked this question 3 months ago and never received an answer. Did anyone ever look into this issue?
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 React
  • MDB Version: 4.26.0
  • Device: Desktop
  • Browser: Chrome
  • OS: Windows 8
  • Provided sample code: No
  • Provided link: No
Tags
mdbdatatable
Related topics
3
TableEditor Plugin
2
Attributes in MDBDataTable not working?
1
MDBDataTable Material Design entries input: Not working without custom css
1
One column header should be All Capital Letters with Sorting capabilities
1
MDBDataTable search filter is not honored after state change
About author
kalmservices
Pro User Premium support
15Support score
3Questions 0Answers
0Snippets likes 1Snippets

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-5916e1-203.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-5916e1-204.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`