🧪 Testing Ticket Scan API ========================== Setup: Creating test scanner device... ✅ Scanner created: ✅ JWT token generated Setup: Finding test event and ticket... ✅ Using event: (ID: 1) ✅ Using ticket: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verification_code' in 'WHERE' (SQL: delete from `ticket_validations` where `verification_code` is null) (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException QueryException

HTTP 500 Internal Server Error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verification_code' in 'WHERE' (SQL: delete from `ticket_validations` where `verification_code` is null)

Exceptions 2

Illuminate\Database\ QueryException

Show exception properties 
Illuminate\Database\QueryException {#2019
  +errorInfo: array:3 [
    0 => "42S22"
    1 => 1054
    2 => "Unknown column 'verification_code' in 'WHERE'"
  ]
  #sql: "delete from `ticket_validations` where `verification_code` is null"
  #bindings: []
}
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php (line 760)
  2.         // If an exception occurs when attempting to run a query, we'll format the error
  3.         // message to include the bindings with SQL, which will make this exception a
  4.         // lot more helpful to the developer instead of just the database's errors.
  5.         catch (Exception $e) {
  6.             throw new QueryException(
  7.                 $query, $this->prepareBindings($bindings), $e
  8.             );
  9.         }
  10.     }
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> runQueryCallback (line 720)
  2.         // Here we will run this query. If an exception occurs we'll determine if it was
  3.         // caused by a connection that has been lost. If that is the cause, we'll try
  4.         // to re-establish connection and re-run the query with a fresh connection.
  5.         try {
  6.             $result = $this->runQueryCallback($query, $bindings, $callback);
  7.         } catch (QueryException $e) {
  8.             $result = $this->handleQueryException(
  9.                 $e, $query, $bindings, $callback
  10.             );
  11.         }
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> run (line 558)
  1.      * @param  array  $bindings
  2.      * @return int
  3.      */
  4.     public function affectingStatement($query, $bindings = [])
  5.     {
  6.         return $this->run($query, $bindings, function ($query, $bindings) {
  7.             if ($this->pretending()) {
  8.                 return 0;
  9.             }
  11.             // For update or delete statements, we want to get the number of rows affected
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> affectingStatement (line 522)
  1.      * @param  array  $bindings
  2.      * @return int
  3.      */
  4.     public function delete($query, $bindings = [])
  5.     {
  6.         return $this->affectingStatement($query, $bindings);
  7.     }
  9.     /**
  10.      * Execute an SQL statement and return the boolean result.
  11.      *
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> delete (line 3550)
  1.             $this->where($this->from.'.id', '=', $id);
  2.         }
  4.         $this->applyBeforeQueryCallbacks();
  6.         return $this->connection->delete(
  7.             $this->grammar->compileDelete($this), $this->cleanBindings(
  8.                 $this->grammar->prepareBindingsForDelete($this->bindings)
  9.             )
  10.         );
  11.     }
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php -> delete (line 1189)
  1.     {
  2.         if (isset($this->onDelete)) {
  3.             return call_user_func($this->onDelete, $this);
  4.         }
  6.         return $this->toBase()->delete();
  7.     }
  9.     /**
  10.      * Run the default delete function on the builder.
  11.      *
Builder->delete() in /home/globalgala/public_html/2026_backend_dev/tests/manual/test-ticket-scan-api.php (line 63)
  1.     die("❌ No tickets found for this event. Please create tickets first.\n");
  2. }
  3. echo "✅ Using ticket: {$ticket->verification_code}\n\n";
  5. // Clear previous test scans
  6. TicketValidation::where('verification_code', $ticket->verification_code)->delete();
  7. echo "✅ Cleared previous test scans\n\n";
  9. /**
  10.  * Helper function to make API requests
  11.  */

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verification_code' in 'WHERE'

in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php (line 566)
  1.             }
  3.             // For update or delete statements, we want to get the number of rows affected
  4.             // by the statement and return that back to the developer. We'll first need
  5.             // to execute the statement and then we'll use PDO to fetch the affected.
  6.             $statement = $this->getPdo()->prepare($query);
  8.             $this->bindValues($statement, $this->prepareBindings($bindings));
  10.             $statement->execute();
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> prepare (line 566)
  1.             }
  3.             // For update or delete statements, we want to get the number of rows affected
  4.             // by the statement and return that back to the developer. We'll first need
  5.             // to execute the statement and then we'll use PDO to fetch the affected.
  6.             $statement = $this->getPdo()->prepare($query);
  8.             $this->bindValues($statement, $this->prepareBindings($bindings));
  10.             $statement->execute();
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> Illuminate\Database\{closure} (line 753)
  1.     {
  2.         // To execute the statement, we'll simply call the callback, which will actually
  3.         // run the SQL against the PDO connection. Then we can calculate the time it
  4.         // took to execute and log the query SQL, bindings and time in our memory.
  5.         try {
  6.             return $callback($query, $bindings);
  7.         }
  9.         // If an exception occurs when attempting to run a query, we'll format the error
  10.         // message to include the bindings with SQL, which will make this exception a
  11.         // lot more helpful to the developer instead of just the database's errors.
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> runQueryCallback (line 720)
  2.         // Here we will run this query. If an exception occurs we'll determine if it was
  3.         // caused by a connection that has been lost. If that is the cause, we'll try
  4.         // to re-establish connection and re-run the query with a fresh connection.
  5.         try {
  6.             $result = $this->runQueryCallback($query, $bindings, $callback);
  7.         } catch (QueryException $e) {
  8.             $result = $this->handleQueryException(
  9.                 $e, $query, $bindings, $callback
  10.             );
  11.         }
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> run (line 558)
  1.      * @param  array  $bindings
  2.      * @return int
  3.      */
  4.     public function affectingStatement($query, $bindings = [])
  5.     {
  6.         return $this->run($query, $bindings, function ($query, $bindings) {
  7.             if ($this->pretending()) {
  8.                 return 0;
  9.             }
  11.             // For update or delete statements, we want to get the number of rows affected
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> affectingStatement (line 522)
  1.      * @param  array  $bindings
  2.      * @return int
  3.      */
  4.     public function delete($query, $bindings = [])
  5.     {
  6.         return $this->affectingStatement($query, $bindings);
  7.     }
  9.     /**
  10.      * Execute an SQL statement and return the boolean result.
  11.      *
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> delete (line 3550)
  1.             $this->where($this->from.'.id', '=', $id);
  2.         }
  4.         $this->applyBeforeQueryCallbacks();
  6.         return $this->connection->delete(
  7.             $this->grammar->compileDelete($this), $this->cleanBindings(
  8.                 $this->grammar->prepareBindingsForDelete($this->bindings)
  9.             )
  10.         );
  11.     }
in /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php -> delete (line 1189)
  1.     {
  2.         if (isset($this->onDelete)) {
  3.             return call_user_func($this->onDelete, $this);
  4.         }
  6.         return $this->toBase()->delete();
  7.     }
  9.     /**
  10.      * Run the default delete function on the builder.
  11.      *
Builder->delete() in /home/globalgala/public_html/2026_backend_dev/tests/manual/test-ticket-scan-api.php (line 63)
  1.     die("❌ No tickets found for this event. Please create tickets first.\n");
  2. }
  3. echo "✅ Using ticket: {$ticket->verification_code}\n\n";
  5. // Clear previous test scans
  6. TicketValidation::where('verification_code', $ticket->verification_code)->delete();
  7. echo "✅ Cleared previous test scans\n\n";
  9. /**
  10.  * Helper function to make API requests
  11.  */

Stack Traces 2

[2/2] QueryException 
Illuminate\Database\QueryException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verification_code' in 'WHERE' (SQL: delete from `ticket_validations` where `verification_code` is null)

  at /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
  at Illuminate\Database\Connection->runQueryCallback('delete from `ticket_validations` where `verification_code` is null', array(), object(Closure))
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:720)
  at Illuminate\Database\Connection->run('delete from `ticket_validations` where `verification_code` is null', array(), object(Closure))
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:558)
  at Illuminate\Database\Connection->affectingStatement('delete from `ticket_validations` where `verification_code` is null', array())
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:522)
  at Illuminate\Database\Connection->delete('delete from `ticket_validations` where `verification_code` is null', array())
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3550)
  at Illuminate\Database\Query\Builder->delete()
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1189)
  at Illuminate\Database\Eloquent\Builder->delete()
     (/home/globalgala/public_html/2026_backend_dev/tests/manual/test-ticket-scan-api.php:63)
[1/2] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verification_code' in 'WHERE'

  at /home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566
  at PDO->prepare('delete from `ticket_validations` where `verification_code` is null')
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566)
  at Illuminate\Database\Connection->Illuminate\Database\{closure}('delete from `ticket_validations` where `verification_code` is null', array())
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:753)
  at Illuminate\Database\Connection->runQueryCallback('delete from `ticket_validations` where `verification_code` is null', array(), object(Closure))
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:720)
  at Illuminate\Database\Connection->run('delete from `ticket_validations` where `verification_code` is null', array(), object(Closure))
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:558)
  at Illuminate\Database\Connection->affectingStatement('delete from `ticket_validations` where `verification_code` is null', array())
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Connection.php:522)
  at Illuminate\Database\Connection->delete('delete from `ticket_validations` where `verification_code` is null', array())
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3550)
  at Illuminate\Database\Query\Builder->delete()
     (/home/globalgala/public_html/2026_backend_dev/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1189)
  at Illuminate\Database\Eloquent\Builder->delete()
     (/home/globalgala/public_html/2026_backend_dev/tests/manual/test-ticket-scan-api.php:63)