jira.digitalaround.ru Open in urlscan Pro
188.232.102.86  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'banner_type_enum' in 'where clause' (Connection: mysql, SQL: select * from `banners` where `banner_type_enum` = mobile and `slug` not in (credit-banner) limit 5) in file /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 801

#0 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(755): Illuminate\Database\Connection->runQueryCallback()
#1 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\Database\Connection->run()
#2 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\Database\Connection->select()
#3 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\Database\Query\Builder->runSelect()
#4 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(737): Illuminate\Database\Query\Builder->get()
#7 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(721): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/tireclub-backend/tireclub-backend/routes/web.php(36): Illuminate\Database\Eloquent\Builder->get()
#9 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php(40): Illuminate\Routing\RouteFileRegistrar->{closure}()
#10 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(237): Illuminate\Routing\CallableDispatcher->dispatch()
#11 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(208): Illuminate\Routing\Route->runCallable()
#12 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Routing\Route->run()
#13 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#14 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#15 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#16 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#17 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#18 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#19 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#20 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#21 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#22 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#23 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Pipeline\Pipeline->then()
#25 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(777): Illuminate\Routing\Router->runRouteWithinStack()
#26 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(741): Illuminate\Routing\Router->runRoute()
#27 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(730): Illuminate\Routing\Router->dispatchToRoute()
#28 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch()
#29 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#30 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#31 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#32 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#33 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#35 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#36 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#38 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(89): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#40 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle()
#42 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#43 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#44 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#45 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then()
#46 /home/tireclub-backend/tireclub-backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#47 /home/tireclub-backend/tireclub-backend/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle()
#48 {main}


 * Stack
 * Context
 * Share
   
   SHARE WITH FLARE
   
   Docs
    * Stack
    * Context
    * Debug
   
   Create Share

 * Docs

 * IGNITION SETTINGS
   
   Docs
   Editor
   ClipboardSublimeTextMateEmacsMacVimPhpStormPHPStorm RemoteIdeaVS CodeVS Code
   InsidersVS Code RemoteVS Code Insiders RemoteVS CodiumAtomNovaNetBeansXdebug
   
   Theme
   auto
   Save settings
   
   Settings will be saved locally in ~/.ignition.json.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'banner_type_enum' in
'where clause' (Connection: mysql, SQL: select * from `banners` where
`banner_type_enum` = mobile and `slug` not in (credit-banner) limit 5)
Illuminate \ Database \ QueryException
PHP 8.3.810.21.1
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'banner_type_enum' in
'where clause'

select * from `banners` where `banner_type_enum` = mobile and `slug` not in (credit-banner) limit 5




A COLUMN WAS NOT FOUND

Run migrations

You might have forgotten to run your database migrations.

You can try to run your migrations using `php artisan migrate`.

 * Database: Running Migrations docs


Expand vendor frames
 1. 9 vendor frames
 2. Illuminate \ Routing \ RouteFileRegistrar : 36
    {closure}
 3. 
 4. 39 vendor frames

routes / web.php : 36

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

use App\Models\Microresource;
use App\Models\CarBrand;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider and all of them will
| be assigned to the "web" middleware group. Make something great!
|
*/
Route::get('/', function () {
  return view('pages/home', [
    'banners' => Banner::where('banner_type_enum', 'mobile')->whereNotIn('slug', ['credit-banner'])->take(5)->get()->concat(
      Banner::where('banner_type_enum', 'desktop')->whereNotIn('slug', ['credit-banner'])->take(5)->get()),
    'news' => News::orderBy('date', 'desc')->take(8)->get(),
    'service_types' => Service::all(),
    'car_brands' => CarBrand::all(),
    'advantages' => Microresource::where('slug', 'our-advantages')->firstOrFail(),
    'root_category' => Category::whereNull('parent_id')->first(),
    'bestsellers' => Category::where('name', 'Хиты продаж')->first()->applicable_products,
    'bestsellers_category' => Category::where('name', 'Хиты продаж')->first(),
    'main_description' => Microresource::where('name', 'Описание на главной')->first(),
    'products' => Product::inRandomOrder()->limit(7)->get()
  ]);
});

Route::get('/preview-main', function () {

 * Request
   * Browser
   * Headers
   * Body
 * App
   * Routing
 * Context
   * Versions
   * Exception


REQUEST

https://jira.digitalaround.ru/
GET

curl "https://jira.digitalaround.ru/" \
   -X GET \
   -H 'host: jira.digitalaround.ru' \
   -H 'connection: keep-alive' \
   -H 'upgrade-insecure-requests: 1' \
   -H 'user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36' \
   -H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7' \
   -H 'sec-fetch-site: none' \
   -H 'sec-fetch-mode: navigate' \
   -H 'sec-fetch-user: ?1' \
   -H 'sec-fetch-dest: document' \
   -H 'accept-encoding: gzip, deflate, br, zstd' \
   -H 'accept-language: en-US,en;q=0.9';




BROWSER

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36




HEADERS

host

jira.digitalaround.ru


connection

keep-alive


upgrade-insecure-requests

1


user-agent

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36


accept

text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7


sec-fetch-site

none


sec-fetch-mode

navigate


sec-fetch-user

?1


sec-fetch-dest

document


accept-encoding

gzip, deflate, br, zstd


accept-language

en-US,en;q=0.9




BODY

[]




APP


ROUTING

Controller

Closure


Middleware

 * web
   
   


CONTEXT


VERSIONS

Php Version

8.3.8


Laravel Version

10.21.1


Laravel Locale

ru


Laravel Config Cachedfalse
App Debugtrue
App Env

local




EXCEPTION

Raw Sql

select * from `banners` where `banner_type_enum` = ? and `slug` not in (?) limit 5