OKCPilot

That is exactly what I ended up doing. Book a flight goes to a search box and requires a specific departure or arrival airport. Then loads schedules into or out of one airport. Works much better.

I just need to add pagination. I didn't build the site, I just joined recently. The way it currently stands that on one page it tries to load all the schedules is atrocious. Besides, even with a dedicated server, the bottleneck is going to be how quickly the end users browser can render the page and loading thousands of schedules is going to cripple even the best of machines.

You are absolutely right, I was being stupid 😅. phpVMS 5.5.2.72 =============== **Updated version of phpVMS 5.5.2 (simpilot) with PHP 7.2 compatibility** * Installation outside the parameters listed may not receive support (Apache 2.4, PHP 7.2, MySQL 5.6). I read that 2nd line of the readme and completely ignored the 1st line.

Thank you very much for this information. The readme file in the 5.5.2 install is unclear because it states 7.2 is the only stable and supported version of PHP for this version of phpVMS. Error reporting is on, on the dev server, off on prod. What version of PHP do you recommend for this install (except for obviously upgrading phpVMS).

I was running MySQL 5.7.37 however switched to MariaDB 10.2.24. This specific issue was resolved by upping the PHP Memory Limit from the default of 64M to 128M. However, the admin panel graphs and financial report data was not loading until I upgraded to MariaDB 10.2.24. The phpVMS version is 5.5.2 (simpilot).

[UPDATE] I was able to resolve the issue. The the server memory limit of 64M was too low and bumping it up to 128M in the php.ini resolve the render issue.

I am currently trying to transfer a website from Hostgator to another cPanel. I transferred the home directory, mysql database, changed the settings in local.config, and assigned db user permissions for the new db. Everything works except for the schedule search. From the source code it looks like everything in the head tags is not being loaded. The new server is running PHP 7.2, MySQL 5.7, and Apache 2.4. The old server was running MySQL 5.6 but I have been unable to install 5.6 because I don't want to break cPanel through an unsupported downgrade.