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

Angular MDB auto-completer with REST API

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-12bea9-1b.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 = 108050 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: Angular MDB auto-completer with REST API

JeroenVunderink pro premium priority asked 5 years ago

Could you please provide me a link or example where auto-completer (MDB 9+) will work with retrieving the data from a restAPI? Trying to make this work, but have some issues. Would like to understand this better. My example code is underneath. Would appreciate the help.

Explain: The DogService returns a JSON array from a restAPI based on the filter provide and only starts after 3 characters.

TS:

> import { Component, OnInit } from '@angular/core'; import { Router } from '@angular/router'; import { Observable, Subject } from 'rxjs'; import { map } from 'rxjs/operators'; import { HttpClient } from '@angular/common/http'; import { DogService } from '../../services/dog.service'; import { environment } from '../../../environments/environment';

@Component({ selector: 'form-dogs', templateUrl: './dogs.component.html', styleUrls: ['./dogs.component.scss'] }) export class DogsForm implements OnInit {

dog = null; // Dogs lookup searchText = new Subject(); url = environment.apiUrl + '/searchdogs'; results: Observable; data: any = [];

constructor(private router: Router, private apiService: DogService) { }

ngOnInit(): void { this.results = this.searchText .pipe( map((value: string) => this.filter(value)) ); }

filter(value: string): string[] | undefined { const filterValue = value.toLowerCase().trim().replace(' ', '%'); if (filterValue.length < 3) { return; } this.data = this.apiService.searchDogs(filterValue); console.log(this.data); return this.data; } }

HTML:

<div class="md-form">
    <mdb-icon fas icon="search" aria-hidden="true"></mdb-icon>
    <input type="text" [ngModel]="searchText | async" (ngModelChange)="searchText.next($event)"
        class="completer-input form-control mdb-autocomplete mb-0" [mdbAutoCompleter]="auto" placeholder="Search" />
    <mdb-auto-completer #auto="mdbAutoCompleter"
        textNoResults="Start typing (at least 2 character) and max return is 50 dogs...">
        <mdb-option *ngFor="let option of results | async" [value]="option.name">
            <div class="d-flex justify-content-between align-items-center w-100">
                <span>{{ option.name }}</span>
                <img [src]="option.icon" alt="{{ option.name }} photo" class="completer-image" />
            </div>
        </mdb-option>
    </mdb-auto-completer>
</div>

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 Angular
  • MDB Version: 9.1.0
  • Device: MacBook
  • Browser: Chrome
  • OS: MacOS
  • Provided sample code: No
  • Provided link: No