mysqli_sql_exception {#1135 #sqlstate: "HY000" }
$this->columnNames = false;
}
}
if ($this->columnNames !== false) {
$this->statement->store_result();
$this->rowBindedValues = array_fill(0, \count($this->columnNames), null);
$refs = [];
foreach ($this->rowBindedValues as $key => &$value) {
$this->columnNames = false;
}
}
if ($this->columnNames !== false) {
$this->statement->store_result();
$this->rowBindedValues = array_fill(0, \count($this->columnNames), null);
$refs = [];
foreach ($this->rowBindedValues as $key => &$value) {
foreach ($bounded as $key => $obj) {
$this->statement->bindParam($key, $obj->value, $obj->dataType);
}
try {
$this->executed = $this->statement->execute();
// If there is a monitor registered, let it know we have finished this query
if ($this->monitor) {
$this->monitor->stopQuery();
}
* @since 1.0
*/
public function getIterator($column = null, $class = \stdClass::class)
{
if (!$this->executed) {
$this->execute();
}
/**
* Calling setQuery free's the statement from the iterator which will break the iterator.
* So we set statement to null so that freeResult on the statement here has no affect.
)
->bind(':currentDate2', $currentDate)
->order($this->db->quoteName('m.lft'));
$items = [];
$iterator = $this->db->setQuery($query)->getIterator();
foreach ($iterator as $item) {
$items[$item->id] = new MenuItem((array) $item);
}
$referenceArgs = &$args;
}
// Just execute the callback if caching is disabled.
if (empty($this->options['caching'])) {
return \call_user_func_array($callback, $referenceArgs);
}
if (!$id) {
// Generate an ID
$id = $this->_makeId($callback, $args);
try {
/** @var CallbackController $cache */
$cache = $this->getCacheControllerFactory()->createCacheController('callback', ['defaultgroup' => 'com_menus']);
$this->items = $cache->get($loader, [], md5(\get_class($this)), false);
} catch (CacheExceptionInterface) {
try {
$this->items = $loader();
} catch (ExecutionFailureException $databaseException) {
$this->app->enqueueMessage(Text::sprintf('JERROR_LOADING_MENUS', $databaseException->getMessage()), 'warning');
* @since 1.5
*/
public function getMenu()
{
if (!$this->itemsLoaded) {
$this->load();
foreach ($this->items as $item) {
if ($item->home) {
$this->default[trim($item->language)] = $item->id;
}
*/
public function getItem($id)
{
$result = null;
if (isset($this->getMenu()[$id])) {
$result = &$this->getMenu()[$id];
}
return $result;
}
// Get the id of the active menu item
$menu = $this->getMenu();
$item = $menu->getActive();
if (!$item) {
$item = $menu->getItem($this->input->getInt('Itemid', null));
}
$id = 0;
if (\is_object($item)) {
public function render(\Throwable $error): string
{
$app = Factory::getApplication();
// Get the current template from the application
$template = $app->getTemplate(true);
// Push the error object into the document
$this->getDocument()->setError($error);
// Add registry file for the template asset
'subject' => $app,
'document' => $renderer->getDocument(),
])
);
$data = $renderer->render($error);
// If nothing was rendered, just use the message from the Exception
if (empty($data)) {
$data = $error->getMessage();
}
* @since 3.10.0
*/
public static function handleException(\Throwable $error)
{
static::logException($error);
static::render($error);
}
/**
* Render the error page based on an exception.
*
);
// Trigger the onError event.
$this->dispatchEvent('onError', $event);
ExceptionHandler::handleException($event->getError());
}
// Trigger the onBeforeRespond event.
$this->dispatchEvent(
'onBeforeRespond',
// Set the application as global app
\Joomla\CMS\Factory::$application = $app;
// Execute the application.
$app->execute();
* define() is used rather than "const" to not error for PHP 5.2 and lower
*/
define('_JEXEC', 1);
// Run the application - All executable code should be triggered through this file
require_once __DIR__ . '/includes/app.php';
$this->columnNames = false;
}
}
if ($this->columnNames !== false) {
$this->statement->store_result();
$this->rowBindedValues = array_fill(0, \count($this->columnNames), null);
$refs = [];
foreach ($this->rowBindedValues as $key => &$value) {
$this->columnNames = false;
}
}
if ($this->columnNames !== false) {
$this->statement->store_result();
$this->rowBindedValues = array_fill(0, \count($this->columnNames), null);
$refs = [];
foreach ($this->rowBindedValues as $key => &$value) {
foreach ($bounded as $key => $obj) {
$this->statement->bindParam($key, $obj->value, $obj->dataType);
}
try {
$this->executed = $this->statement->execute();
// If there is a monitor registered, let it know we have finished this query
if ($this->monitor) {
$this->monitor->stopQuery();
}
$this->statement->setFetchMode($fetchMode, $class);
}
}
// Execute the query and get the result set cursor.
$this->execute();
// Get the first row from the result set as an object of type $class.
$object = $this->fetchObject();
if ($object) {
$q = $this->db->getQuery(true)
->select('*')
->from('#__menu')
->where('alias ='.$this->db->quote($alias))
->where('published=1');
return $this->db->setQuery($q)->loadObject();
}
public function getUserId($username = ''){
if($this->app->get('sef_suffix')){
$username = str_replace('.html',"",$username);
}
$path = $uri->getPath();
$parts = explode('/', $path);
$sef = StringHelper::strtolower($parts[0]);
$uid = null;
foreach ($parts as $part) {
$menuAlias = $this->getMenuByAlias($part);
if(!empty($menuAlias)) break;
}
// Did we find the current and existing language yet?
$lang_code = $this->getLanguageCookie();
if ($lang_code) {
if (!\array_key_exists('parse' . $stage, $this->rules)) {
throw new \InvalidArgumentException(\sprintf('The %s stage is not registered. (%s)', $stage, __METHOD__));
}
foreach ($this->rules['parse' . $stage] as $rule) {
$rule($this, $uri);
}
}
/**
* Process the build uri query data based on custom defined rules
{
// Reset the tainted flag
$this->tainted = false;
// Do the preprocess stage of the URL parse process
$this->processParseRules($uri, self::PROCESS_BEFORE);
// Do the main stage of the URL parse process
$this->processParseRules($uri);
// Do the postprocess stage of the URL parse process
// Get the full request URI.
$uri = clone Uri::getInstance();
// It is not possible to inject the SiteRouter as it requires a SiteApplication
// and we would end in an infinite loop
$result = $this->getContainer()->get(SiteRouter::class)->parse($uri, true);
$active = $this->getMenu()->getActive();
if (
$active !== null
// Mark afterInitialise in the profiler.
JDEBUG ? $this->profiler->mark('afterInitialise') : null;
// Route the application
$this->route();
// Mark afterRoute in the profiler.
JDEBUG ? $this->profiler->mark('afterRoute') : null;
if (!$this->isHandlingMultiFactorAuthentication()) {
$this->sanityCheckSystemVariables();
$this->setupLogging();
$this->createExtensionNamespaceMap();
// Perform application routines.
$this->doExecute();
// If we have an application document object, render it.
if ($this->document instanceof \Joomla\CMS\Document\Document) {
// Render the application output.
$this->render();
// Set the application as global app
\Joomla\CMS\Factory::$application = $app;
// Execute the application.
$app->execute();
* define() is used rather than "const" to not error for PHP 5.2 and lower
*/
define('_JEXEC', 1);
// Run the application - All executable code should be triggered through this file
require_once __DIR__ . '/includes/app.php';
[2/2]
mysqli_sql_exception
|
---|
mysqli_sql_exception: Index for table 'yt093_menu' is corrupt; try to repair it at /home/lobelvil/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433 at mysqli_stmt->store_result() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433) at Joomla\Database\Mysqli\MysqliStatement->execute() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:651) at Joomla\Database\DatabaseDriver->execute() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1017) at Joomla\Database\DatabaseDriver->getIterator() (/home/lobelvil/public_html/libraries/src/Menu/SiteMenu.php:166) at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() (/home/lobelvil/public_html/libraries/src/Cache/Controller/CallbackController.php:51) at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false) (/home/lobelvil/public_html/libraries/src/Menu/SiteMenu.php:179) at Joomla\CMS\Menu\SiteMenu->load() (/home/lobelvil/public_html/libraries/src/Menu/AbstractMenu.php:333) at Joomla\CMS\Menu\AbstractMenu->getMenu() (/home/lobelvil/public_html/libraries/src/Menu/AbstractMenu.php:164) at Joomla\CMS\Menu\AbstractMenu->getItem(null) (/home/lobelvil/public_html/libraries/src/Application/SiteApplication.php:429) at Joomla\CMS\Application\SiteApplication->getTemplate(true) (/home/lobelvil/public_html/libraries/src/Error/Renderer/HtmlRenderer.php:50) at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(mysqli_sql_exception)) (/home/lobelvil/public_html/libraries/src/Exception/ExceptionHandler.php:136) at Joomla\CMS\Exception\ExceptionHandler::render(object(mysqli_sql_exception)) (/home/lobelvil/public_html/libraries/src/Exception/ExceptionHandler.php:73) at Joomla\CMS\Exception\ExceptionHandler::handleException(object(mysqli_sql_exception)) (/home/lobelvil/public_html/libraries/src/Application/CMSApplication.php:334) at Joomla\CMS\Application\CMSApplication->execute() (/home/lobelvil/public_html/includes/app.php:58) at require_once('/home/lobelvil/public_html/includes/app.php') (/home/lobelvil/public_html/index.php:32) |
[1/2]
mysqli_sql_exception
|
---|
mysqli_sql_exception: Index for table 'yt093_menu' is corrupt; try to repair it at /home/lobelvil/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433 at mysqli_stmt->store_result() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433) at Joomla\Database\Mysqli\MysqliStatement->execute() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:651) at Joomla\Database\DatabaseDriver->execute() (/home/lobelvil/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1257) at Joomla\Database\DatabaseDriver->loadObject() (/home/lobelvil/public_html/plugins/system/t4/src/t4/MVC/Router/T4.php:352) at T4\MVC\Router\T4->getMenuByAlias('multimedia') (/home/lobelvil/public_html/plugins/system/t4/src/t4/MVC/Router/T4.php:132) at T4\MVC\Router\T4->parseRule(object(SiteRouter), object(Uri)) (/home/lobelvil/public_html/libraries/src/Router/Router.php:423) at Joomla\CMS\Router\Router->processParseRules(object(Uri), 'preprocess') (/home/lobelvil/public_html/libraries/src/Router/Router.php:155) at Joomla\CMS\Router\Router->parse(object(Uri), true) (/home/lobelvil/public_html/libraries/src/Application/SiteApplication.php:767) at Joomla\CMS\Application\SiteApplication->route() (/home/lobelvil/public_html/libraries/src/Application/SiteApplication.php:243) at Joomla\CMS\Application\SiteApplication->doExecute() (/home/lobelvil/public_html/libraries/src/Application/CMSApplication.php:304) at Joomla\CMS\Application\CMSApplication->execute() (/home/lobelvil/public_html/includes/app.php:58) at require_once('/home/lobelvil/public_html/includes/app.php') (/home/lobelvil/public_html/index.php:32) |