Table "corporation-market" missing

[autophob]

Not sure if I did something wrong, as the rest of SeAT works just awesome. Whenever I try to open Market in any corporation, I receive an Ajax error pointing to table "corporation-market".

After a quick look into phpMyAdmin I found that this table doesn't exist in my database. Any way to add that table?

[warlof]

hi @autophob ,

it indead make sense since that table isn't part of SeAT. Not in core at least :p
normally, while getting the ajax error - you should have at exactly same time some text landing into your logs.

Could you provide me the content ?

How to diagnose errors

[autophob]

[2019-11-18 21:02:08] local.ERROR: compact(): Undefined variable: character_id {"userId":236529904,"email":"jesco@jesco.industries","exception":"[object] (Yajra\DataTables\Exceptions\Exception(code: 0): compact(): Undefined variable: character_id at /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, ErrorException(code: 0): compact(): Undefined variable: character_id at /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/eveseat/web/src/Http/Controllers/Corporation/MarketController.php:91)
[stacktrace]
#0 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\DataTables\DataTableAbstract->errorResponse(Object(ErrorException))
#1 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/eveseat/web/src/Http/Controllers/Corporation/MarketController.php(110): Yajra\DataTables\QueryDataTable->make(true)
#2 [internal function]: Seat\Web\Http\Controllers\Corporation\MarketController->getMarketData(98597473)
#3 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#4 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('getMarketData', Array)
#5 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Seat\Web\Http\Controllers\Corporation\MarketController), 'getMarketData')
#6 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#7 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()
#8 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#9 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/eveseat/web/src/Http/Middleware/Bouncer/CorporationBouncer.php(53): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#10 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Seat\Web\Http\Middleware\Bouncer\CorporationBouncer->handle(Object(Illuminate\Http\Request), Object(Closure), 'market')
#11 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/eveseat/web/src/Http/Middleware/Locale.php(44): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#13 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Seat\Web\Http\Middleware\Locale->handle(Object(Illuminate\Http\Request), Object(Closure))
#14 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#15 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/eveseat/web/src/Http/Middleware/Authenticate.php(67): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#16 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Seat\Web\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#17 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#20 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#25 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#38 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#39 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#40 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#41 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#42 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#52 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#53 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#60 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#61 /var/www/vhosts/jesco.industries/seat.jesco.industries/seat/public/index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#62 {main}
"}

[warlof]

It seems indead to be a bug in core since 3.0.14 - strange it has not been reported early.
I'll push an hotfix tomorrow evening.

[autophob]

Huh. Well, happy to help. Thanks for the quick support.

[warlof]

it has been fixed in eveseat/web@3.0.27