The issue
The upgrade process went smoothly,but there was an issue during the `migration：
In Connection.php line 712:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'fof_upload_files_actor_id_hide_from_media_manag
er_index'; check that column/key exists (SQL: alter table `fof_upload_files` drop index `fof_upload_files_actor_id_
hide_from_media_manager_index`)
In Exception.php line 18:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'fof_upload_files_actor_id_hide_from_media_manag
er_index'; check that column/key exists
In PDOStatement.php line 117:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'fof_upload_files_actor_id_hide_from_media_manag
er_index'; check that column/key exists
So I tried to remove fof_upload and migrate without any errors.Then reinstall fof_upload.The installation was successful, but it seems that it cannot be enabled in the management panel.The web browser has recorded some status:
{
"errors": [
{
"status": "405",
"code": "method_not_allowed",
"detail": "Flarum\\Http\\Exception\\MethodNotAllowedException: GET in C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\ResolveRoute.php:62\nStack trace:\n#0 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\ResolveRoute->process()\n#1 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\SetLocale.php(51): Laminas\\Stratigility\\Next->handle()\n#2 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\SetLocale->process()\n#3 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\AuthenticateWithHeader.php(58): Laminas\\Stratigility\\Next->handle()\n#4 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process()\n#5 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\AuthenticateWithSession.php(31): Laminas\\Stratigility\\Next->handle()\n#6 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\AuthenticateWithSession->process()\n#7 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\RememberFromCookie.php(52): Laminas\\Stratigility\\Next->handle()\n#8 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\RememberFromCookie->process()\n#9 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\StartSession.php(61): Laminas\\Stratigility\\Next->handle()\n#10 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\StartSession->process()\n#11 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Api\\Middleware\\FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle()\n#12 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Api\\Middleware\\FakeHttpMethods->process()\n#13 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle()\n#14 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\ParseJsonBody->process()\n#15 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\HandleErrors.php(57): Laminas\\Stratigility\\Next->handle()\n#16 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\HandleErrors->process()\n#17 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\InjectActorReference.php(25): Laminas\\Stratigility\\Next->handle()\n#18 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\InjectActorReference->process()\n#19 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\MiddlewarePipe.php(75): Laminas\\Stratigility\\Next->handle()\n#20 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\middlewares\\request-handler\\src\\RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process()\n#21 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Middlewares\\RequestHandler->process()\n#22 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\middlewares\\base-path-router\\src\\BasePathRouter.php(101): Laminas\\Stratigility\\Next->handle()\n#23 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Middlewares\\BasePathRouter->process()\n#24 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Middleware\\OriginalMessages.php(36): Laminas\\Stratigility\\Next->handle()\n#25 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Laminas\\Stratigility\\Middleware\\OriginalMessages->process()\n#26 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\middlewares\\base-path\\src\\BasePath.php(73): Laminas\\Stratigility\\Next->handle()\n#27 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Middlewares\\BasePath->process()\n#28 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Middleware\\ProcessIp.php(24): Laminas\\Stratigility\\Next->handle()\n#29 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\Next.php(49): Flarum\\Http\\Middleware\\ProcessIp->process()\n#30 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\MiddlewarePipe.php(75): Laminas\\Stratigility\\Next->handle()\n#31 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-stratigility\\src\\MiddlewarePipe.php(64): Laminas\\Stratigility\\MiddlewarePipe->process()\n#32 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\laminas\\laminas-httphandlerrunner\\src\\RequestHandlerRunner.php(73): Laminas\\Stratigility\\MiddlewarePipe->handle()\n#33 C:\\phpstudy_pro\\WWW\\flarum\\vendor\\flarum\\core\\src\\Http\\Server.php(45): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#34 C:\\phpstudy_pro\\WWW\\flarum\\public\\index.php(26): Flarum\\Http\\Server->listen()\n#35 {main}"
}
]
}
Flarum information
Flarum-1.8.5
PHP-8.0.2
MySQL-8.0.12
