Array ( ) SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "masjid" does not exist LINE 1: select count(*) as aggregate from "masjid" ^ (Connection: pgsql, SQL: select count(*) as aggregate from "masjid") (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException QueryException

HTTP 500 Internal Server Error

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "masjid" does not exist
LINE 1: select count(*) as aggregate from "masjid"
^ (Connection: pgsql, SQL: select count(*) as aggregate from "masjid")

Exceptions 2

Illuminate\Database\ QueryException

Show exception properties 
Illuminate\Database\QueryException {#27
  +errorInfo: array:3 [
    0 => "42P01"
    1 => 7
    2 => """
      ERROR:  relation "masjid" does not exist\n
      LINE 1: select count(*) as aggregate from "masjid"\n
                                                ^
      """
  ]
  +connectionName: "pgsql"
  #sql: "select count(*) as aggregate from "masjid""
  #bindings: []
}
in /home/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> {closure:Illuminate\Database\Query\Builder::get():2901} (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/vzizxmil/public_html/banyal-connect-api/vendor/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. /**
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> get (line 3383)
  1. public function aggregate($function, $columns = ['*'])
  2. {
  3. $results = $this->cloneWithout($this->unions || $this->havings ? [] : ['columns'])
  4. ->cloneWithoutBindings($this->unions || $this->havings ? [] : ['select'])
  5. ->setAggregate($function, $columns)
  6. ->get($columns);
  8. if (! $results->isEmpty()) {
  9. return array_change_key_case((array) $results[0])['aggregate'];
  10. }
  11. }
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> aggregate (line 3311)
  1. * @param \Illuminate\Contracts\Database\Query\Expression|string $columns
  2. * @return int
  3. */
  4. public function count($columns = '*')
  5. {
  6. return (int) $this->aggregate(__FUNCTION__, Arr::wrap($columns));
  7. }
  9. /**
  10. * Retrieve the minimum value of a given column.
  11. *
Builder->count() in /home/vzizxmil/public_html/banyal-connect-api/check_masjid_table.php (line 5)
  1. <?php
  2. require 'vendor/autoload.php';
  3. $app = require 'bootstrap/app.php';
  4. print_r(Illuminate\Support\Facades\Schema::getColumnListing('masjid'));
  5. $count = Illuminate\Support\Facades\DB::table('masjid')->count();
  6. echo "Total masjids: $count\n";

PDOException

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "masjid" does not exist LINE 1: select count(*) as aggregate from "masjid" ^

in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php (line 428)
  1. $this->getPdoForSelect($useReadPdo)->prepare($query)
  2. );
  4. $this->bindValues($statement, $this->prepareBindings($bindings));
  6. $statement->execute();
  8. return $statement->fetchAll();
  9. });
  10. }
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php -> execute (line 428)
  1. $this->getPdoForSelect($useReadPdo)->prepare($query)
  2. );
  4. $this->bindValues($statement, $this->prepareBindings($bindings));
  6. $statement->execute();
  8. return $statement->fetchAll();
  9. });
  10. }
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php -> {closure:Illuminate\Database\Connection::select():414} (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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/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/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> {closure:Illuminate\Database\Query\Builder::get():2901} (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/vzizxmil/public_html/banyal-connect-api/vendor/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. /**
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> get (line 3383)
  1. public function aggregate($function, $columns = ['*'])
  2. {
  3. $results = $this->cloneWithout($this->unions || $this->havings ? [] : ['columns'])
  4. ->cloneWithoutBindings($this->unions || $this->havings ? [] : ['select'])
  5. ->setAggregate($function, $columns)
  6. ->get($columns);
  8. if (! $results->isEmpty()) {
  9. return array_change_key_case((array) $results[0])['aggregate'];
  10. }
  11. }
in /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php -> aggregate (line 3311)
  1. * @param \Illuminate\Contracts\Database\Query\Expression|string $columns
  2. * @return int
  3. */
  4. public function count($columns = '*')
  5. {
  6. return (int) $this->aggregate(__FUNCTION__, Arr::wrap($columns));
  7. }
  9. /**
  10. * Retrieve the minimum value of a given column.
  11. *
Builder->count() in /home/vzizxmil/public_html/banyal-connect-api/check_masjid_table.php (line 5)
  1. <?php
  2. require 'vendor/autoload.php';
  3. $app = require 'bootstrap/app.php';
  4. print_r(Illuminate\Support\Facades\Schema::getColumnListing('masjid'));
  5. $count = Illuminate\Support\Facades\DB::table('masjid')->count();
  6. echo "Total masjids: $count\n";

Stack Traces 2

[2/2] QueryException 
Illuminate\Database\QueryException:
SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "masjid" does not exist
LINE 1: select count(*) as aggregate from "masjid"
                                          ^ (Connection: pgsql, SQL: select count(*) as aggregate from "masjid")

  at /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:829
  at Illuminate\Database\Connection->runQueryCallback('select count(*) as aggregate from "masjid"', array(), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:783)
  at Illuminate\Database\Connection->run('select count(*) as aggregate from "masjid"', array(), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:414)
  at Illuminate\Database\Connection->select('select count(*) as aggregate from "masjid"', array(), true)
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2913)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2902)
  at Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():2901}()
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3456)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2901)
  at Illuminate\Database\Query\Builder->get(array('*'))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3383)
  at Illuminate\Database\Query\Builder->aggregate('count', array('*'))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3311)
  at Illuminate\Database\Query\Builder->count()
     (/home/vzizxmil/public_html/banyal-connect-api/check_masjid_table.php:5)
[1/2] PDOException 
PDOException:
SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "masjid" does not exist
LINE 1: select count(*) as aggregate from "masjid"
                                          ^

  at /home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:428
  at PDOStatement->execute()
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:428)
  at Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::select():414}('select count(*) as aggregate from "masjid"', array())
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:816)
  at Illuminate\Database\Connection->runQueryCallback('select count(*) as aggregate from "masjid"', array(), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:783)
  at Illuminate\Database\Connection->run('select count(*) as aggregate from "masjid"', array(), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Connection.php:414)
  at Illuminate\Database\Connection->select('select count(*) as aggregate from "masjid"', array(), true)
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2913)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2902)
  at Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():2901}()
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3456)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:2901)
  at Illuminate\Database\Query\Builder->get(array('*'))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3383)
  at Illuminate\Database\Query\Builder->aggregate('count', array('*'))
     (/home/vzizxmil/public_html/banyal-connect-api/vendor/illuminate/database/Query/Builder.php:3311)
  at Illuminate\Database\Query\Builder->count()
     (/home/vzizxmil/public_html/banyal-connect-api/check_masjid_table.php:5)