Error Base De Datos

[imagina]

Hola a todos,

 

Os adjunto el error que me da por si alguien sabe donde esta el problema:

[PrestaShopDatabaseException]

Can't open file: './imaginagrupo/ps_shop_group.frm' (errno: 24)
 

SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri				FROM ps_shop_group gs				LEFT JOIN ps_shop s					ON s.id_shop_group = gs.id_shop_group				LEFT JOIN ps_shop_url su					ON s.id_shop = su.id_shop AND su.main = 1								WHERE s.deleted = 0					AND gs.deleted = 0									ORDER BY gs.name, s.name

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

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

  420.                 $this->result = $this->_query($sql);421.             }422.         }423. 424.         if (_PS_DEBUG_SQL_) {425.             $this->displayError($sql);426.         }427. 428.         return $this->result;429.     }430. 

• DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]

  638.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');639.             }640.             return $this->execute($sql, $use_cache);641.         }642. 643.         $this->result = $this->query($sql);644. 645.         if (!$this->result) {646.             $result = false;647.         } else {648.             if (!$array) {

• DbCore->executeS - [line 663 - classes/shop/Shop.php] - [1 Arguments]

  658. 				WHERE s.deleted = 0659. 					AND gs.deleted = 0660. 					'.$where.'661. 				ORDER BY gs.name, s.name';662. 663.         if ($results = Db::getInstance()->executeS($sql)) {664.             foreach ($results as $row) {665.                 if (!isset(self::$shops[$row['id_shop_group']])) {666.                     self::$shops[$row['id_shop_group']] = array(667.                         'id' =>                $row['id_shop_group'],668.                         'name' =>            $row['group_name'],

• ShopCore::cacheShops - [line 717 - classes/shop/Shop.php]

  712.      * @param bool $get_as_list_id713.      * @return array714.      */715.     public static function getShops($active = true, $id_shop_group = null, $get_as_list_id = false)716.     {717.         Shop::cacheShops();718. 719.         $results = array();720.         foreach (self::$shops as $group_id => $group_data) {721.             foreach ($group_data['shops'] as $id => $shop_data) {722.                 if ((!$active || $shop_data['active']) && (!$id_shop_group || $id_shop_group == $group_id)) {

• ShopCore::getShops - [line 244 - classes/Configuration.php] - [3 Arguments]

  239.      * @param int $id_lang240.      * @return array Values for all shops241.      */242.     public static function getMultiShopValues($key, $id_lang = null)243.     {244.         $shops = Shop::getShops(false, null, true);245.         $resultsArray = array();246.         foreach ($shops as $id_shop) {247.             $resultsArray[$id_shop] = Configuration::get($key, $id_lang, null, $id_shop);248.         }249.         return $resultsArray;

• ConfigurationCore::getMultiShopValues - [line 369 - classes/shop/Shop.php] - [1 Arguments]

  364.                 }365.             }366.         }367. 368.         $http_host = Tools::getHttpHost();369.         $all_media = array_merge(Configuration::getMultiShopValues('PS_MEDIA_SERVER_1'), Configuration::getMultiShopValues('PS_MEDIA_SERVER_2'), Configuration::getMultiShopValues('PS_MEDIA_SERVER_3'));370. 371.         if ((!$id_shop && defined('_PS_ADMIN_DIR_')) || Tools::isPHPCLI() || in_array($http_host, $all_media)) {372.             // If in admin, we can access to the shop without right URL373.             if ((!$id_shop && Tools::isPHPCLI()) || defined('_PS_ADMIN_DIR_')) {374.                 $id_shop = (int)Configuration::get('PS_SHOP_DEFAULT');

• ShopCore::initialize - [line 114 - config/config.inc.php]

  109. 110. $context = Context::getContext();111. 112. /* Initialize the current Shop */113. try {114.     $context->shop = Shop::initialize();115.     $context->theme = new Theme((int)$context->shop->id_theme);116.     if ((Tools::isEmpty($theme_name = $context->shop->getTheme()) || !Validate::isLoadedObject($context->theme)) && !defined('_PS_ADMIN_DIR_')) {117.         throw new PrestaShopException(Tools::displayError('Current theme unselected. Please check your theme configuration.'));118.     }119. } catch (PrestaShopException $e) {

• require - [line 36 - admin/index.php] - [1 Arguments]

  31. 32. if (!defined('PS_ADMIN_DIR')) {33.     define('PS_ADMIN_DIR', _PS_ADMIN_DIR_);34. }35. 36. require(_PS_ADMIN_DIR_.'/../config/config.inc.php');37. require(_PS_ADMIN_DIR_.'/functions.php');38. 39. //small test to clear cache after upgrade40. if (Configuration::get('PS_UPGRADE_CLEAR_CACHE')) {41.     header('Cache-Control: max-age=0, must-revalidate');

  Muchas gracias

 

[tuk66]

"Hay demasiados archivos abiertos"
Es un problema del servidor MySQL. Pregunte a su administrador del servidor.

 

"Too many open files"

It is a MySQL server issue. Ask your server administrator.

 

http://www.solomonson.com/content/how-fix-errno-24-mysql

http://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html

[imagina]

"Hay demasiados archivos abiertos"

Es un problema del servidor MySQL. Pregunte a su administrador del servidor.

 

"Too many open files"

It is a MySQL server issue. Ask your server administrator.

 

http://www.solomonson.com/content/how-fix-errno-24-mysql

http://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html

 

 

Muchas gracias tuk66,

 

El problema es de mi alojamiento?, ellos dicen que no se meten porque es culpa de la programación.

 

Al combinar unos atributos a un producto el sabado por la noche, me dio ese error, y no podia entrar en el back Office, ni en mi sitio, la base de datos desaparecio; y hoy por la mañana despues de responderme mi hosting que no habia ningún problema y que era culpa de la programación, ya veo la BD y funciona, un poco raro, no?

 

Lei hace tiempo que se le puede asignar mas capacidad, que el prestashop por defecto tiene poca asignada, pero no me acuerdo como buscarlo.

 

Muchas gracias

[tuk66]

Este problema es sin duda en el lado del servidor. Por desgracia, parece que al azar y es difícil de atrapar. Su proveedor debe aumentar los recursos de MySQL (número de archivos, y más).

 

This problem is definitely on the server side. Unfortunately, it appears randomly and it is hard to catch. Your provider should increase MySQL resources (number of files, and more).