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

mdbTable does not sort when property value is NULL.

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-154e6c-11d.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 = 95938 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 Angular
Topic: mdbTable does not sort when property value is NULL.

peter.r.bladh@saabgroup.com asked 6 years ago

The mdbTable does not sort correct when having property values that is NULL.

When debugging, the following (compare) function will return 0 if a value is NULL.

 function (a, b) {
        /** @type {?} */
        var i = 0;
        while (i < key.length) {
            a = a[key[i]];
            b = b[key[i]];
            i++;
        }
        if (a < b) {
            return _this.sorted ? 1 : -1;
        }
        else if (a > b) {
            return _this.sorted ? -1 : 1;
        }
        else {
            return 0;
        }
    }));
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 Angular
  • MDB Version: 7.4.2
  • Device: PC
  • Browser: Chrome
  • OS: Windows
  • Provided sample code: No
  • Provided link: No
Tags
mdbtable table sort null
Related topics
0
mdbTable does not sort when using properties including capital characters.
0
How to display null values in MDBTable
1
MDB Table Editor Plugin Fields validation on Add and Edit
1
Table sort with eastern Europe characters
1
Sort table by dates
About author
peter.r.bladh@saabgroup.com
170Support score
12Questions 11Answers
0Snippets likes 1Snippets