nacxo Posted May 13, 2017 Share Posted May 13, 2017 Buenas, A ver si alguine puede ayudarnos... Hemos actualizado un tema de presta (1.6.1.10) a su ultima versión y ahora este esta dando fallos debido a que el uso de cpu salta en el server y la web devuelve el siguiente error: "Link to database cannot be established: SQLSTATE[42000] [1203] User Nos indican desde el hosting que se debe a que algunas conexi´ones a la bd quedan abiertas y nos pasan el siguiente listado pero no sabemos a que puede deberse,..... Podeis echarnos una mano??? Gracias. A continuación od dejo el listado de las sql que quedan abiertas en la web: 517287 Connect f47997ts_prestaf@localhost as anonymous on f47997ts_presta_final 517287 Query SET NAMES 'utf8' 517287 Query SET SESSION sql_mode = '' 517287 Query SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main 517287 Query 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 517287 Query SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop 517287 Query SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 517287 Query SELECT * 517287 Query SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory 517287 Query SELECT * 517287 Query SELECT l.*, ls.`id_shop` 517287 Query SELECT * 517287 Query SELECT * 517287 Query SELECT * 517287 Query SELECT domain, domain_ssl 517287 Query SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l 517287 Query SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` 517287 Query SELECT * FROM `ps_hook_alias` 517287 Query SELECT m.page, ml.url_rewrite, ml.id_lang 517287 Query SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column 517287 Query SELECT id_shop 517287 Query SELECT * 517287 Query SELECT id_shop 517287 Query SELECT * 517287 Query SELECT * 517287 Query SELECT id_shop 517287 Query SELECT * 517287 Query SELECT * 517287 Quit 517310 Connect f47997ts_prestaf@localhost as anonymous on f47997ts_presta_final 517310 Query SET NAMES 'utf8' 517310 Query SET SESSION sql_mode = '' 517310 Query SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main 517310 Query 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 517310 Query SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop 517310 Query SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 517310 Query SELECT * 517310 Query SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory 517310 Query SELECT * 517310 Query SELECT l.*, ls.`id_shop` 517310 Query SELECT * 517310 Query SELECT * 517310 Query SELECT * 517310 Query SELECT domain, domain_ssl 517310 Query SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l 517310 Query SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` 517310 Query SELECT * FROM `ps_hook_alias` 517310 Query SELECT m.page, ml.url_rewrite, ml.id_lang 517310 Query SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column 517310 Query SELECT id_shop 517310 Query SELECT * 517310 Query SELECT id_shop 517310 Query SELECT * 517310 Query SELECT * 517310 Query SELECT id_shop 517310 Query SELECT * 517310 Query SELECT * 517310 Quit 517312 Connect f47997ts_prestaf@localhost as anonymous on f47997ts_presta_final 517312 Query SET NAMES 'utf8' 517312 Query SET SESSION sql_mode = '' 517312 Query SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main 517312 Query 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 517312 Query SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop 517312 Query SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 517312 Query SELECT * 517312 Query SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory 517312 Query SELECT * 517312 Query SELECT l.*, ls.`id_shop` 517312 Query SELECT * 517312 Query SELECT * 517312 Query SELECT * 517312 Query SELECT domain, domain_ssl 517312 Query SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l 517312 Query SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` 517312 Query SELECT * FROM `ps_hook_alias` 517312 Query SELECT m.page, ml.url_rewrite, ml.id_lang 517312 Query SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column 517312 Query SELECT id_shop 517312 Query SELECT * 517312 Query SELECT id_shop 517312 Query SELECT * 517312 Query SELECT * 517312 Query SELECT id_shop 517312 Query SELECT * 517312 Query SELECT * 517312 Quit Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now