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

Angular Autocomplete Remote Data Issue

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-129526-2d.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 = 93159 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: Angular Autocomplete Remote Data Issue

Jazzguitar68 asked 7 years ago

Hey Folks,

I just started working with Angular not too long ago and recently purchased a pro license here.  When trying to get the Autocomplete control to use remote data from an Oracle ORDS API I get the error "You provided 'null' where a stream was expected.  You can provide an Observable, Promise, Array or Iterable".  The only difference between success and fail is the change of URL to the individual APIs.

When looking at the APIs through Postman I see the following returns.

Data Return from sample API:

[{
"name": "Afghanistan",
"code": "AF",
"flag": "demo/res/img/af.png"
},

 

Data Return from Oracle ORD:

{
"items": [
{
"customer_id": 568451,
"name": "<Customer Name>"
},

 

Any help would be much appreciated.

 

Thanks,

Wayne

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

Resolved

Specification of the issue
  • User: Free
  • Premium support: No
  • Technology: MDB Angular
  • MDB Version: 7.0.0
  • Device: Surface Book 2
  • Browser: Chrome
  • OS: Win10
  • Provided sample code: No
  • Provided link: No
Tags
angular oracle autocomplete
Related topics
0
MDB Angular Autocomplete Documentation (Non-functional)
0
Prevent autocomplete from focusing the first option once data loads in
0
Custom element in autocomplete component with (click) doesnt work
0
Is there any trial version of auto complete in angular 9
0
Angular 8 Autocomplete | Remote call after input event
About author
Jazzguitar68
10Support score
2Questions 0Answers
0Snippets likes 0Snippets