mysqli_sql_exception Error

HTTP 500 Whoops, looks like something went wrong.

mysqli object is not fully initialized

Exceptions 2

Error

in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php (line 347)
  1. return str_replace(',', '.', (string) $text);
  2. }
  4. $this->connect();
  6. $result = $this->connection->real_escape_string((string) $text);
  8. if ($extra) {
  9. $result = addcslashes($result, '%_');
  10. }
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> real_escape_string (line 347)
  1. return str_replace(',', '.', (string) $text);
  2. }
  4. $this->connect();
  6. $result = $this->connection->real_escape_string((string) $text);
  8. if ($extra) {
  9. $result = addcslashes($result, '%_');
  10. }
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php -> escape (line 1467)
  1. }
  3. return $text;
  4. }
  6. return '\'' . ($escape ? $this->escape($text) : $text) . '\'';
  7. }
  9. /**
  10. * Quotes a binary string to database requirements for use in database queries.
  11. *
DatabaseDriver->quote() in /var/www/html/rubicsisorg/administrator/components/com_templates/src/Model/StyleModel.php (line 712)
  1. )
  2. ->join(
  3. 'LEFT',
  4. $db->quoteName('#__extensions', 'e'),
  5. $db->quoteName('e.element') . ' = ' . $db->quoteName('s.template')
  6. . ' AND ' . $db->quoteName('e.type') . ' = ' . $db->quote('template')
  7. . ' AND ' . $db->quoteName('e.client_id') . ' = ' . $db->quoteName('s.client_id')
  8. );
  10. $db->setQuery($query);
StyleModel->getSiteTemplates() in /var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php (line 460)
  2. if ($cache->contains($cacheId)) {
  3. $templates = $cache->get($cacheId);
  4. } else {
  5. $templates = $this->bootComponent('templates')->getMVCFactory()
  6. ->createModel('Style', 'Administrator')->getSiteTemplates();
  8. foreach ($templates as &$template) {
  9. // Create home element
  10. if ($template->home == 1 && !isset($template_home) || $this->getLanguageFilter() && $template->home == $tag) {
  11. $template_home = clone $template;
SiteApplication->getTemplate() in /var/www/html/rubicsisorg/libraries/src/Error/Renderer/HtmlRenderer.php (line 50)
  1. public function render(\Throwable $error): string
  2. {
  3. $app = Factory::getApplication();
  5. // Get the current template from the application
  6. $template = $app->getTemplate(true);
  8. // Push the error object into the document
  9. $this->getDocument()->setError($error);
  11. // Add registry file for the template asset
HtmlRenderer->render() in /var/www/html/rubicsisorg/libraries/src/Exception/ExceptionHandler.php (line 139)
  1. 'subject' => $app,
  2. 'document' => $renderer->getDocument(),
  3. ])
  4. );
  6. $data = $renderer->render($error);
  8. // If nothing was rendered, just use the message from the Exception
  9. if (empty($data)) {
  10. $data = $error->getMessage();
  11. }
ExceptionHandler::render() in /var/www/html/rubicsisorg/libraries/src/Exception/ExceptionHandler.php (line 73)
  1. * @since 3.10.0
  2. */
  3. public static function handleException(\Throwable $error)
  4. {
  5. static::logException($error);
  6. static::render($error);
  7. }
  9. /**
  10. * Render the error page based on an exception.
  11. *
ExceptionHandler::handleException() in /var/www/html/rubicsisorg/libraries/src/Application/CMSApplication.php (line 334)
  1. );
  3. // Trigger the onError event.
  4. $this->dispatchEvent('onError', $event);
  6. ExceptionHandler::handleException($event->getError());
  7. }
  9. // Trigger the onBeforeRespond event.
  10. $this->dispatchEvent(
  11. 'onBeforeRespond',
CMSApplication->execute() in /var/www/html/rubicsisorg/includes/app.php (line 58)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/var/www/html/rubicsisorg/includes/app.php') in /var/www/html/rubicsisorg/index.php (line 54)
  1. // ... die
  2. die();
  3. }
  5. // Run the application - All executable code should be triggered through this file
  6. require_once __DIR__ . '/includes/app.php';

mysqli_sql_exception

Connection refused

in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php (line 236)
  1. $this->options['ssl']['cipher']
  2. );
  3. }
  5. // Attempt to connect to the server, use error suppression to silence warnings and allow us to throw an Exception separately.
  6. $connected = @$this->connection->real_connect(
  7. $this->options['host'],
  8. $this->options['user'],
  9. $this->options['password'],
  10. null,
  11. $this->options['port'],
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> real_connect (line 236)
  1. $this->options['ssl']['cipher']
  2. );
  3. }
  5. // Attempt to connect to the server, use error suppression to silence warnings and allow us to throw an Exception separately.
  6. $connected = @$this->connection->real_connect(
  7. $this->options['host'],
  8. $this->options['user'],
  9. $this->options['password'],
  10. null,
  11. $this->options['port'],
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php -> connect (line 670)
  1. // Check if the server was disconnected.
  2. if (!$this->connected()) {
  3. try {
  4. // Attempt to reconnect.
  5. $this->connection = null;
  6. $this->connect();
  7. } catch (ConnectionFailureException $e) {
  8. // If connect fails, ignore that exception and throw the normal exception.
  9. throw $exception;
  10. }
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 1304)
  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. if ($key) {
  11. $array[$row->$key] = $row;
in /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> loadObjectList (line 539)
  1. $this->connect();
  3. $result = [];
  5. // Set the query to get the table fields statement.
  6. $fields = $this->setQuery('SHOW FULL COLUMNS FROM ' . $this->quoteName($this->escape($table)))->loadObjectList();
  8. // If we only want the type as the value add just that to the list.
  9. if ($typeOnly) {
  10. foreach ($fields as $field) {
  11. $result[$field->Field] = preg_replace('/[(0-9)]/', '', $field->Type);
MysqliDriver->getTableColumns() in /var/www/html/rubicsisorg/libraries/src/Table/Table.php (line 260)
  1. $key = $db->getServerType() . ':' . $db->getName() . ':' . $this->_tbl;
  3. if (!isset(self::$tableFields[$key]) || $reload) {
  4. // Lookup the fields for this table only once.
  5. $name = $this->_tbl;
  6. $fields = $db->getTableColumns($name, false);
  8. if (empty($fields)) {
  9. throw new \UnexpectedValueException(\sprintf('No columns found for %s table', $name));
  10. }
Table->getFields() in /var/www/html/rubicsisorg/libraries/src/Table/Table.php (line 204)
  1. $this->_tbl_key = $this->getKeyName();
  3. $this->setDatabase($db);
  5. // Initialise the table properties.
  6. $fields = $this->getFields();
  8. if ($fields) {
  9. foreach ($fields as $name => $v) {
  10. // Add the field if it is not already present.
  11. if (!$this->hasField($name)) {
Table->__construct() in /var/www/html/rubicsisorg/libraries/src/Table/User.php (line 61)
  1. *
  2. * @since 1.7.0
  3. */
  4. public function __construct(DatabaseInterface $db, ?DispatcherInterface $dispatcher = null)
  5. {
  6. parent::__construct('#__users', 'id', $db, $dispatcher);
  8. // Initialise.
  9. $this->id = 0;
  10. $this->sendEmail = 0;
  11. }
