🧨 SQLSTATE[HY000] [2002] Operation not permitted (SQL: select distinct `brands`.`id`, `brands`.`name`, `brands`.`alias`, `brands`.`founding_year`, `brands`.`country`, `libraries`.`media` as `photo`, `libraries`.`title`, `libraries`.`width`, `libraries`.`height`, `libraries`.`medium_width`, `libraries`.`medium_height`, `libraries`.`thumb_width`, `libraries`.`thumb_height`, `libraries`.`mini_width`, `libraries`.`mini_height`, `accessory_brand`.`brand_id` from `brands` left join `libraries` on `brands`.`library_id` = `libraries`.`id` left join `brand_console` on `brands`.`id` = `brand_console`.`brand_id` left join `consoles` on `consoles`.`id` = `brand_console`.`console_id` left join `accessory_brand` on `brands`.`id` = `accessory_brand`.`brand_id` left join `accessories` on `accessories`.`id` = `accessory_brand`.`accessory_id` where (`brands`.`published` = 1) and (accessories.id is not null or consoles.id is not null) order by `brands`.`name` asc limit 99999 offset 0)

Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Operation not permitted (SQL: select distinct `brands`.`id`, `brands`.`name`, `brands`.`alias`, `brands`.`founding_year`, `brands`.`country`, `libraries`.`media` as `photo`, `libraries`.`title`, `libraries`.`width`, `libraries`.`height`, `libraries`.`medium_width`, `libraries`.`medium_height`, `libraries`.`thumb_width`, `libraries`.`thumb_height`, `libraries`.`mini_width`, `libraries`.`mini_height`, `accessory_brand`.`brand_id` from `brands` left join `libraries` on `brands`.`library_id` = `libraries`.`id` left join `brand_console` on `brands`.`id` = `brand_console`.`brand_id` left join `consoles` on `consoles`.`id` = `brand_console`.`console_id` left join `accessory_brand` on `brands`.`id` = `accessory_brand`.`brand_id` left join `accessories` on `accessories`.`id` = `accessory_brand`.`accessory_id` where (`brands`.`published` = 1) and (accessories.id is not null or consoles.id is not null) order by `brands`.`name` asc limit 99999 offset 0) in file /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 703 #0 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback('select distinct...', Array, Object(Closure)) #1 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(367): Illuminate\Database\Connection->run('select distinct...', Array, Object(Closure)) #2 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2350): Illuminate\Database\Connection->select('select distinct...', Array, true) #3 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2338): Illuminate\Database\Query\Builder->runSelect() #4 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2872): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2339): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/app/Http/Controllers/BrandController.php(113): Illuminate\Database\Query\Builder->get() #7 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(391): App\Http\Controllers\BrandController->App\Http\Controllers\{closure}() #8 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/app/Http/Controllers/BrandController.php(172): Illuminate\Cache\Repository->remember('dev-brands---99...', 259200, Object(Closure)) #9 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\BrandController->index(Object(Illuminate\Http\Request)) #10 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('index', Array) #11 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\BrandController), 'index') #12 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #13 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Router.php(695): Illuminate\Routing\Route->run() #14 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #16 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #17 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #18 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #19 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure)) #23 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Router.php(697): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #30 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Router.php(672): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #31 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Router.php(636): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #32 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #33 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(166): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #34 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #35 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/fruitcake/laravel-cors/src/HandleCors.php(52): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #46 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(141): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #51 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #52 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #53 /home/u857038472/domains/devapi.gamemedium.com/public_html/v2/server.php(21): require_once('/home/u85703847...') #54 {main}

Gaming Consoles

Generation

Game Medium

List of Home Consoles

INTV System III by INTV Corporation

Atari 5200 by AtariMilton Bradley

Compact Vision TV Boy by Gakken

Intellivision II by Mattel

Cassette Vision Jr. by Epoch

Video Arcade System by Ultravision

Vectrex by General Consumer ElectronicsMilton Bradley

ColecoVision by Coleco

Arcadia 2001 by Emerson

CreatiVision by VTech

Cassette Vision by Epoch

Imagination Machine by APF

Intellivision by Mattel

Super Vision 8000 by Bandai

Odyssey 2 by MagnavoxPhilips