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

Installing MDB React Pro and using SCSS files

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-160bab-37.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 = 104814 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


Topic: Installing MDB React Pro and using SCSS files

jimgroome asked 6 years ago

Expected behavior

Copy asset files as described here and run my site as expected.

Actual behavior

Copy asset files as described here and build throws lots of errors, unable to find fonts and images.

Fix

In index.js, instead of importing mdb.scss, you have to import mdb-pro.scss:

import "./assets/scss/mdb-pro.scss";

In assets/scss/core/_masks.scss, replace line 75:

background: url("#{$image-path}/overlays/#{$filename}.png");

With this:

background: url("../#{$image-path}/overlays/#{$filename}.png");

In assets/scss/core/_variables.scss, replace line 173:

$image-path: "../../img" !default;

With this:

$image-path: "../img" !default;

And replace lines 323 and 324:

$carousel-control-prev-icon: url(#{$image-path}/svg/arrow_left.svg) !default;
$carousel-control-next-icon: url(#{$image-path}/svg/arrow_right.svg) !default;

With this:

$carousel-control-prev-icon: url(../#{$image-path}/svg/arrow\_left.svg) !default;
$carousel-control-next-icon: url(../#{$image-path}/svg/arrow\_right.svg) !default;

Finally, in assets/scss/pro/_variables.scss, replace lines 546 to 548:

$pswp\_\_button-background: url(#{$image-path}/lightbox/default-skin.png) !default;
$pswp\_\_button-background-image: url(#{$image-path}/lightbox/default-skin.svg) !default;
$pswp\_\_preloader\_\_icn-background: url(#{$image-path}/lightbox/preloader.gif) !default;

With this:

$pswp\_\_button-background: url(../../../#{$image-path}/lightbox/default-skin.png) !default;
$pswp\_\_button-background-image: url(../../../#{$image-path}/lightbox/default-skin.svg) !default;
$pswp\_\_preloader\_\_icn-background: url(../../../#{$image-path}/lightbox/preloader.gif) !default;

As far as I can tell, this isn't covered in any documentation and left me a bit lost. I'm putting my fixes here in case anybody else encounters the same issue.


Piotr Glejzer staff commented 6 years ago

Thanks for this post. Yes, you are right. There is a problem with scss because we are using scss from jQuery to keep cohesion but they changed scss and we forgot to update our docs about that. Sorry about this. Have a nice day.


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.23.1
  • Device: PC
  • Browser: Chrome
  • OS: Windows
  • Provided sample code: No
  • Provided link: Yes