--Solved-- Airports not showing when searching

[NovayBE]

Solved

it was a Database conflict whit my home server and hosting 

 

Hy, 

my sincere apologies for my “bad English”

I recently noticed when i want to add, for example an flight or an airplane that when i want to fill in the location it’s searching whiteout showing any results see image.

yes i have a list of locations in the database and everything was working fine until now and I can’t figure out why it doesn’t work anymore.

and i use the latest dev version.

php version 8.1 

Mysql version  4.9.7

Edited October 30, 2023 by NovayBE
SOLVED

[ProAvia]

Glad you were able to solve your issue.

[DisposableHero]

Possible other causes of airport dropdowns not working

 

• Cross Origin Scripting Errors
  (APP_URL should match your current url, having http in .env but using https while visiting your website fails due to cross origin restrictions, can be solved either by fixin the APP_URL or allowing cross origin scripting between your domains)
• Custom Theme Errors
  (Dropdown live search introduced recently, so if your theme is not properly configured to utilize the scripts and select2 features it will fail)
• Custom Blade Errors
  (If you have an edited theme, they need to be updated to utilize the search properly, check provided default theme from original source: github or from latest dev release, implement the necessary changes to your blades)

Hope this helps people in the future

[filipet]

Hello, I have the same problem. Using default theme on https. It works just for a moment after cleaning cache. May it be connected with adding full base of airports?

Edited November 12, 2023 by filipet

[ProAvia]

6 hours ago, filipet said:

Hello, I have the same problem. Using default theme on https. It works just for a moment after cleaning cache. May it be connected with adding full base of airports?

 

How many airports is a "full base"?

Adding every airport available will slow your site down. And chances are you will never fly to even 1/2 of those airports. Only add the airports you intended to have routes to.

 

If you are still having issues, check the logs as explained in the docs and post the errors here.

[filipet]

6 hours ago, ProAvia said:

 

How many airports is a "full base"?

Adding every airport available will slow your site down. And chances are you will never fly to even 1/2 of those airports. Only add the airports you intended to have routes to.

 

If you are still having issues, check the logs as explained in the docs and post the errors here.

 

I've uploaded this: 

 

I have reinstalled phpVMS and now will be adding airports one by one, everything seems to be okay.

Sorry for bothering you.

 

I have a question. Are airports that are not added, going to be added automatically when filing a pirep via ACARS without biding?

 

Brgds.

Edited November 13, 2023 by filipet

[DisposableHero]

1 hour ago, filipet said:

 

I've uploaded this: 

 

I have reinstalled phpVMS and now will be adding airports one by one, everything seems to be okay.

Sorry for bothering you.

 

I have a question. Are airports that are not added, going to be added automatically when filing a pirep via ACARS without biding?

 

Brgds.

 

Technically speaking adding 40k+ airports or any number should not affect the latest loading system, as it is simply searching live as you type or gets the first 20 or 50 to build the dropdown, then loads more as you scroll.

 

There may be another problem (or problems) affecting live search/load. When it is not working be sure to check your browser console for any errors. And be sure what you are importing, is the file fully compatible with v7 (I remember that file having some problems before, did not checked later for updates)

 

And for your question, answer is "Yes" as long as your settings allow automated lookups and unadded airport usage (in some rare cases lookup may fail, like an airport can not be found in VaCentral database, ICAO code mistyped, ICAO code changed etc)

 

Good luck

[DanFlutter]

Hi everyone:

 

Thanks for the details in this issue, I will try the workarounds described above.

I installed phpvms 7 dev branch in a local delployment and worked perfectly.

 

However, when I moved this install to the hosting server and changed the details in the .env file for db, everything seemed to be working perfectly, except for the pulldowns for the airports anywhere on the site. Definitely is a "cross-origin scripting error because the local install with the subdomain "localops.virtualairline.com", works just fine.

 

I've changed last night the APP_URL to reflect the new URL name, I will check today after clearing the cache if this fixed it.

 

Also, I've imported a list of all airports in the world, I think there are about 14k, and if this affects negatively in some way I will replace it with the list published by filipet

 

Thanks!

UPDATE: Just fixed- I've validated that the APP_URL was the correct one, and as we are forcing all connections to Secure (https), also validated the APP_URL says https://ops.airline.net for example and not just http://, and cleared all the caches, views and application, this just fixed the airport dropdown list issue.

 

Edited November 20, 2023 by DanFlutter