User->__construct() in /var/www/html/rubicsisorg/libraries/src/Table/Table.php (line 352)
  1. if (Factory::getContainer()->has($tableClass)) {
  2. return Factory::getContainer()->get($tableClass);
  3. }
  5. // Instantiate a new table class and return it.
  6. return new $tableClass($db);
  7. }
  9. /**
  10. * Add a filesystem path where Table should search for table class files.
  11. *
Table::getInstance() in /var/www/html/rubicsisorg/libraries/src/User/User.php (line 596)
  1. $tabletype['name'] = $type;
  2. $tabletype['prefix'] = $prefix;
  3. }
  5. // Create the user table object
  6. return Table::getInstance($tabletype['name'], $tabletype['prefix']);
  7. }
  9. /**
  10. * Method to bind an associative array of data to a user object
  11. *
User::getTable() in /var/www/html/rubicsisorg/libraries/src/User/User.php (line 871)
  1. * @since 1.7.0
  2. */
  3. public function load($id)
  4. {
  5. // Create the user table object
  6. $table = static::getTable();
  8. // Load the UserModel object based on the user id or throw a warning.
  9. if (!$table->load($id)) {
  10. // Reset to guest user
  11. $this->guest = 1;
User->load() in /var/www/html/rubicsisorg/libraries/src/User/User.php (line 277)
  1. // Create the user parameters object
  2. $this->_params = new Registry();
  4. // Load the user if it exists
  5. if (!empty($identifier)) {
  6. $this->load($identifier);
  7. } else {
  8. // Initialise
  9. $this->id = 0;
  10. $this->sendEmail = 0;
  11. $this->guest = 1;
User->__construct() in /var/www/html/rubicsisorg/libraries/src/User/UserFactory.php (line 53)
  1. *
  2. * @since 4.0.0
  3. */
  4. public function loadUserById(int $id): User
  5. {
  6. return new User($id);
  7. }
  9. /**
  10. * Method to get an instance of a user for the given username.
  11. *
UserFactory->loadUserById() in /var/www/html/rubicsisorg/libraries/src/User/User.php (line 324)
  1. return Factory::getContainer()->get(UserFactoryInterface::class)->loadUserById($id);
  2. }
  4. // Check if the user ID is already cached.
  5. if (empty(self::$instances[$id])) {
  6. self::$instances[$id] = Factory::getContainer()->get(UserFactoryInterface::class)->loadUserById($id);
  7. }
  9. return self::$instances[$id];
  10. }
User::getInstance() in /var/www/html/rubicsisorg/libraries/src/Factory.php (line 380)
  1. if (!($instance instanceof User)) {
  2. $instance = User::getInstance();
  3. }
  4. } elseif (!($instance instanceof User) || \is_string($id) || $instance->id !== $id) {
  5. // Check if we have a string as the id or if the numeric id is the current instance
  6. $instance = User::getInstance($id);
  7. }
  9. return $instance;
  10. }
Factory::getUser() in /var/www/html/rubicsisorg/components/com_sppagebuilder/helpers/articles.php (line 191)
  2. foreach ($items as &$item) {
  4. $item->slug = $item->id . ':' . $item->alias;
  5. $item->catslug = $item->catid . ':' . $item->category_alias;
  6. $item->username = Factory::getUser($item->created_by)->name;
  7. $item->profile_image = $item->profile_image ?? '';
  8. $item->link = Route::_(version_compare($JoomlaVersion, '4.0.0', '>=') ? Joomla\Component\Content\Site\Helper\RouteHelper::getArticleRoute($item->slug, $item->catid, $item->language) : ContentHelperRoute::getArticleRoute($item->slug, $item->catid, $item->language));
  9. $attribs = json_decode($item->attribs);
  11. $item->tags = new TagsHelper;
SppagebuilderHelperArticles::getArticles() in /var/www/html/rubicsisorg/components/com_sppagebuilder/router.php (line 155)
  1. if (!\class_exists('SppagebuilderHelperArticles')) {
  2. require_once JPATH_ROOT . '/components/com_sppagebuilder/helpers/articles.php';
  3. }
  5. $articlesCount = \SppagebuilderHelperArticles::getArticlesCount();
  6. $articles = \SppagebuilderHelperArticles::getArticles($articlesCount);
  7. foreach ($articles as $article) {
  8. if ($article->alias === $alias) {
  9. return 'articles';
  10. }
  11. }
SppagebuilderRouterBase::getCollectionTypeFromAlias() in /var/www/html/rubicsisorg/components/com_sppagebuilder/router.php (line 195)
  2. return $vars;
  3. }
  5. // determine collection type based on alias
  6. $collectionType = static::getCollectionTypeFromAlias($segments[0]);
  8. $collectionItemIds = static::getCollectionItemIdsFromSlugs($segments);
  10. $isValidCollectionPage = false;
SppagebuilderRouterBase::parseRoute() in /var/www/html/rubicsisorg/components/com_sppagebuilder/router.php (line 590)
  1. return $segments;
  2. }
  4. public function parse(&$segments)
  5. {
  6. $vars = SppagebuilderRouterBase::parseRoute($segments);
  8. if (count($vars))
  9. {
  10. $segments = array();
  11. }
SppagebuilderRouter->parse() in /var/www/html/rubicsisorg/libraries/src/Router/SiteRouter.php (line 287)
  2. if (\count($segments)) {
  3. // Handle component route
  4. $component = preg_replace('/[^A-Z0-9_\.-]/i', '', $uri->getVar('option'));
  5. $crouter = $this->getComponentRouter($component);
  6. $uri->setQuery(array_merge($uri->getQuery(true), $crouter->parse($segments)));
  7. }
  9. $route = implode('/', $segments);
  10. }
SiteRouter->parseSefRoute() in /var/www/html/rubicsisorg/libraries/src/Router/Router.php (line 423)
  1. if (!\array_key_exists('parse' . $stage, $this->rules)) {
  2. throw new \InvalidArgumentException(\sprintf('The %s stage is not registered. (%s)', $stage, __METHOD__));
  3. }
  5. foreach ($this->rules['parse' . $stage] as $rule) {
  6. $rule($this, $uri);
  7. }
  8. }
  10. /**
  11. * Process the build uri query data based on custom defined rules
Router->processParseRules() in /var/www/html/rubicsisorg/libraries/src/Router/Router.php (line 158)
  2. // Do the preprocess stage of the URL parse process
  3. $this->processParseRules($uri, self::PROCESS_BEFORE);
  5. // Do the main stage of the URL parse process
  6. $this->processParseRules($uri);
  8. // Do the postprocess stage of the URL parse process
  9. $this->processParseRules($uri, self::PROCESS_AFTER);
  11. // Check if all parts of the URL have been parsed.
Router->parse() in /var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php (line 767)
  1. // Get the full request URI.
  2. $uri = clone Uri::getInstance();
  4. // It is not possible to inject the SiteRouter as it requires a SiteApplication
  5. // and we would end in an infinite loop
  6. $result = $this->getContainer()->get(SiteRouter::class)->parse($uri, true);
  8. $active = $this->getMenu()->getActive();
  10. if (
  11. $active !== null
SiteApplication->route() in /var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php (line 243)
  2. // Mark afterInitialise in the profiler.
  3. JDEBUG ? $this->profiler->mark('afterInitialise') : null;
  5. // Route the application
  6. $this->route();
  8. // Mark afterRoute in the profiler.
  9. JDEBUG ? $this->profiler->mark('afterRoute') : null;
  11. if (!$this->isHandlingMultiFactorAuthentication()) {
SiteApplication->doExecute() in /var/www/html/rubicsisorg/libraries/src/Application/CMSApplication.php (line 304)
  1. $this->sanityCheckSystemVariables();
  2. $this->setupLogging();
  3. $this->createExtensionNamespaceMap();
  5. // Perform application routines.
  6. $this->doExecute();
  8. // If we have an application document object, render it.
  9. if ($this->document instanceof \Joomla\CMS\Document\Document) {
  10. // Render the application output.
  11. $this->render();
CMSApplication->execute() in /var/www/html/rubicsisorg/includes/app.php (line 58)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/var/www/html/rubicsisorg/includes/app.php') in /var/www/html/rubicsisorg/index.php (line 54)
  1. // ... die
  2. die();
  3. }
  5. // Run the application - All executable code should be triggered through this file
  6. require_once __DIR__ . '/includes/app.php';

Stack Traces 2

[2/2] Error 
Error:
mysqli object is not fully initialized

  at /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:347
  at mysqli->real_escape_string()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:347)
  at Joomla\Database\Mysqli\MysqliDriver->escape()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php:1467)
  at Joomla\Database\DatabaseDriver->quote()
     (/var/www/html/rubicsisorg/administrator/components/com_templates/src/Model/StyleModel.php:712)
  at Joomla\Component\Templates\Administrator\Model\StyleModel->getSiteTemplates()
     (/var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php:460)
  at Joomla\CMS\Application\SiteApplication->getTemplate()
     (/var/www/html/rubicsisorg/libraries/src/Error/Renderer/HtmlRenderer.php:50)
  at Joomla\CMS\Error\Renderer\HtmlRenderer->render()
     (/var/www/html/rubicsisorg/libraries/src/Exception/ExceptionHandler.php:139)
  at Joomla\CMS\Exception\ExceptionHandler::render()
     (/var/www/html/rubicsisorg/libraries/src/Exception/ExceptionHandler.php:73)
  at Joomla\CMS\Exception\ExceptionHandler::handleException()
     (/var/www/html/rubicsisorg/libraries/src/Application/CMSApplication.php:334)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/html/rubicsisorg/includes/app.php:58)
  at require_once('/var/www/html/rubicsisorg/includes/app.php')
     (/var/www/html/rubicsisorg/index.php:54)
[1/2] mysqli_sql_exception 
mysqli_sql_exception:
Connection refused

  at /var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:236
  at mysqli->real_connect()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:236)
  at Joomla\Database\Mysqli\MysqliDriver->connect()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php:670)
  at Joomla\Database\DatabaseDriver->execute()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/DatabaseDriver.php:1304)
  at Joomla\Database\DatabaseDriver->loadObjectList()
     (/var/www/html/rubicsisorg/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539)
  at Joomla\Database\Mysqli\MysqliDriver->getTableColumns()
     (/var/www/html/rubicsisorg/libraries/src/Table/Table.php:260)
  at Joomla\CMS\Table\Table->getFields()
     (/var/www/html/rubicsisorg/libraries/src/Table/Table.php:204)
  at Joomla\CMS\Table\Table->__construct()
     (/var/www/html/rubicsisorg/libraries/src/Table/User.php:61)
  at Joomla\CMS\Table\User->__construct()
     (/var/www/html/rubicsisorg/libraries/src/Table/Table.php:352)
  at Joomla\CMS\Table\Table::getInstance()
     (/var/www/html/rubicsisorg/libraries/src/User/User.php:596)
  at Joomla\CMS\User\User::getTable()
     (/var/www/html/rubicsisorg/libraries/src/User/User.php:871)
  at Joomla\CMS\User\User->load()
     (/var/www/html/rubicsisorg/libraries/src/User/User.php:277)
  at Joomla\CMS\User\User->__construct()
     (/var/www/html/rubicsisorg/libraries/src/User/UserFactory.php:53)
  at Joomla\CMS\User\UserFactory->loadUserById()
     (/var/www/html/rubicsisorg/libraries/src/User/User.php:324)
  at Joomla\CMS\User\User::getInstance()
     (/var/www/html/rubicsisorg/libraries/src/Factory.php:380)
  at Joomla\CMS\Factory::getUser()
     (/var/www/html/rubicsisorg/components/com_sppagebuilder/helpers/articles.php:191)
  at SppagebuilderHelperArticles::getArticles()
     (/var/www/html/rubicsisorg/components/com_sppagebuilder/router.php:155)
  at SppagebuilderRouterBase::getCollectionTypeFromAlias()
     (/var/www/html/rubicsisorg/components/com_sppagebuilder/router.php:195)
  at SppagebuilderRouterBase::parseRoute()
     (/var/www/html/rubicsisorg/components/com_sppagebuilder/router.php:590)
  at SppagebuilderRouter->parse()
     (/var/www/html/rubicsisorg/libraries/src/Router/SiteRouter.php:287)
  at Joomla\CMS\Router\SiteRouter->parseSefRoute()
     (/var/www/html/rubicsisorg/libraries/src/Router/Router.php:423)
  at Joomla\CMS\Router\Router->processParseRules()
     (/var/www/html/rubicsisorg/libraries/src/Router/Router.php:158)
  at Joomla\CMS\Router\Router->parse()
     (/var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php:767)
  at Joomla\CMS\Application\SiteApplication->route()
     (/var/www/html/rubicsisorg/libraries/src/Application/SiteApplication.php:243)
  at Joomla\CMS\Application\SiteApplication->doExecute()
     (/var/www/html/rubicsisorg/libraries/src/Application/CMSApplication.php:304)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/html/rubicsisorg/includes/app.php:58)
  at require_once('/var/www/html/rubicsisorg/includes/app.php')
     (/var/www/html/rubicsisorg/index.php:54)
An Error Occurred: Whoops, looks like something went wrong.

Sorry, there was a problem we could not recover from.

The server returned a "500 - Whoops, looks like something went wrong."

Help me resolve this