Jump to content

[PrestaShopDatabaseException] ayuda


Recommended Posts

Hola amigos!

Resulta que ayer por la tarde repentinamente de un momento a otro nuestra prestashop dejo de funcionar, primero fue este error:
SQLSTATE[HY000] [2002] prestashop
luego de varias horas la página comenzó a funcionar correctamente sola! 

La alegría duro poco ya que despues de otras horas la página dio 500  server error y tampoco me dejaba ingresar al backoffice ya que me decia que el usuario y contraseña no existian.

segui leyendo y habilité el debug de errores, esto es lo que me dice la web ahora:

[PrestaShopDatabaseException]

Unknown storage engine 'InnoDB'
 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                    FROM ps_shop_url su
                    LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
                    WHERE (su.domain = 'ilariucci-muebles.com.ar' OR su.domain_ssl = 'ilariucci-muebles.com.ar')
                        AND s.active = 1
                        AND s.deleted = 0
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

at line 635 in file classes/db/Db.php

 

629.             WebserviceRequest::getInstance()->setError(500, '
 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630.         }
631.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632.         {
633.             if ($sql)
634.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635.             throw new PrestaShopDatabaseException($this->getMsgError());
636.         }
637.     }
638.
639.     /**
  • DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
    Argument [0]
    SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                        FROM ps_shop_url su
                        LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
                        WHERE (su.domain = 'ilariucci-muebles.com.ar' OR su.domain_ssl = 'ilariucci-muebles.com.ar')
                            AND s.active = 1
                            AND s.deleted = 0
                        ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
  • DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
    495.         {
    496.             $this->last_cached = true;
    497.             return $result;
    498.         }
    499.
    500.         $this->result = $this->query($sql);
    501.
    502.         if (!$this->result)
    503.             $result = false;
    504.         else
    505.         {
  • DbCore->executeS - [line 329 - classes/shop/Shop.php] - [1 Arguments]
    323.                     WHERE (su.domain = \''. pSQL($host).'\' OR su.domain_ssl = \''. pSQL($host).'\')
    324.                         AND s.active = 1
    325.                         AND s.deleted = 0
    326.                     ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC';
    327.
    328.             $result = Db::getInstance()->executeS($sql);
    329.
    330.             $through = false;
    331.             foreach ($result as $row)
    332.             {
    333.                 // An URL matching current shop was found
  • ShopCore::initialize - [line 97 - config/config.inc.php]
    91. $context = Context::getContext();
    92.
    93. /* Initialize the current Shop */
    94. try
    95. {
    96.     $context->shop = Shop::initialize();
    97.     $context->theme = new Theme((int)$context->shop->id_theme);
    98.     if ((Tools::isEmpty($theme_name = $context->shop->getTheme()) || !Validate::isLoadedObject($context->theme)) && !defined('_PS_ADMIN_DIR_'))
    99.         throw new PrestaShopException(Tools::displayError('Current theme unselected. Please check your theme configuration.'));
    100. }
    101. catch (PrestaShopException $e)
  • require - [line 27 - index.php] - [1 Arguments]
    Argument [0]
    /home/ilariucc/public_html/config/config.inc.php
alguna ayuda!
Link to comment
Share on other sites

  • nadie locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...