mysqli_sql_exception ExecutionFailureException

HTTP 500 Whoops, looks like something went wrong.

Prepared statement needs to be re-prepared

Exceptions 2

Joomla\Database\Exception\ ExecutionFailureException

in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 442)
  1.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  2.             }
  3.         }
  4.         catch (\Throwable $e)
  5.         {
  6.             throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  7.         }
  9.         if ($this->columnNames === null)
  10.         {
  11.             $meta = $this->statement->result_metadata();
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 675)
  1.             $this->statement->bindParam($key, $obj->value, $obj->dataType);
  2.         }
  4.         try
  5.         {
  6.             $this->executed = $this->statement->execute();
  8.             // If there is a monitor registered, let it know we have finished this query
  9.             if ($this->monitor)
  10.             {
  11.                 $this->monitor->stopQuery();
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 1375)
  1.                 $this->statement->setFetchMode($fetchMode, $class);
  2.             }
  3.         }
  5.         // Execute the query and get the result set cursor.
  6.         $this->execute();
  8.         // Get all of the rows from the result set as objects of type $class.
  9.         while ($row = $this->fetchObject())
  10.         {
  11.             if ($key)
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> loadObjectList (line 527)
  1.     public function getConnectionEncryption(): string
  2.     {
  3.         $this->connect();
  5.         $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  6.             ->loadObjectList('Variable_name');
  8.         if (!empty($variables['Ssl_cipher']->Value))
  9.         {
  10.             return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  11.         }
MysqliDriver->getConnectionEncryption() in /var/www/web89/html/joomla/administrator/components/com_admin/src/Model/SysinfoModel.php (line 318)
  1.             'php'                    => php_uname(),
  2.             'dbserver'               => $db->getServerType(),
  3.             'dbversion'              => $db->getVersion(),
  4.             'dbcollation'            => $db->getCollation(),
  5.             'dbconnectioncollation'  => $db->getConnectionCollation(),
  6.             'dbconnectionencryption' => $db->getConnectionEncryption(),
  7.             'dbconnencryptsupported' => $db->isConnectionEncryptionSupported(),
  8.             'phpversion'             => PHP_VERSION,
  9.             'server'                 => $_SERVER['SERVER_SOFTWARE'] ?? getenv('SERVER_SOFTWARE'),
  10.             'sapi_name'              => PHP_SAPI,
  11.             'version'                => (new Version())->getLongVersion(),
SysinfoModel->getInfo() in /var/www/web89/html/joomla/plugins/system/debug/src/DataCollector/InfoCollector.php (line 136)
  1.             'joomlaVersion' => JVERSION,
  2.             'requestId'     => $this->requestId,
  3.             'identity'      => $this->getIdentityInfo($application->getIdentity()),
  4.             'response'      => $this->getResponseInfo($application->getResponse()),
  5.             'template'      => $this->getTemplateInfo($application->getTemplate(true)),
  6.             'database'      => $this->getDatabaseInfo($model->getInfo()),
  7.         ];
  8.     }
  10.     /**
  11.      * Get Identity info.
in /var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 238)
  1.                 $request_variables
  2.             )
  3.         );
  5.         foreach ($this->collectors as $name => $collector) {
  6.             $this->data[$name] = $collector->collect();
  7.         }
  9.         // Remove all invalid (non UTF-8) characters
  10.         array_walk_recursive($this->data, function (&$item) {
  11.                 if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
in /var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 265)
  1.      * @return array
  2.      */
  3.     public function getData()
  4.     {
  5.         if ($this->data === null) {
  6.             $this->collect();
  7.         }
  8.         return $this->data;
  9.     }
  11.     /**
DebugBar->getData() in /var/www/web89/html/joomla/plugins/system/debug/src/JavascriptRenderer.php (line 119)
  1.                 $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2.             }
  3.         }
  5.         $suffix = !$initialize ? '(ajax)' : null;
  6.         $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  8.         $nonce = '';
  10.         if ($doc->cspNonce) {
  11.             $nonce = ' nonce="' . $doc->cspNonce . '"';
JavascriptRenderer->render() in /var/www/web89/html/joomla/plugins/system/debug/src/Extension/Debug.php (line 368)
  1.             echo $contents;
  3.             return;
  4.         }
  6.         echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  7.     }
  9.     /**
  10.      * AJAX handler
  11.      *
in /var/www/web89/html/joomla/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 486)
  1.                 if ($event->isStopped())
  2.                 {
  3.                     return $event;
  4.                 }
  6.                 $listener($event);
  7.             }
  8.         }
  10.         return $event;
  11.     }
Dispatcher->dispatch('onAfterRespond') in /var/www/web89/html/joomla/libraries/src/Application/CMSApplication.php (line 332)
  2.         // Send the application response.
  3.         $this->respond();
  5.         // Trigger the onAfterRespond event.
  6.         $this->getDispatcher()->dispatch('onAfterRespond');
  7.     }
  9.     /**
  10.      * Check if the user is required to reset their password.
  11.      *
CMSApplication->execute() in /var/www/web89/html/joomla/includes/app.php (line 61)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/var/www/web89/html/joomla/includes/app.php') in /var/www/web89/html/joomla/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC', 1);
  5. // Run the application - All executable code should be triggered through this file
  6. require_once dirname(__FILE__) . '/includes/app.php';

mysqli_sql_exception

Prepared statement needs to be re-prepared

in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 435)
  1.             }
  2.         }
  4.         try
  5.         {
  6.             if (!$this->statement->execute())
  7.             {
  8.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  9.             }
  10.         }
  11.         catch (\Throwable $e)
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php -> execute (line 435)
  1.             }
  2.         }
  4.         try
  5.         {
  6.             if (!$this->statement->execute())
  7.             {
  8.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  9.             }
  10.         }
  11.         catch (\Throwable $e)
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 675)
  1.             $this->statement->bindParam($key, $obj->value, $obj->dataType);
  2.         }
  4.         try
  5.         {
  6.             $this->executed = $this->statement->execute();
  8.             // If there is a monitor registered, let it know we have finished this query
  9.             if ($this->monitor)
  10.             {
  11.                 $this->monitor->stopQuery();
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 1375)
  1.                 $this->statement->setFetchMode($fetchMode, $class);
  2.             }
  3.         }
  5.         // Execute the query and get the result set cursor.
  6.         $this->execute();
  8.         // Get all of the rows from the result set as objects of type $class.
  9.         while ($row = $this->fetchObject())
  10.         {
  11.             if ($key)
in /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> loadObjectList (line 527)
  1.     public function getConnectionEncryption(): string
  2.     {
  3.         $this->connect();
  5.         $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  6.             ->loadObjectList('Variable_name');
  8.         if (!empty($variables['Ssl_cipher']->Value))
  9.         {
  10.             return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  11.         }
MysqliDriver->getConnectionEncryption() in /var/www/web89/html/joomla/administrator/components/com_admin/src/Model/SysinfoModel.php (line 318)
  1.             'php'                    => php_uname(),
  2.             'dbserver'               => $db->getServerType(),
  3.             'dbversion'              => $db->getVersion(),
  4.             'dbcollation'            => $db->getCollation(),
  5.             'dbconnectioncollation'  => $db->getConnectionCollation(),
  6.             'dbconnectionencryption' => $db->getConnectionEncryption(),
  7.             'dbconnencryptsupported' => $db->isConnectionEncryptionSupported(),
  8.             'phpversion'             => PHP_VERSION,
  9.             'server'                 => $_SERVER['SERVER_SOFTWARE'] ?? getenv('SERVER_SOFTWARE'),
  10.             'sapi_name'              => PHP_SAPI,
  11.             'version'                => (new Version())->getLongVersion(),
SysinfoModel->getInfo() in /var/www/web89/html/joomla/plugins/system/debug/src/DataCollector/InfoCollector.php (line 136)
  1.             'joomlaVersion' => JVERSION,
  2.             'requestId'     => $this->requestId,
  3.             'identity'      => $this->getIdentityInfo($application->getIdentity()),
  4.             'response'      => $this->getResponseInfo($application->getResponse()),
  5.             'template'      => $this->getTemplateInfo($application->getTemplate(true)),
  6.             'database'      => $this->getDatabaseInfo($model->getInfo()),
  7.         ];
  8.     }
  10.     /**
  11.      * Get Identity info.
in /var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 238)
  1.                 $request_variables
  2.             )
  3.         );
  5.         foreach ($this->collectors as $name => $collector) {
  6.             $this->data[$name] = $collector->collect();
  7.         }
  9.         // Remove all invalid (non UTF-8) characters
  10.         array_walk_recursive($this->data, function (&$item) {
  11.                 if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
in /var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 265)
  1.      * @return array
  2.      */
  3.     public function getData()
  4.     {
  5.         if ($this->data === null) {
  6.             $this->collect();
  7.         }
  8.         return $this->data;
  9.     }
  11.     /**
DebugBar->getData() in /var/www/web89/html/joomla/plugins/system/debug/src/JavascriptRenderer.php (line 119)
  1.                 $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2.             }
  3.         }
  5.         $suffix = !$initialize ? '(ajax)' : null;
  6.         $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  8.         $nonce = '';
  10.         if ($doc->cspNonce) {
  11.             $nonce = ' nonce="' . $doc->cspNonce . '"';
JavascriptRenderer->render() in /var/www/web89/html/joomla/plugins/system/debug/src/Extension/Debug.php (line 368)
  1.             echo $contents;
  3.             return;
  4.         }
  6.         echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  7.     }
  9.     /**
  10.      * AJAX handler
  11.      *
in /var/www/web89/html/joomla/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 486)
  1.                 if ($event->isStopped())
  2.                 {
  3.                     return $event;
  4.                 }
  6.                 $listener($event);
  7.             }
  8.         }
  10.         return $event;
  11.     }
Dispatcher->dispatch('onAfterRespond') in /var/www/web89/html/joomla/libraries/src/Application/CMSApplication.php (line 332)
  2.         // Send the application response.
  3.         $this->respond();
  5.         // Trigger the onAfterRespond event.
  6.         $this->getDispatcher()->dispatch('onAfterRespond');
  7.     }
  9.     /**
  10.      * Check if the user is required to reset their password.
  11.      *
CMSApplication->execute() in /var/www/web89/html/joomla/includes/app.php (line 61)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/var/www/web89/html/joomla/includes/app.php') in /var/www/web89/html/joomla/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC', 1);
  5. // Run the application - All executable code should be triggered through this file
  6. require_once dirname(__FILE__) . '/includes/app.php';

Stack Traces 2

[2/2] ExecutionFailureException 
Joomla\Database\Exception\ExecutionFailureException:
Prepared statement needs to be re-prepared

  at /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:442
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php:675)
  at Joomla\Database\DatabaseDriver->execute()
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php:1375)
  at Joomla\Database\DatabaseDriver->loadObjectList('Variable_name')
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:527)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/var/www/web89/html/joomla/administrator/components/com_admin/src/Model/SysinfoModel.php:318)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/var/www/web89/html/joomla/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/var/www/web89/html/joomla/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/var/www/web89/html/joomla/plugins/system/debug/src/Extension/Debug.php:368)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond(object(Event))
     (/var/www/web89/html/joomla/libraries/vendor/joomla/event/src/Dispatcher.php:486)
  at Joomla\Event\Dispatcher->dispatch('onAfterRespond')
     (/var/www/web89/html/joomla/libraries/src/Application/CMSApplication.php:332)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/web89/html/joomla/includes/app.php:61)
  at require_once('/var/www/web89/html/joomla/includes/app.php')
     (/var/www/web89/html/joomla/index.php:32)
[1/2] mysqli_sql_exception 
mysqli_sql_exception:
Prepared statement needs to be re-prepared

  at /var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:435
  at mysqli_stmt->execute()
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:435)
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php:675)
  at Joomla\Database\DatabaseDriver->execute()
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/DatabaseDriver.php:1375)
  at Joomla\Database\DatabaseDriver->loadObjectList('Variable_name')
     (/var/www/web89/html/joomla/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:527)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/var/www/web89/html/joomla/administrator/components/com_admin/src/Model/SysinfoModel.php:318)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/var/www/web89/html/joomla/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/var/www/web89/html/joomla/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/var/www/web89/html/joomla/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/var/www/web89/html/joomla/plugins/system/debug/src/Extension/Debug.php:368)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond(object(Event))
     (/var/www/web89/html/joomla/libraries/vendor/joomla/event/src/Dispatcher.php:486)
  at Joomla\Event\Dispatcher->dispatch('onAfterRespond')
     (/var/www/web89/html/joomla/libraries/src/Application/CMSApplication.php:332)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/web89/html/joomla/includes/app.php:61)
  at require_once('/var/www/web89/html/joomla/includes/app.php')
     (/var/www/web89/html/joomla/index.php:32)