Upgrade from v3.0.4-beta.22 to v3.0.4-beta.28 error

remmarpidong

upgrade did not complete and with error

“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘prima_sessions_webview’ already exists (SQL: create table prima_sessions_webview (id varchar(128) not null, user_id bigint unsigned null, ip_address varchar(45) null, user_agent text null, payload text not null, last_activity int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)” on line 669 of /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Connection.php#0 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback(‘create table p...', Array, Object(Closure)) #1 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Illuminate\Database\Connection->run('create tablep…', Array, Object(Closure)) #2 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement(‘create table `p…’) #3 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #4 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(167): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #5 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->create(‘sessions_webvie…’, Object(Closure)) #6 /home3/nlinespy/public_html/online/app/system/database/migrations/2020_08_23_131823_create_sessions_table.php(23): Illuminate\Support\Facades\Facade::__callStatic(‘create’, Array) #7 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): CreateSessionsTable->up() #8 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}() #9 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\Database\Migrations\Migrator->runMigration(Object(CreateSessionsTable), ‘up’) #10 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\Database\Migrations\Migrator->runUp(‘/home3/nlinespy…’, 2, false) #11 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\Database\Migrations\Migrator->runPending(Array, Array) #12 /home3/nlinespy/public_html/online/vendor/tastyigniter/flame/src/Database/Migrations/Migrator.php(14): Illuminate\Database\Migrations\Migrator->run(‘/home3/nlinespy…’, Array) #13 /home3/nlinespy/public_html/online/app/system/classes/UpdateManager.php(209): Igniter\Flame\Database\Migrations\Migrator->run(Array) #14 /home3/nlinespy/public_html/online/app/system/classes/UpdateManager.php(160): System\Classes\UpdateManager->migrateApp(‘System’) #15 /home3/nlinespy/public_html/online/app/system/controllers/Updates.php(355): System\Classes\UpdateManager->update() #16 /home3/nlinespy/public_html/online/app/system/controllers/Updates.php(337): System\Controllers\Updates->completeProcess(Array) #17 /home3/nlinespy/public_html/online/app/system/controllers/Updates.php(166): System\Controllers\Updates->processInstallOrUpdate() #18 [internal function]: System\Controllers\Updates->index_onProcess(‘index’) #19 /home3/nlinespy/public_html/online/app/admin/classes/AdminController.php(405): call_user_func_array(Array, Array) #20 /home3/nlinespy/public_html/online/app/admin/classes/AdminController.php(262): Admin\Classes\AdminController->runHandler(‘onProcess’, Array) #21 /home3/nlinespy/public_html/online/app/admin/classes/AdminController.php(167): Admin\Classes\AdminController->processHandlers() #22 /home3/nlinespy/public_html/online/app/system/classes/Controller.php(106): Admin\Classes\AdminController->remap(‘index’, Array) #23 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): System\Classes\Controller->runAdmin(‘updates’) #24 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction(‘runAdmin’, Array) #25 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(System\Classes\Controller), ‘runAdmin’) #26 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #27 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #28 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #29 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #30 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /home3/nlinespy/public_html/online/vendor/tastyigniter/flame/src/Currency/Middleware/CurrencyMiddleware.php(33): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #32 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Igniter\Flame\Currency\Middleware\CurrencyMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /home3/nlinespy/public_html/online/vendor/tastyigniter/flame/src/Translation/Middleware/Localization.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #34 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Igniter\Flame\Translation\Middleware\Localization->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #36 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #38 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #40 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #42 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #44 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #46 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #47 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #48 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #49 /home3/nlinespy/public_html/online/vendor/october/rain/src/Router/CoreRouter.php(20): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #50 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): October\Rain\Router\CoreRouter->dispatch(Object(Illuminate\Http\Request)) #51 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) #52 /home3/nlinespy/public_html/online/vendor/tastyigniter/flame/src/Setting/Middleware/SaveSetting.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #53 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Igniter\Flame\Setting\Middleware\SaveSetting->handle(Object(Illuminate\Http\Request), Object(Closure)) #54 /home3/nlinespy/public_html/online/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #55 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #57 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #59 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #60 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #61 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #62 /home3/nlinespy/public_html/online/extensions/igniter/api/vendor/dingo/api/src/Http/Middleware/Request.php(111): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #63 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Dingo\Api\Http\Middleware\Request->handle(Object(Illuminate\Http\Request), Object(Closure)) #64 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #65 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #66 /home3/nlinespy/public_html/online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #67 /home3/nlinespy/public_html/online/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #68 {main}

remmarpidong

on the front end here’s the error

(1/1) ErrorException
Trying to get property ‘permalink’ of non-object

in Router.php line 215
at HandleExceptions->handleError(8, ’Trying to get property \‘permalink\’ of non-object’, ‘/home3/nlinespy/public_html/online/app/main/classes/Router.php’, 215, array(‘cacheable’ => false, ‘cached’ => false, ‘pages’ => object(Collection), ‘map’ => array(array(‘file’ => ‘locations.php’, ‘pattern’ => ‘/locations’)), ‘page’ => null))
in Router.php line 215
at Router->loadUrlMap()
in Router.php line 192
at Router->getUrlMap()
in Router.php line 175
at Router->getRouterObject()
in Router.php line 102
at Router->findByUrl(‘/’)
in MainController.php line 172
at MainController->remap(‘/’)
in Controller.php line 85
at Controller->run(‘/’)
in Controller.php line 54
at Controller->callAction(‘run’, array(‘/’))
in ControllerDispatcher.php line 45
at ControllerDispatcher->dispatch(object(Route), object(Controller), ‘run’)
in Route.php line 219
at Route->runController()
in Route.php line 176
at Route->run()
in Router.php line 681
at Router->Illuminate\Routing{closure}(object(Request))
in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in VerifyCsrfToken.php line 78
at VerifyCsrfToken->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in CurrencyMiddleware.php line 33
at CurrencyMiddleware->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in CartMiddleware.php line 12
at CartMiddleware->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Localization.php line 27
at Localization->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in StartSession.php line 56
at StartSession->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in EncryptCookies.php line 67
at EncryptCookies->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php line 105
at Pipeline->then(object(Closure))
in Router.php line 683
at Router->runRouteWithinStack(object(Route), object(Request))
in Router.php line 658
at Router->runRoute(object(Request), object(Route))
in Router.php line 624
at Router->dispatchToRoute(object(Request))
in CoreRouter.php line 20
at CoreRouter->dispatch(object(Request))
in Kernel.php line 170
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
in Pipeline.php line 130
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in SaveSetting.php line 27
at SaveSetting->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in TrustProxies.php line 57
at TrustProxies->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in TransformsRequest.php line 21
at TransformsRequest->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in CheckForMaintenanceMode.php line 63
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Request.php line 111
at Request->handle(object(Request), object(Closure))
in Pipeline.php line 171
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php line 105
at Pipeline->then(object(Closure))
in Kernel.php line 145
at Kernel->sendRequestThroughRouter(object(Request))
in Kernel.php line 110
at Kernel->handle(object(Request))
in index.php line 53

ryanmitchell

Don’t think the database error is a migration from TI. Do you have a custom extension that may be causing it?

the permalink error is due to you using php templates instead of blade. Make sure you clear the old templates and only maintain the blade ones. Then clear your artisan cache.