Error 500 when migrate from 4.5.50 to 5.5.28

[zak3]

hi,

i have a selfhosted v4.5.50 working correctly, and installed v5.5.28 on my hosting that is also working.
when i try to launch migration from v4 and after setting credentials on migration process i get error 500.

checked laravel log and here’s what i found

[2022-10-13T09:15:26.466235+00:00] production.ERROR: GuzzleHttp\Exception\RequestException [0] : C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php [Line 201] => cURL error 60: SSL certificate problem: unable to get local issuer certificate (see libcurl - Error Codes) {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Zakaria Malha”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0”,“locale”:“fr”,“ip”:“::1”,“count”:4,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“migration/auth”} []
[2022-10-13T09:15:26.484186+00:00] production.ERROR: [stacktrace] 2022-10-13 09:15:26 cURL error 60: SSL certificate problem: unable to get local issuer certificate (see libcurl - Error Codes): #0 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(155): GuzzleHttp\Handler\CurlFactory::createRejection(Object(GuzzleHttp\Handler\EasyHandle), Array) #1 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(105): GuzzleHttp\Handler\CurlFactory::finishError(Object(GuzzleHttp\Handler\CurlHandler), Object(GuzzleHttp\Handler\EasyHandle), Object(GuzzleHttp\Handler\CurlFactory)) #2 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\CurlHandler.php(43): GuzzleHttp\Handler\CurlFactory::finish(Object(GuzzleHttp\Handler\CurlHandler), Object(GuzzleHttp\Handler\EasyHandle), Object(GuzzleHttp\Handler\CurlFactory)) #3 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php(28): GuzzleHttp\Handler\CurlHandler->__invoke(Object(GuzzleHttp\Psr7\Request), Array) #4 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php(51): GuzzleHttp\Handler\Proxy::GuzzleHttp\Handler{closure}(Object(GuzzleHttp\Psr7\Request), Array) #5 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\PrepareBodyMiddleware.php(66): GuzzleHttp\Handler\Proxy::GuzzleHttp\Handler{closure}(Object(GuzzleHttp\Psr7\Request), Array) #6 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Middleware.php(29): GuzzleHttp\PrepareBodyMiddleware->__invoke(Object(GuzzleHttp\Psr7\Request), Array) #7 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\RedirectMiddleware.php(54): GuzzleHttp\Middleware::GuzzleHttp{closure}(Object(GuzzleHttp\Psr7\Request), Array) #8 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Middleware.php(59): GuzzleHttp\RedirectMiddleware->__invoke(Object(GuzzleHttp\Psr7\Request), Array) #9 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\HandlerStack.php(71): GuzzleHttp\Middleware::GuzzleHttp{closure}(Object(GuzzleHttp\Psr7\Request), Array) #10 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Client.php(351): GuzzleHttp\HandlerStack->__invoke(Object(GuzzleHttp\Psr7\Request), Array) #11 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Client.php(162): GuzzleHttp\Client->transfer(Object(GuzzleHttp\Psr7\Request), Array) #12 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Client.php(182): GuzzleHttp\Client->requestAsync(‘post’, Object(GuzzleHttp\Psr7\Uri), Array) #13 C:\wamp64\www\invoiceninja\vendor\guzzlehttp\guzzle\src\Client.php(95): GuzzleHttp\Client->request(‘post’, ‘https://in.mads…’, Array) #14 C:\wamp64\www\invoiceninja\app\Services\Migration\AuthService.php(60): GuzzleHttp\Client->__call(‘post’, Array) #15 C:\wamp64\www\invoiceninja\app\Http\Controllers\Migration\StepsController.php(287): App\Services\Migration\AuthService->start() #16 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): App\Http\Controllers\Migration\StepsController->handleAuth(Object(App\Http\Requests\MigrationAuthRequest)) #17 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction(‘handleAuth’, Array) #18 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Migration\StepsController), ‘handleAuth’) #19 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Route.php(176): Illuminate\Routing\Route->runController() #20 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Router.php(681): Illuminate\Routing\Route->run() #21 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #22 C:\wamp64\www\invoiceninja\app\Http\Middleware\EligibleForMigration.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #23 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\EligibleForMigration->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 C:\wamp64\www\invoiceninja\app\Http\Middleware\Authenticate.php(122): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #25 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), ‘user’) #26 C:\wamp64\www\invoiceninja\app\Http\Middleware\DatabaseLookup.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #27 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\DatabaseLookup->handle(Object(Illuminate\Http\Request), Object(Closure), ‘user’) #28 C:\wamp64\www\invoiceninja\app\Http\Middleware\StartupCheck.php(240): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #29 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\StartupCheck->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 C:\wamp64\www\invoiceninja\app\Http\Middleware\QueryLogging.php(32): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #31 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 C:\wamp64\www\invoiceninja\app\Http\Middleware\DuplicateSubmissionCheck.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #33 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\DuplicateSubmissionCheck->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #35 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #36 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #37 C:\wamp64\www\invoiceninja\app\Http\Middleware\VerifyCsrfToken.php(44): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #40 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #42 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #44 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #46 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #48 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #49 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #50 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #51 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Routing\Router.php(613): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(170): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) #54 C:\wamp64\www\invoiceninja\vendor\barryvdh\laravel-debugbar\src\Middleware\InjectDebugbar.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #55 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #57 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #59 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #60 C:\wamp64\www\invoiceninja\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #61 C:\wamp64\www\invoiceninja\public\index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #62 {main} {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Zakaria Malha”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0”,“locale”:“fr”,“ip”:“::1”,“count”:5,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“migration/auth”} []

can someone help

[hillel]

Hi,

If you’re using a self signed certificate it may help to use Let’s Encrypt instead.

[zak3]

i moved the selfhosted v4 to another domain with SSL certificate and migration was done correctly.

thank you hillel