500 Error when trying to list short urls, or clicking through one #1862

RyanNutt · 2023-08-27T15:47:50Z

RyanNutt
Aug 27, 2023

Shlink version

3.6.3

PHP version

8.1

How do you serve Shlink

Self-hosted Apache

Database engine

MySQL

Database version

5.7

Summary

I'm having issues with one of my shlink servers. 4 total, this is the only one that's having issues and also the only one running with a MySQL database. The others are using SQLite and also an older version of shlink. Not sure which, but they've been running for a while. The MySQL server is running on a different VPS, but it's able to connect. The Visits, Orphan Visits, and Tags counters are showing the right values. Short URLs is showing 0, even though there should be 1.

On the home page on app.shlnk.io I'm seeing the following error under recently created URLs. Same error on the list short URLs page.

Something went wrong while loading short URLs :(

There's only one short url in the database right now, and if I try to go to it I get this error

An unexpected error occurred

Here are pastes of the log file from trying to work with the site in app.shlink.io.

Apache log for request

98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/health HTTP/1.1" 200 993 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"
98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/mercure-info HTTP/1.1" 501 504 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"
98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/tags/stats HTTP/1.1" 200 1195 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"
98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/visits HTTP/1.1" 200 5663 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"
98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/short-urls?itemsPerPage=5&orderBy=dateCreated-DESC HTTP/1.1" 500 1043 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"
98.195.252.127 - - [27/Aug/2023:15:18:23 +0000] "GET /rest/v3/tags/stats HTTP/1.1" 200 631 "https://app.shlink.io/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36"

Log File

[2023-08-27T15:37:29.768359+00:00] [7108ee93-8855-4116-b541-19b7cdcd66b8] Shlink.WARNING - This Shlink instance is not integrated with a mercure hub.
[2023-08-27T15:37:30.266576+00:00] [4e2c53f6-470b-4fdd-be1a-4455ce07c2e7] Shlink.ERROR - Error: Typed property Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl::$deviceLongUrls must not be accessed before initialization in /path/to/shlink/app/module/Core/src/ShortUrl/Entity/ShortUrl.php:338
Stack trace:
#0 /path/to/shlink/app/module/Core/src/ShortUrl/Transformer/ShortUrlDataTransformer.php(30): Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl->deviceLongUrls()
#1 [internal function]: Shlinkio\Shlink\Core\ShortUrl\Transformer\ShortUrlDataTransformer->transform()
#2 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Paginator/Util/PagerfantaUtilsTrait.php(38): array_map()
#3 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Paginator/Util/PagerfantaUtilsTrait.php(25): Shlinkio\Shlink\Rest\Action\ShortUrl\ListShortUrlsAction->serializeItems()
#4 /path/to/shlink/app/module/Rest/src/Action/ShortUrl/ListShortUrlsAction.php(36): Shlinkio\Shlink\Rest\Action\ShortUrl\ListShortUrlsAction->serializePaginator()
#5 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/RequestHandlerMiddleware.php(46): Shlinkio\Shlink\Rest\Action\ShortUrl\ListShortUrlsAction->handle()
#6 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Laminas\Stratigility\Middleware\RequestHandlerMiddleware->process()
#7 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#8 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#9 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Route.php(79): Laminas\Stratigility\MiddlewarePipe->process()
#10 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/RouteResult.php(109): Mezzio\Router\Route->process()
#11 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/DispatchMiddleware.php(32): Mezzio\Router\RouteResult->process()
#12 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\DispatchMiddleware->process()
#13 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#14 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#15 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#16 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(122): Laminas\Stratigility\Next->handle()
#17 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#18 /path/to/shlink/app/module/Rest/src/Middleware/AuthenticationMiddleware.php(52): Laminas\Stratigility\Next->handle()
#19 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Rest\Middleware\AuthenticationMiddleware->process()
#20 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#21 /path/to/shlink/app/module/Rest/src/Middleware/BodyParserMiddleware.php(34): Laminas\Stratigility\Next->handle()
#22 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Rest\Middleware\BodyParserMiddleware->process()
#23 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#24 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/ImplicitOptionsMiddleware.php(75): Laminas\Stratigility\Next->handle()
#25 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\ImplicitOptionsMiddleware->process()
#26 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#27 /path/to/shlink/app/module/Rest/src/Middleware/ErrorHandler/BackwardsCompatibleProblemDetailsHandler.php(22): Laminas\Stratigility\Next->handle()
#28 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Rest\Middleware\ErrorHandler\BackwardsCompatibleProblemDetailsHandler->process()
#29 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#30 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#31 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(62): Laminas\Stratigility\MiddlewarePipe->process()
#32 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process()
#33 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#34 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/ImplicitHeadMiddleware.php(77): Laminas\Stratigility\Next->handle()
#35 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\ImplicitHeadMiddleware->process()
#36 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#37 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/RouteMiddleware.php(50): Laminas\Stratigility\Next->handle()
#38 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\RouteMiddleware->process()
#39 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#40 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#41 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#42 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#43 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/CloseDbConnectionMiddleware.php(24): Laminas\Stratigility\Next->handle()
#44 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\CloseDbConnectionMiddleware->process()
#45 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#46 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#47 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#48 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(122): Laminas\Stratigility\Next->handle()
#49 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#50 /path/to/shlink/app/vendor/mezzio/mezzio-problem-details/src/ProblemDetailsMiddleware.php(46): Laminas\Stratigility\Next->handle()
#51 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\ProblemDetails\ProblemDetailsMiddleware->process()
#52 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#53 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#54 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(62): Laminas\Stratigility\MiddlewarePipe->process()
#55 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process()
#56 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#57 /path/to/shlink/app/module/Rest/src/Middleware/CrossDomainMiddleware.php(24): Laminas\Stratigility\Next->handle()
#58 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Rest\Middleware\CrossDomainMiddleware->process()
#59 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#60 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/ErrorHandler.php(129): Laminas\Stratigility\Next->handle()#61 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Laminas\Stratigility\Middleware\ErrorHandler->process()
#62 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#63 /path/to/shlink/app/vendor/php-middleware/request-id/src/RequestIdMiddleware.php(32): Laminas\Stratigility\Next->handle()
#64 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): PhpMiddleware\RequestId\RequestIdMiddleware->process()
#65 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#66 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/ContentLengthMiddleware.php(24): Laminas\Stratigility\Next->handle()
#67 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\ContentLengthMiddleware->process()
#68 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#69 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/AccessLogMiddleware.php(26): Laminas\Stratigility\Next->handle()#70 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\AccessLogMiddleware->process()
#71 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#72 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#73 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#74 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#75 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#76 /path/to/shlink/app/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#77 /path/to/shlink/app/vendor/mezzio/mezzio/src/Application.php(53): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#78 /path/to/shlink/app/config/run.php(13): Mezzio\Application->run()
#79 /path/to/shlink/app/public/index.php(5): {closure}()
#80 {main}

And here are the logs for the 500 error when trying to go to a short code. Same error, but slightly shorter trace. Only thing in the Apache log file is the request to the short url with a 500 error.

[2023-08-27T15:42:36.292881+00:00] [9202ff70-5657-4b80-b3cd-122b11a7368e] Shlink.ERROR - Error: Typed property Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl::$deviceLongUrls must not be accessed before initialization in /path/to/shlink/app/module/Core/src/ShortUrl/Entity/ShortUrl.php:203
Stack trace:
#0 /path/to/shlink/app/module/Core/src/ShortUrl/Helper/ShortUrlRedirectionBuilder.php(30): Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl->longUrlForDevice()
#1 /path/to/shlink/app/module/Core/src/Action/RedirectAction.php(29): Shlinkio\Shlink\Core\ShortUrl\Helper\ShortUrlRedirectionBuilder->buildShortUrlRedirect()
#2 /path/to/shlink/app/module/Core/src/Action/AbstractTrackingAction.php(35): Shlinkio\Shlink\Core\Action\RedirectAction->createSuccessResp()
#3 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Core\Action\AbstractTrackingAction->process()
#4 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#5 /path/to/shlink/app/module/Core/src/ShortUrl/Middleware/TrimTrailingSlashMiddleware.php(25): Laminas\Stratigility\Next->handle()
#6 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Core\ShortUrl\Middleware\TrimTrailingSlashMiddleware->process()
#7 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#8 /path/to/shlink/app/vendor/akrabat/ip-address-middleware/src/IpAddress.php(132): Laminas\Stratigility\Next->handle()
#9 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): RKA\Middleware\IpAddress->process()
#10 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#11 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#12 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Route.php(79): Laminas\Stratigility\MiddlewarePipe->process()
#13 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/RouteResult.php(109): Mezzio\Router\Route->process()
#14 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/DispatchMiddleware.php(32): Mezzio\Router\RouteResult->process()
#15 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\DispatchMiddleware->process()
#16 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#17 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#18 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#19 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(42): Laminas\Stratigility\Next->handle()
#20 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process()
#21 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#22 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/ImplicitHeadMiddleware.php(77): Laminas\Stratigility\Next->handle()
#23 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\ImplicitHeadMiddleware->process()
#24 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#25 /path/to/shlink/app/vendor/mezzio/mezzio-router/src/Middleware/RouteMiddleware.php(50): Laminas\Stratigility\Next->handle()
#26 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Mezzio\Router\Middleware\RouteMiddleware->process()
#27 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#28 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#29 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#30 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#31 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/CloseDbConnectionMiddleware.php(24): Laminas\Stratigility\Next->handle()
#32 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\CloseDbConnectionMiddleware->process()
#33 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#34 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#35 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#36 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(42): Laminas\Stratigility\Next->handle()
#37 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process()
#38 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle()
#39 /path/to/shlink/app/module/Rest/src/Middleware/CrossDomainMiddleware.php(24): Laminas\Stratigility\Next->handle()
#40 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Rest\Middleware\CrossDomainMiddleware->process()
#41 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#42 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Middleware/ErrorHandler.php(129): Laminas\Stratigility\Next->handle()#43 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Laminas\Stratigility\Middleware\ErrorHandler->process()
#44 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#45 /path/to/shlink/app/vendor/php-middleware/request-id/src/RequestIdMiddleware.php(32): Laminas\Stratigility\Next->handle()
#46 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): PhpMiddleware\RequestId\RequestIdMiddleware->process()
#47 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#48 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/ContentLengthMiddleware.php(24): Laminas\Stratigility\Next->handle()
#49 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\ContentLengthMiddleware->process()
#50 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#51 /path/to/shlink/app/vendor/shlinkio/shlink-common/src/Middleware/AccessLogMiddleware.php(26): Laminas\Stratigility\Next->handle()#52 /path/to/shlink/app/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Shlinkio\Shlink\Common\Middleware\AccessLogMiddleware->process()
#53 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process()
#54 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#55 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process()
#56 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#57 /path/to/shlink/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#58 /path/to/shlink/app/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#59 /path/to/shlink/app/vendor/mezzio/mezzio/src/Application.php(53): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /path/to/shlink/app/config/run.php(13): Mezzio\Application->run()
#61 /path/to/shlink/app/public/index.php(5): {closure}()
#62 {main}

Answered by RyanNutt

Aug 27, 2023

Not sure what the cause was, but your mention of caching sent me down a rabbit hole and I think it's working now.

2 servers, this one that's 3.6.3 and one that was 3.4.0 seemed to conflict somewhere. I'd restart apache and then go to one of the two and it would work fine. Didn't matter which. But the other would no longer work. Same errors. Restart apache and go to the other one first, and same thing. The second one I went to didn't work. Thought it might be opcache, but disabling it made no difference.

I upgrade the 3.4.0 site to 3.6.3 and now they both appear to be working fine.

Appreciate the help pointing me in the right direction, and really appreciate shlink. I've used similar progr…

View full answer

acelaya · 2023-08-27T15:56:51Z

acelaya
Aug 27, 2023
Maintainer

You probably have outdated information in cache. See #1684 (comment)

Have you recently updated Shlink and forgot to go through the update process?

7 replies

acelaya Aug 27, 2023
Maintainer

Are they sharing anything?

RyanNutt Aug 27, 2023
Author

I'm logged in to all in app.shlink.io, but no file sharing. They're all in individual folders and all have their own sqlite database, except for the one that's not working which has its own MySQL database.

If it helps, here's the config/params/generated_config.php file contents.

return array(
    'DB_DRIVER' => 'mysql',
    'DB_NAME' => '-removed-',
    'DB_HOST' => '-removed (remote IP)-',
    'DB_PORT' => '3306',
    'DB_USER' => '-removed-',
    'DB_PASSWORD' => '-removed-',
    'DB_UNIX_SOCKET' => null,
    'DEFAULT_DOMAIN' => '-removed-',
    'IS_HTTPS_ENABLED' => true,
    'DEFAULT_SHORT_CODES_LENGTH' => 5,
    'AUTO_RESOLVE_TITLES' => false,
    'REDIRECT_APPEND_EXTRA_PATH' => false,
    'MULTI_SEGMENT_SLUGS_ENABLED' => false,
    'SHORT_URL_TRAILING_SLASH' => true,
    'SHORT_URL_MODE' => 'loose',
    'GEOLITE_LICENSE_KEY' => '-removed-',
    'REDIRECT_STATUS_CODE' => 301,
    'REDIRECT_CACHE_LIFETIME' => 5,
    'DISABLE_TRACKING' => false,
    'TRACK_ORPHAN_VISITS' => true,
    'DISABLE_TRACK_PARAM' => null,
    'DISABLE_TRACKING_FROM' => null,
    'DISABLE_IP_TRACKING' => false,
    'ANONYMIZE_REMOTE_ADDR' => true,
    'DISABLE_UA_TRACKING' => false,
    'DISABLE_REFERRER_TRACKING' => false,
    'DEFAULT_BASE_URL_REDIRECT' => '-removed-',
    'DEFAULT_INVALID_SHORT_URL_REDIRECT' => '-removed-',
    'DEFAULT_REGULAR_404_REDIRECT' => '-removed-',
    'DEFAULT_QR_CODE_SIZE' => 300,
    'DEFAULT_QR_CODE_MARGIN' => 0,
    'DEFAULT_QR_CODE_FORMAT' => 'png',
    'DEFAULT_QR_CODE_ERROR_CORRECTION' => 'l',
    'DEFAULT_QR_CODE_ROUND_BLOCK_SIZE' => true,
    'DELETE_SHORT_URL_THRESHOLD' => null,
    'BASE_PATH' => '',
    'TIMEZONE' => 'America/Chicago',
    'REDIS_SERVERS' => null,
);

RyanNutt Aug 27, 2023
Author

Tried removing the tags from the short url via cli and no change. Deleted the short url and the error went away. Added one back in without tags and the error is back.

There are a couple of tags that are the same in more than one of the installs, and I noticed that some tag information is stored in local storage. Is it possible there's a conflict in local storage or cookies?

RyanNutt Aug 27, 2023
Author

Not sure what the cause was, but your mention of caching sent me down a rabbit hole and I think it's working now.

2 servers, this one that's 3.6.3 and one that was 3.4.0 seemed to conflict somewhere. I'd restart apache and then go to one of the two and it would work fine. Didn't matter which. But the other would no longer work. Same errors. Restart apache and go to the other one first, and same thing. The second one I went to didn't work. Thought it might be opcache, but disabling it made no difference.

I upgrade the 3.4.0 site to 3.6.3 and now they both appear to be working fine.

Appreciate the help pointing me in the right direction, and really appreciate shlink. I've used similar programs before, and even wrote my own at one point, and nothing has compared.

Answer selected by acelaya

acelaya Aug 27, 2023
Maintainer

Shlink uses APCu cache when redis is not available. I'm thinking both instances conflicted because they accidentally ended up sharing the same cache.

I'll probably need to make Shlink generate a unique prefix so that multiple instances running with shared cache don't conflict.

acelaya Sep 17, 2023
Maintainer

See #1879

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

500 Error when trying to list short urls, or clicking through one #1862

{{title}}

Replies: 1 comment 7 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

500 Error when trying to list short urls, or clicking through one #1862

RyanNutt Aug 27, 2023

Shlink version

PHP version

How do you serve Shlink

Database engine

Database version

Summary

Replies: 1 comment · 7 replies

acelaya Aug 27, 2023 Maintainer

acelaya Aug 27, 2023 Maintainer

RyanNutt Aug 27, 2023 Author

RyanNutt Aug 27, 2023 Author

RyanNutt Aug 27, 2023 Author

acelaya Aug 27, 2023 Maintainer

acelaya Sep 17, 2023 Maintainer

RyanNutt
Aug 27, 2023

Replies: 1 comment 7 replies

acelaya
Aug 27, 2023
Maintainer

acelaya Aug 27, 2023
Maintainer

RyanNutt Aug 27, 2023
Author

RyanNutt Aug 27, 2023
Author

RyanNutt Aug 27, 2023
Author

acelaya Aug 27, 2023
Maintainer

acelaya Sep 17, 2023
Maintainer