Checking Felix O'Test data: ✅ Felix found: Ava (felix@avaacquisitions.com) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist (Connection: mysql, SQL: select * from `user_modules` where `user_id` = 7) (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException QueryException

HTTP 500 Internal Server Error

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist (Connection: mysql, SQL: select * from `user_modules` where `user_id` = 7)

Exceptions 2

Illuminate\Database\ QueryException

Show exception properties 
Illuminate\Database\QueryException {#1646
  +errorInfo: array:3 [
    0 => "42S02"
    1 => 1146
    2 => "Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist"
  ]
  +connectionName: "mysql"
  #sql: "select * from `user_modules` where `user_id` = ?"
  #bindings: array:1 [
    0 => 7
  ]
}
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php (line 829)
  1.                 throw new UniqueConstraintViolationException(
  2.                     $this->getName(), $query, $this->prepareBindings($bindings), $e
  3.                 );
  4.             }
  6.             throw new QueryException(
  7.                 $this->getName(), $query, $this->prepareBindings($bindings), $e
  8.             );
  9.         }
  10.     }
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> runQueryCallback (line 783)
  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/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> run (line 414)
  1.      * @param  bool  $useReadPdo
  2.      * @return array
  3.      */
  4.     public function select($query, $bindings = [], $useReadPdo = true)
  5.     {
  6.         return $this->run($query, $bindings, function ($query, $bindings) use ($useReadPdo) {
  7.             if ($this->pretending()) {
  8.                 return [];
  9.             }
  11.             // For select statements, we'll simply execute the query and return an array
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> select (line 2913)
  1.      *
  2.      * @return array
  3.      */
  4.     protected function runSelect()
  5.     {
  6.         return $this->connection->select(
  7.             $this->toSql(), $this->getBindings(), ! $this->useWritePdo
  8.         );
  9.     }
  11.     /**
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> runSelect (line 2902)
  1.      * @return \Illuminate\Support\Collection
  2.      */
  3.     public function get($columns = ['*'])
  4.     {
  5.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  6.             return $this->processor->processSelect($this, $this->runSelect());
  7.         }));
  8.     }
  10.     /**
  11.      * Run the query as a "select" statement against the connection.
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> Illuminate\Database\Query\{closure} (line 3456)
  2.         if (is_null($original)) {
  3.             $this->columns = $columns;
  4.         }
  6.         $result = $callback();
  8.         $this->columns = $original;
  10.         return $result;
  11.     }
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> onceWithColumns (line 2901)
  1.      * @param  array|string  $columns
  2.      * @return \Illuminate\Support\Collection
  3.      */
  4.     public function get($columns = ['*'])
  5.     {
  6.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  7.             return $this->processor->processSelect($this, $this->runSelect());
  8.         }));
  9.     }
  11.     /**
Builder->get() in /home/consentangel/public_html/sgce/009/check_felix_data.php (line 15)
  1. $felix = App\Models\User::where('name', 'LIKE', '%Felix%')->orWhere('email', 'LIKE', '%felix%')->first();
  2. if ($felix) {
  3.     echo "✅ Felix found: " . $felix->name . " (" . $felix->email . ")\n";
  4.     
  5.     // Check user_modules
  6.     $modules = DB::table('user_modules')->where('user_id', $felix->id)->get();
  7.     echo "User modules: " . $modules->count() . "\n";
  8.     foreach ($modules as $module) {
  9.         echo "  - Module " . $module->module_id . ": " . ($module->completed ? 'Completed' : 'Not completed') . "\n";
  10.     }
  11.     

PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist

in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php (line 423)
  2.             // For select statements, we'll simply execute the query and return an array
  3.             // of the database result set. Each element in the array will be a single
  4.             // row from the database table, and will either be an array or objects.
  5.             $statement = $this->prepared(
  6.                 $this->getPdoForSelect($useReadPdo)->prepare($query)
  7.             );
  9.             $this->bindValues($statement, $this->prepareBindings($bindings));
  11.             $statement->execute();
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> prepare (line 423)
  2.             // For select statements, we'll simply execute the query and return an array
  3.             // of the database result set. Each element in the array will be a single
  4.             // row from the database table, and will either be an array or objects.
  5.             $statement = $this->prepared(
  6.                 $this->getPdoForSelect($useReadPdo)->prepare($query)
  7.             );
  9.             $this->bindValues($statement, $this->prepareBindings($bindings));
  11.             $statement->execute();
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> Illuminate\Database\{closure} (line 816)
  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/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> runQueryCallback (line 783)
  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/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php -> run (line 414)
  1.      * @param  bool  $useReadPdo
  2.      * @return array
  3.      */
  4.     public function select($query, $bindings = [], $useReadPdo = true)
  5.     {
  6.         return $this->run($query, $bindings, function ($query, $bindings) use ($useReadPdo) {
  7.             if ($this->pretending()) {
  8.                 return [];
  9.             }
  11.             // For select statements, we'll simply execute the query and return an array
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> select (line 2913)
  1.      *
  2.      * @return array
  3.      */
  4.     protected function runSelect()
  5.     {
  6.         return $this->connection->select(
  7.             $this->toSql(), $this->getBindings(), ! $this->useWritePdo
  8.         );
  9.     }
  11.     /**
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> runSelect (line 2902)
  1.      * @return \Illuminate\Support\Collection
  2.      */
  3.     public function get($columns = ['*'])
  4.     {
  5.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  6.             return $this->processor->processSelect($this, $this->runSelect());
  7.         }));
  8.     }
  10.     /**
  11.      * Run the query as a "select" statement against the connection.
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> Illuminate\Database\Query\{closure} (line 3456)
  2.         if (is_null($original)) {
  3.             $this->columns = $columns;
  4.         }
  6.         $result = $callback();
  8.         $this->columns = $original;
  10.         return $result;
  11.     }
in /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php -> onceWithColumns (line 2901)
  1.      * @param  array|string  $columns
  2.      * @return \Illuminate\Support\Collection
  3.      */
  4.     public function get($columns = ['*'])
  5.     {
  6.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  7.             return $this->processor->processSelect($this, $this->runSelect());
  8.         }));
  9.     }
  11.     /**
Builder->get() in /home/consentangel/public_html/sgce/009/check_felix_data.php (line 15)
  1. $felix = App\Models\User::where('name', 'LIKE', '%Felix%')->orWhere('email', 'LIKE', '%felix%')->first();
  2. if ($felix) {
  3.     echo "✅ Felix found: " . $felix->name . " (" . $felix->email . ")\n";
  4.     
  5.     // Check user_modules
  6.     $modules = DB::table('user_modules')->where('user_id', $felix->id)->get();
  7.     echo "User modules: " . $modules->count() . "\n";
  8.     foreach ($modules as $module) {
  9.         echo "  - Module " . $module->module_id . ": " . ($module->completed ? 'Completed' : 'Not completed') . "\n";
  10.     }
  11.     

Stack Traces 2

[2/2] QueryException 
Illuminate\Database\QueryException:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist (Connection: mysql, SQL: select * from `user_modules` where `user_id` = 7)

  at /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
  at Illuminate\Database\Connection->runQueryCallback('select * from `user_modules` where `user_id` = ?', array(7), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783)
  at Illuminate\Database\Connection->run('select * from `user_modules` where `user_id` = ?', array(7), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414)
  at Illuminate\Database\Connection->select('select * from `user_modules` where `user_id` = ?', array(7), true)
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2913)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2902)
  at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3456)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2901)
  at Illuminate\Database\Query\Builder->get()
     (/home/consentangel/public_html/sgce/009/check_felix_data.php:15)
[1/2] PDOException 
PDOException:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'consentangel_consentangel_sgce9.user_modules' doesn't exist

  at /home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423
  at PDO->prepare('select * from `user_modules` where `user_id` = ?')
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)
  at Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `user_modules` where `user_id` = ?', array(7))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816)
  at Illuminate\Database\Connection->runQueryCallback('select * from `user_modules` where `user_id` = ?', array(7), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783)
  at Illuminate\Database\Connection->run('select * from `user_modules` where `user_id` = ?', array(7), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414)
  at Illuminate\Database\Connection->select('select * from `user_modules` where `user_id` = ?', array(7), true)
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2913)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2902)
  at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3456)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/consentangel/public_html/sgce/009/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2901)
  at Illuminate\Database\Query\Builder->get()
     (/home/consentangel/public_html/sgce/009/check_felix_data.php:15)