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

Show exception properties
Joomla\Database\Exception\ExecutionFailureException {#1548
  -query: "SHOW SESSION STATUS WHERE `Variable_name` IN ('Ssl_version', 'Ssl_cipher')"
}
  1. try {
  2. if (!$this->statement->execute()) {
  3. throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  4. }
  5. } catch (\Throwable $e) {
  6. throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  7. }
  8. if ($this->columnNames === null) {
  9. $meta = $this->statement->result_metadata();
  1. foreach ($bounded as $key => $obj) {
  2. $this->statement->bindParam($key, $obj->value, $obj->dataType);
  3. }
  4. try {
  5. $this->executed = $this->statement->execute();
  6. // If there is a monitor registered, let it know we have finished this query
  7. if ($this->monitor) {
  8. $this->monitor->stopQuery();
  9. }
  1. $this->statement->setFetchMode($fetchMode, $class);
  2. }
  3. }
  4. // Execute the query and get the result set cursor.
  5. $this->execute();
  6. // Get all of the rows from the result set as objects of type $class.
  7. while ($row = $this->fetchObject()) {
  8. if ($key) {
  9. $array[$row->$key] = $row;
  1. public function getConnectionEncryption(): string
  2. {
  3. $this->connect();
  4. $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  5. ->loadObjectList('Variable_name');
  6. if (!empty($variables['Ssl_cipher']->Value)) {
  7. return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  8. }
  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(),
  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. }
  9. /**
  10. * Get Identity info.
  1. $request_variables
  2. )
  3. );
  4. foreach ($this->collectors as $name => $collector) {
  5. $this->data[$name] = $collector->collect();
  6. }
  7. // Remove all invalid (non UTF-8) characters
  8. array_walk_recursive($this->data, function (&$item) {
  9. if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
  1. * @return array
  2. */
  3. public function getData()
  4. {
  5. if ($this->data === null) {
  6. $this->collect();
  7. }
  8. return $this->data;
  9. }
  10. /**
  1. $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2. }
  3. }
  4. $suffix = !$initialize ? '(ajax)' : null;
  5. $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  6. $nonce = '';
  7. if ($doc->cspNonce) {
  8. $nonce = ' nonce="' . $doc->cspNonce . '"';
  1. echo $contents;
  2. return;
  3. }
  4. echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  5. }
  6. /**
  7. * AJAX handler
  8. *
  1. foreach ($this->listeners[$event->getName()] as $listener) {
  2. if ($event->isStopped()) {
  3. return $event;
  4. }
  5. $listener($event);
  6. }
  7. }
  8. return $event;
  9. }
  1. $dispatcher = $this->getDispatcher();
  2. } catch (\UnexpectedValueException $exception) {
  3. return null;
  4. }
  5. return $dispatcher->dispatch($eventName, $event ?: new ApplicationEvent($eventName, $this));
  6. }
  7. /**
  8. * Method to run the application routines.
  9. *
AbstractApplication->dispatchEvent('onAfterRespond', object(AfterRespondEvent)) in /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/src/Application/CMSApplication.php (line 347)
  1. // Send the application response.
  2. $this->respond();
  3. // Trigger the onAfterRespond event.
  4. $this->dispatchEvent(
  5. 'onAfterRespond',
  6. new AfterRespondEvent('onAfterRespond', ['subject' => $this])
  7. );
  8. }
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application = $app;
  3. // Execute the application.
  4. $app->execute();
require_once('/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php') in /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/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);
  4. // Run the application - All executable code should be triggered through this file
  5. require_once __DIR__ . '/includes/app.php';

mysqli_sql_exception

Prepared statement needs to be re-prepared

  1. throw new PrepareStatementFailureException($this->statement->error, $this->statement->errno);
  2. }
  3. }
  4. try {
  5. if (!$this->statement->execute()) {
  6. throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  7. }
  8. } catch (\Throwable $e) {
  9. throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  10. }
  1. throw new PrepareStatementFailureException($this->statement->error, $this->statement->errno);
  2. }
  3. }
  4. try {
  5. if (!$this->statement->execute()) {
  6. throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  7. }
  8. } catch (\Throwable $e) {
  9. throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  10. }
  1. foreach ($bounded as $key => $obj) {
  2. $this->statement->bindParam($key, $obj->value, $obj->dataType);
  3. }
  4. try {
  5. $this->executed = $this->statement->execute();
  6. // If there is a monitor registered, let it know we have finished this query
  7. if ($this->monitor) {
  8. $this->monitor->stopQuery();
  9. }
  1. $this->statement->setFetchMode($fetchMode, $class);
  2. }
  3. }
  4. // Execute the query and get the result set cursor.
  5. $this->execute();
  6. // Get all of the rows from the result set as objects of type $class.
  7. while ($row = $this->fetchObject()) {
  8. if ($key) {
  9. $array[$row->$key] = $row;
  1. public function getConnectionEncryption(): string
  2. {
  3. $this->connect();
  4. $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  5. ->loadObjectList('Variable_name');
  6. if (!empty($variables['Ssl_cipher']->Value)) {
  7. return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  8. }
  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(),
  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. }
  9. /**
  10. * Get Identity info.
  1. $request_variables
  2. )
  3. );
  4. foreach ($this->collectors as $name => $collector) {
  5. $this->data[$name] = $collector->collect();
  6. }
  7. // Remove all invalid (non UTF-8) characters
  8. array_walk_recursive($this->data, function (&$item) {
  9. if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
  1. * @return array
  2. */
  3. public function getData()
  4. {
  5. if ($this->data === null) {
  6. $this->collect();
  7. }
  8. return $this->data;
  9. }
  10. /**
  1. $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2. }
  3. }
  4. $suffix = !$initialize ? '(ajax)' : null;
  5. $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  6. $nonce = '';
  7. if ($doc->cspNonce) {
  8. $nonce = ' nonce="' . $doc->cspNonce . '"';
  1. echo $contents;
  2. return;
  3. }
  4. echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  5. }
  6. /**
  7. * AJAX handler
  8. *
  1. foreach ($this->listeners[$event->getName()] as $listener) {
  2. if ($event->isStopped()) {
  3. return $event;
  4. }
  5. $listener($event);
  6. }
  7. }
  8. return $event;
  9. }
  1. $dispatcher = $this->getDispatcher();
  2. } catch (\UnexpectedValueException $exception) {
  3. return null;
  4. }
  5. return $dispatcher->dispatch($eventName, $event ?: new ApplicationEvent($eventName, $this));
  6. }
  7. /**
  8. * Method to run the application routines.
  9. *
AbstractApplication->dispatchEvent('onAfterRespond', object(AfterRespondEvent)) in /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/src/Application/CMSApplication.php (line 347)
  1. // Send the application response.
  2. $this->respond();
  3. // Trigger the onAfterRespond event.
  4. $this->dispatchEvent(
  5. 'onAfterRespond',
  6. new AfterRespondEvent('onAfterRespond', ['subject' => $this])
  7. );
  8. }
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application = $app;
  3. // Execute the application.
  4. $app->execute();
require_once('/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php') in /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/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);
  4. // Run the application - All executable code should be triggered through this file
  5. require_once __DIR__ . '/includes/app.php';

Stack Traces 2

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

  at /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/DatabaseDriver.php:651)
  at Joomla\Database\DatabaseDriver->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/DatabaseDriver.php:1304)
  at Joomla\Database\DatabaseDriver->loadObjectList('Variable_name')
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:444)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/administrator/components/com_admin/src/Model/SysinfoModel.php:321)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/php-debugbar/php-debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/php-debugbar/php-debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/Extension/Debug.php:378)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond(object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/event/src/Dispatcher.php:454)
  at Joomla\Event\Dispatcher->dispatch('onAfterRespond', object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/application/src/AbstractApplication.php:99)
  at Joomla\Application\AbstractApplication->dispatchEvent('onAfterRespond', object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/src/Application/CMSApplication.php:347)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php:58)
  at require_once('/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php')
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/index.php:32)                
[1/2] mysqli_sql_exception
mysqli_sql_exception:
Prepared statement needs to be re-prepared

  at /home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
  at mysqli_stmt->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407)
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/DatabaseDriver.php:651)
  at Joomla\Database\DatabaseDriver->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/DatabaseDriver.php:1304)
  at Joomla\Database\DatabaseDriver->loadObjectList('Variable_name')
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:444)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/administrator/components/com_admin/src/Model/SysinfoModel.php:321)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/php-debugbar/php-debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/php-debugbar/php-debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/plugins/system/debug/src/Extension/Debug.php:378)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond(object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/event/src/Dispatcher.php:454)
  at Joomla\Event\Dispatcher->dispatch('onAfterRespond', object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/vendor/joomla/application/src/AbstractApplication.php:99)
  at Joomla\Application\AbstractApplication->dispatchEvent('onAfterRespond', object(AfterRespondEvent))
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/libraries/src/Application/CMSApplication.php:347)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php:58)
  at require_once('/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/includes/app.php')
     (/home/ch311323/web/fn-solutions.ch/public_html/Joomla_5.3.1-Full/index.php:32)