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

datepicker bug

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-14d809-3ed.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 = 127861 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

ammi pro asked 9 months ago

if you select format "mm/dd/yy" datepicker displays data correctly. If you insert new data it populates and display data correctly, but if you update existing data it will be populated with invalid 2-digit year. For example, if data.nextDate (public nextDate!: Date | null;) is null and I click on datepicker and select December 31, data.nextDate will be 12/31/2024. If data.nextDate is 12/31/2024, it will be displayed correctly as 12/31/24. However, if I click on datepicker and change date to December 30, data.nextDate will be 12/30/24 instead of 12/30/2024. If I click Clear button first and then select December 30, data.nextDate will be 12/30/2024. Please fix this bug. Thank you.

            <mdb-form-control>
          <input
            [(ngModel)]="data.nextDate"
            mdbInput
            [mdbDatepicker]="dpNextDate "
            type="text"
            class="form-control"
            (keydown)="false"
            (click)="dpNextDate .open()"

          />
          <mdb-datepicker-toggle [mdbDatepicker]="dpNextDate "></mdb-datepicker-toggle>
          <mdb-datepicker #dpNexDate 
              [confirmDateOnSelect]="true"
              [removeClearBtn]="false" 
              [format]="'mm/dd/yy'">
          </mdb-datepicker>

        </mdb-form-control>

Arkadiusz Idzikowski staff commented 8 months ago

I added this to our to-do list. We will check that and let you know what we found (or add a fix).


Please insert min. 20 characters.

FREE CONSULTATION

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

Status

Open

Specification of the issue
  • User: Pro
  • Premium support: No
  • Technology: MDB Angular
  • MDB Version: MDB5 6.1.0
  • Device: Desktop
  • Browser: Chrome
  • OS: W1-
  • Provided sample code: No
  • Provided link: No