After Migrating Servers All Lookup Tables Give "The Results Could Not Be Loaded"

SilentNight · June 27, 2023, 11:05pm

Javascript Errors:

GET https://[ourdomain]/overlayscrollbars.min.css?v=19.13.7 net::ERR_ABORTED 404
POST https://[ourdomain]/api/lookup 404
POST https://[ourdomain]/api/lookup?q=&n=100&rnd=186215&start=-1 404

PHP Errors:

[2023-06-27T18:56:02.670218-04:00] log.DEBUG: 404 Not Found Type: Slim\Exception\HttpNotFoundException Code: 404 Message: Route &#039;api/lookup&#039; not found. File: /home/[oursitedirectory]/htdocs/[ourdomain]/src/routes.php Line: 791 Trace: #0 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(38): Closure->PHPMaker2023\MHS\{closure}() #1 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke() #2 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\Routing\Route->handle() #3 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle() #4 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/Route.php(315): Slim\MiddlewareDispatcher->handle() #5 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/RouteRunner.php(68): Slim\Routing\Route->run() #6 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/BodyParsingMiddleware.php(64): Slim\Routing\RouteRunner->handle() #7 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\BodyParsingMiddleware->process() #8 /home/[oursitedirectory]/htdocs/[ourdomain]/src/CorsMiddleware.php(44): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #9 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): PHPMaker2023\MHS\CorsMiddleware->process() #10 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #11 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process() #12 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/selective/samesite-cookie/src/SameSiteCookieMiddleware.php(52): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #13 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Selective\SameSiteCookie\SameSiteCookieMiddleware->process() #14 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/selective/samesite-cookie/src/SameSiteSessionMiddleware.php(44): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #15 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Selective\SameSiteCookie\SameSiteSessionMiddleware->process() #16 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #17 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process() #18 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #19 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle() #20 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/App.php(183): Slim\App->handle() #21 /home/[oursitedirectory]/htdocs/[ourdomain]/index.php(134): Slim\App->run() #22 {main} [] []
[2023-06-27T18:56:05.612167-04:00] log.DEBUG: 404 Not Found Type: Slim\Exception\HttpNotFoundException Code: 404 Message: Route &#039;api/lookup&#039; not found. File: /home/[oursitedirectory]/htdocs/[ourdomain]/src/routes.php Line: 791 Trace: #0 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(38): Closure->PHPMaker2023\MHS\{closure}() #1 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke() #2 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\Routing\Route->handle() #3 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle() #4 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/Route.php(315): Slim\MiddlewareDispatcher->handle() #5 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Routing/RouteRunner.php(68): Slim\Routing\Route->run() #6 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/BodyParsingMiddleware.php(64): Slim\Routing\RouteRunner->handle() #7 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\BodyParsingMiddleware->process() #8 /home/[oursitedirectory]/htdocs/[ourdomain]/src/CorsMiddleware.php(44): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #9 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): PHPMaker2023\MHS\CorsMiddleware->process() #10 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #11 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process() #12 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/selective/samesite-cookie/src/SameSiteCookieMiddleware.php(52): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #13 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Selective\SameSiteCookie\SameSiteCookieMiddleware->process() #14 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/selective/samesite-cookie/src/SameSiteSessionMiddleware.php(44): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #15 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Selective\SameSiteCookie\SameSiteSessionMiddleware->process() #16 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #17 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process() #18 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #19 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle() #20 /home/[oursitedirectory]/htdocs/[ourdomain]/vendor/slim/slim/Slim/App.php(183): Slim\App->handle() #21 /home/[oursitedirectory]/htdocs/[ourdomain]/index.php(134): Slim\App->run() #22 {main} [] []

SilentNight · June 28, 2023, 12:03am

Solved, it was an issue with the NGINX vhost configuration file since the new server uses port 17001 for php-fpm instead of port 9123. I found what port it uses in the config file located at /etc/php/8.2/fpm/pool.d in the line that looks like listen = 127.0.0.1:17001. To fix it I changed the NGINX vhost configuration located at /etc/nginx/sites-enabled from this:

    location ~ \.php {
        fastcgi_pass 127.0.0.1:9123;
    }

to this:

    location ~ \.php {
        fastcgi_pass 127.0.0.1:17001;
    }