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

DatePicker IMyOption disableSince Option

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-190f69-e.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 = 101782 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: DatePicker IMyOption disableSince Option

Jan Louw pro asked 6 years ago

Hi,

Using the DatePicker disableSince options and trying to set it to current date parameters, results in wrong date.

Code Snippet:

myDatePickerOptions: IMyOptions;

constructor(private cdRef: ChangeDetectorRef, private dbsrv: DbService, public datepipe: DatePipe) {}

 ngOnInit() {
   this.myDatePickerOptions = {
     closeAfterSelect: true,
     showClearDateBtn: false,
     disableSince: { year: this.nowDate.getFullYear(), month: this.nowDate.getMonth(), day: this.nowDate.getDay() }
   };
   console.log('DatePicker Options: %s', JSON.stringify(this.myDatePickerOptions));
   console.log('Date: %s', JSON.stringify(this.nowDate));
 }

Console Output:

DatePicker Options: {"closeAfterSelect":true,"showClearDateBtn":false,"disableSince":{"year":2019,"month":7,"day":3}}

Date: "2019-08-28T12:46:50.031Z"

Any idea why the month and day is incorrect?

Regards


Jan Louw pro commented 6 years ago

Hi,

Being the first time looking at date/time processing in Javascript / Typescript, I've realized my confusion around the getMonth() and getDay()/getDate() function calls on Date object. Apologies for adding this ... :( . Regards


Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Resolved

Specification of the issue
  • User: Pro
  • Premium support: No
  • Technology: MDB Angular
  • MDB Version: 8.1.1
  • Device: Na
  • Browser: Na
  • OS: Ubuntu 16:04
  • Provided sample code: No
  • Provided link: No
Tags