mysqli_sql_exception Error

HTTP 500 Whoops, looks like something went wrong.

mysqli object is not fully initialized

Exceptions 2

Error

  1.         $this->connection   $connection;
  2.         $this->query        $query;
  3.         $query $this->prepareParameterKeyMapping($query);
  4.         $this->statement  $connection->prepare($query);
  5.         if (!$this->statement) {
  6.             throw new PrepareStatementFailureException($this->connection->error$this->connection->errno);
  7.         }
  8.     }
mysqli->prepare('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `iric_menu` AS `m` LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?) ORDER BY `m`.`lft`') in D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php (line 138)
  1.         $this->connection   $connection;
  2.         $this->query        $query;
  3.         $query $this->prepareParameterKeyMapping($query);
  4.         $this->statement  $connection->prepare($query);
  5.         if (!$this->statement) {
  6.             throw new PrepareStatementFailureException($this->connection->error$this->connection->errno);
  7.         }
  8.     }
MysqliStatement->__construct(object(mysqli), 'SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `iric_menu` AS `m` LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?) ORDER BY `m`.`lft`') in D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php (line 1020)
  1.      * @since   2.0.0
  2.      * @throws  PrepareStatementFailureException
  3.      */
  4.     protected function prepareStatement(string $query): StatementInterface
  5.     {
  6.         return new MysqliStatement($this->connection$query);
  7.     }
  8.     /**
  9.      * Unlocks tables in the database.
  10.      *
MysqliDriver->prepareStatement('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `iric_menu` AS `m` LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`') in D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\DatabaseDriver.php (line 1785)
  1.         $query->setLimit($limit$offset);
  2.         $sql $this->replacePrefix((string) $query);
  3.         $this->statement $this->prepareStatement($sql);
  4.         $this->sql    $query;
  5.         $this->limit  = (int) max(0$limit);
  6.         $this->offset = (int) max(0$offset);
DatabaseDriver->setQuery(object(MysqliQuery)) in D:\xampp\htdocs\iric\libraries\src\Menu\SiteMenu.php (line 166)
  1.                 )
  2.                 ->bind(':currentDate2'$currentDate)
  3.                 ->order($this->db->quoteName('m.lft'));
  4.             $items    = [];
  5.             $iterator $this->db->setQuery($query)->getIterator();
  6.             foreach ($iterator as $item) {
  7.                 $items[$item->id] = new MenuItem((array) $item);
  8.             }
SiteMenu->Joomla\CMS\Menu\{closure}() in D:\xampp\htdocs\iric\libraries\src\Cache\Controller\CallbackController.php (line 51)
  1.             $referenceArgs = &$args;
  2.         }
  3.         // Just execute the callback if caching is disabled.
  4.         if (empty($this->options['caching'])) {
  5.             return \call_user_func_array($callback$referenceArgs);
  6.         }
  7.         if (!$id) {
  8.             // Generate an ID
  9.             $id $this->_makeId($callback$args);
CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false) in D:\xampp\htdocs\iric\libraries\src\Menu\SiteMenu.php (line 179)
  1.         try {
  2.             /** @var CallbackController $cache */
  3.             $cache $this->getCacheControllerFactory()->createCacheController('callback', ['defaultgroup' => 'com_menus']);
  4.             $this->items $cache->get($loader, [], md5(\get_class($this)), false);
  5.         } catch (CacheExceptionInterface $e) {
  6.             try {
  7.                 $this->items $loader();
  8.             } catch (ExecutionFailureException $databaseException) {
  9.                 $this->app->enqueueMessage(Text::sprintf('JERROR_LOADING_MENUS'$databaseException->getMessage()), 'warning');
  1.      * @since   1.5
  2.      */
  3.     public function getMenu()
  4.     {
  5.         if (!$this->itemsLoaded) {
  6.             $this->load();
  7.             foreach ($this->items as $item) {
  8.                 if ($item->home) {
  9.                     $this->default[trim($item->language)] = $item->id;
  10.                 }
  1.      */
  2.     public function getItem($id)
  3.     {
  4.         $result null;
  5.         if (isset($this->getMenu()[$id])) {
  6.             $result = &$this->getMenu()[$id];
  7.         }
  8.         return $result;
  9.     }
  1.         // Get the id of the active menu item
  2.         $menu $this->getMenu();
  3.         $item $menu->getActive();
  4.         if (!$item) {
  5.             $item $menu->getItem($this->input->getInt('Itemid'null));
  6.         }
  7.         $id 0;
  8.         if (\is_object($item)) {
SiteApplication->getTemplate(true) in D:\xampp\htdocs\iric\libraries\src\Error\Renderer\HtmlRenderer.php (line 50)
  1.     public function render(\Throwable $error): string
  2.     {
  3.         $app Factory::getApplication();
  4.         // Get the current template from the application
  5.         $template $app->getTemplate(true);
  6.         // Push the error object into the document
  7.         $this->getDocument()->setError($error);
  8.         // Add registry file for the template asset
HtmlRenderer->render(object(mysqli_sql_exception)) in D:\xampp\htdocs\iric\libraries\src\Exception\ExceptionHandler.php (line 136)
  1.                     'subject'  => $app,
  2.                     'document' => $renderer->getDocument(),
  3.                 ])
  4.             );
  5.             $data $renderer->render($error);
  6.             // If nothing was rendered, just use the message from the Exception
  7.             if (empty($data)) {
  8.                 $data $error->getMessage();
  9.             }
ExceptionHandler::render(object(mysqli_sql_exception)) in D:\xampp\htdocs\iric\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.     }
  8.     /**
  9.      * Render the error page based on an exception.
  10.      *
ExceptionHandler::handleException(object(mysqli_sql_exception)) in D:\xampp\htdocs\iric\libraries\src\Application\CMSApplication.php (line 336)
  1.             );
  2.             // Trigger the onError event.
  3.             $this->dispatchEvent('onError'$event);
  4.             ExceptionHandler::handleException($event->getError());
  5.         }
  6.         // Trigger the onBeforeRespond event.
  7.         $this->dispatchEvent(
  8.             'onBeforeRespond',
CMSApplication->execute() in D:\xampp\htdocs\iric\includes\app.php (line 58)
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application $app;
  3. // Execute the application.
  4. $app->execute();
require_once('D:\\xampp\\htdocs\\iric\\includes\\app.php') in D:\xampp\htdocs\iric\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 dirname(__FILE__) . '/includes/app.php';

mysqli_sql_exception

Access denied for user 'root'@'localhost' (using password: YES)

  1.                 $this->options['ssl']['cipher']
  2.             );
  3.         }
  4.         // Attempt to connect to the server, use error suppression to silence warnings and allow us to throw an Exception separately.
  5.         $connected = @$this->connection->real_connect(
  6.             $this->options['host'],
  7.             $this->options['user'],
  8.             $this->options['password'],
  9.             null,
  10.             $this->options['port'],
mysqli->real_connect('localhost', 'root', object(SensitiveParameterValue), null, 3306, null, 0) in D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php (line 285)
  1.                 $this->options['ssl']['cipher']
  2.             );
  3.         }
  4.         // Attempt to connect to the server, use error suppression to silence warnings and allow us to throw an Exception separately.
  5.         $connected = @$this->connection->real_connect(
  6.             $this->options['host'],
  7.             $this->options['user'],
  8.             $this->options['password'],
  9.             null,
  10.             $this->options['port'],
  1.      * @since   2.0.0
  2.      */
  3.     #[\ReturnTypeWillChange]
  4.     public function open($save_path$session_id)
  5.     {
  6.         $this->db->connect();
  7.         return true;
  8.     }
  9.     /**
DatabaseHandler->open('\\xampp\\tmp', '60c990edbdc5c126b986eaf8d1ab4a9c')
  1.             throw new \RuntimeException(
  2.                 sprintf('Failed to start the session because headers have already been sent by "%s" at line %d.'$file$line)
  3.             );
  4.         }
  5.         if (!session_start()) {
  6.             throw new \RuntimeException('Failed to start the session');
  7.         }
  8.         $this->isActive();
  9.         $this->closed  false;
  1.                 $this->setId($session_clean);
  2.                 $cookie->set($session_name''time() - 3600);
  3.             }
  4.         }
  5.         parent::start();
  6.         // Try loading data from the session
  7.         if (!empty($_SESSION['joomla'])) {
  8.             $this->data unserialize(base64_decode($_SESSION['joomla']));
  9.         }
  1.     {
  2.         if ($this->isStarted()) {
  3.             return;
  4.         }
  5.         $this->store->start();
  6.         $this->setState(SessionState::ACTIVE);
  7.         // Initialise the session
  8.         $this->setCounter();
  1.      * @since   1.0
  2.      */
  3.     public function has($name)
  4.     {
  5.         if (!$this->isActive()) {
  6.             $this->start();
  7.         }
  8.         return $this->store->has($name);
  9.     }
  1.                 $name $args[2] . '.' $name;
  2.             }
  3.         }
  4.         if (parent::has($name)) {
  5.             // Parent is used because of b/c, can be changed in Joomla 6
  6.             return parent::get($name$default);
  7.         }
  8.         /*
Session->get('user') in D:\xampp\htdocs\iric\libraries\src\Factory.php (line 372)
  1.                 __CLASS__
  2.             ),
  3.             E_USER_DEPRECATED
  4.         );
  5.         $instance self::getApplication()->getSession()->get('user');
  6.         if (\is_null($id)) {
  7.             if (!($instance instanceof User)) {
  8.                 $instance User::getInstance();
  9.             }
  1.      *
  2.      * @since   3.2
  3.      */
  4.     protected function initialiseApp($options = [])
  5.     {
  6.         $user Factory::getUser();
  7.         // If the user is a guest we populate it with the guest user group.
  8.         if ($user->guest) {
  9.             $guestUsergroup ComponentHelper::getParams('com_users')->get('guest_usergroup'1);
  10.             $user->groups   = [$guestUsergroup];
SiteApplication->initialiseApp() in D:\xampp\htdocs\iric\libraries\src\Application\SiteApplication.php (line 238)
  1.      * @since   3.2
  2.      */
  3.     protected function doExecute()
  4.     {
  5.         // Initialise the application
  6.         $this->initialiseApp();
  7.         // Mark afterInitialise in the profiler.
  8.         JDEBUG $this->profiler->mark('afterInitialise') : null;
  9.         // Route the application
  1.             $this->sanityCheckSystemVariables();
  2.             $this->setupLogging();
  3.             $this->createExtensionNamespaceMap();
  4.             // Perform application routines.
  5.             $this->doExecute();
  6.             // If we have an application document object, render it.
  7.             if ($this->document instanceof \Joomla\CMS\Document\Document) {
  8.                 // Render the application output.
  9.                 $this->render();
CMSApplication->execute() in D:\xampp\htdocs\iric\includes\app.php (line 58)
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application $app;
  3. // Execute the application.
  4. $app->execute();
require_once('D:\\xampp\\htdocs\\iric\\includes\\app.php') in D:\xampp\htdocs\iric\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 dirname(__FILE__) . '/includes/app.php';

Stack Traces 2

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

  at D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php:138
  at mysqli->prepare('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `iric_menu` AS `m`
LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE 
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND 
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND 
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?)
ORDER BY `m`.`lft`')
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php:138)
  at Joomla\Database\Mysqli\MysqliStatement->__construct(object(mysqli), 'SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `iric_menu` AS `m`
LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE 
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND 
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND 
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?)
ORDER BY `m`.`lft`')
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:1020)
  at Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `iric_menu` AS `m`
LEFT JOIN `iric_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE 
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND 
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND 
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`')
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\DatabaseDriver.php:1785)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (D:\xampp\htdocs\iric\libraries\src\Menu\SiteMenu.php:166)
  at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()
     (D:\xampp\htdocs\iric\libraries\src\Cache\Controller\CallbackController.php:51)
  at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
     (D:\xampp\htdocs\iric\libraries\src\Menu\SiteMenu.php:179)
  at Joomla\CMS\Menu\SiteMenu->load()
     (D:\xampp\htdocs\iric\libraries\src\Menu\AbstractMenu.php:333)
  at Joomla\CMS\Menu\AbstractMenu->getMenu()
     (D:\xampp\htdocs\iric\libraries\src\Menu\AbstractMenu.php:164)
  at Joomla\CMS\Menu\AbstractMenu->getItem(null)
     (D:\xampp\htdocs\iric\libraries\src\Application\SiteApplication.php:434)
  at Joomla\CMS\Application\SiteApplication->getTemplate(true)
     (D:\xampp\htdocs\iric\libraries\src\Error\Renderer\HtmlRenderer.php:50)
  at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(mysqli_sql_exception))
     (D:\xampp\htdocs\iric\libraries\src\Exception\ExceptionHandler.php:136)
  at Joomla\CMS\Exception\ExceptionHandler::render(object(mysqli_sql_exception))
     (D:\xampp\htdocs\iric\libraries\src\Exception\ExceptionHandler.php:73)
  at Joomla\CMS\Exception\ExceptionHandler::handleException(object(mysqli_sql_exception))
     (D:\xampp\htdocs\iric\libraries\src\Application\CMSApplication.php:336)
  at Joomla\CMS\Application\CMSApplication->execute()
     (D:\xampp\htdocs\iric\includes\app.php:58)
  at require_once('D:\\xampp\\htdocs\\iric\\includes\\app.php')
     (D:\xampp\htdocs\iric\index.php:32)                
[1/2] mysqli_sql_exception
mysqli_sql_exception:
Access denied for user 'root'@'localhost' (using password: YES)

  at D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:285
  at mysqli->real_connect('localhost', 'root', object(SensitiveParameterValue), null, 3306, null, 0)
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:285)
  at Joomla\Database\Mysqli\MysqliDriver->connect()
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\session\src\Handler\DatabaseHandler.php:223)
  at Joomla\Session\Handler\DatabaseHandler->open('\\xampp\\tmp', '60c990edbdc5c126b986eaf8d1ab4a9c')
  at session_start()
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\session\src\Storage\NativeStorage.php:459)
  at Joomla\Session\Storage\NativeStorage->start()
     (D:\xampp\htdocs\iric\libraries\src\Session\Storage\JoomlaStorage.php:313)
  at Joomla\CMS\Session\Storage\JoomlaStorage->start()
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\session\src\Session.php:396)
  at Joomla\Session\Session->start()
     (D:\xampp\htdocs\iric\libraries\vendor\joomla\session\src\Session.php:327)
  at Joomla\Session\Session->has('user')
     (D:\xampp\htdocs\iric\libraries\src\Session\Session.php:194)
  at Joomla\CMS\Session\Session->get('user')
     (D:\xampp\htdocs\iric\libraries\src\Factory.php:372)
  at Joomla\CMS\Factory::getUser()
     (D:\xampp\htdocs\iric\libraries\src\Application\SiteApplication.php:570)
  at Joomla\CMS\Application\SiteApplication->initialiseApp()
     (D:\xampp\htdocs\iric\libraries\src\Application\SiteApplication.php:238)
  at Joomla\CMS\Application\SiteApplication->doExecute()
     (D:\xampp\htdocs\iric\libraries\src\Application\CMSApplication.php:306)
  at Joomla\CMS\Application\CMSApplication->execute()
     (D:\xampp\htdocs\iric\includes\app.php:58)
  at require_once('D:\\xampp\\htdocs\\iric\\includes\\app.php')
     (D:\xampp\htdocs\iric\index.php:32)