Skip to content

Illuminate\Database\QueryException #1

Description

@eyedroot

Describe the bug

Illuminate\Database\QueryException {#1693 // app/Services/Valorant/GuideService.php:93
  #message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channels.id' in 'field list' (Connection: mysql, SQL: select `valorant_movies`.*, `channels`.`id` as `channel_pid`, `channels`.`channel_id`, `channels`.`channel_title`, `channels`.`channel_thumbnail` from `valorant_movies` where `state` = 1 and `category` = GUIDE order by `valorant_movies`.`id` desc limit 20 offset 0)"
  #code: "42S22"
  #file: "/var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
  #line: 795
  -previous: PDOException {#1287
    #message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channels.id' in 'field list'"
    #code: "42S22"
    #file: "/var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
    #line: 416
    +errorInfo: array:3 [

To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Environment:

  • PHP Version: [e.g. 7.4, 8.0]
  • Framework: [e.g. Laravel, Symfony, etc.]
  • OS: [e.g. iOS, Windows, Linux]

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions