Consigliati da noi
Brand
Scegli il tuo marchio
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1483) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (315) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1482) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (40) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_23.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1760) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (221) AND (g_prod.idcategoria IN ( SELECT IDcatprod FROM (select * from g_categ_prod order by pid, IDcatprod) products_sorted, (select @pv := 30) initialisation where find_in_set(pid, @pv) and length(@pv := concat(@pv, ',', IDcatprod)) ) OR g_prod.idcategoria=30 ) GROUP BY collezione ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1482) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (79) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1482) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (88) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1483) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (231) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
[Mysql] : si è verificato un errore mysql ->
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_9cdc7_20.MAD' (Errcode: 24 "Too many open files")'
!Query Sql pre-statement :
object(PDOStatement)#38 (1) { ["queryString"]=> string(1483) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND g_prod.id_marchio IN (277) GROUP BY idcategoria ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }